开发者

how to create ODBC Data source for a SQL Server 2008 on another machine?

开发者 https://www.devze.com 2022-12-25 16:05 出处:网络
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 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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号