how to create ODBC Data source for a SQL Server 2008 on another machine?
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: alt text http://www.freeimagehosting.net/uploads/152679b8b6.jpg
Did you ensure that the SQL Server 2008 Browser service is running on the server?
Is there a firewall between the 2 machines?
If so, you will need to allow the applicable protocol and port.
精彩评论