how to create ODBC Data source for a SQL Server 2008 on another machine?
- by 5YrsLaterDBA
I was able to create an ODBC Data Source locally for my SQL Server 2008. Now I moved to anohter machine and want to connect from the new machine to that SQL Server 2008.
I know by default the SQL Server 2008 will not listen for the remote connection. I have enabled its Browser and TCP/IP.
Error window is like this: