开发者

ADO Connection to SQL Server drop down does not always show servers

开发者 https://www.devze.com 2023-03-18 05:26 出处:网络
When using the ADO Connection dialog to build a c开发者_运维技巧onnection string, the database server does not always show in the drop down of available servers. On some machines it does - on others i

When using the ADO Connection dialog to build a c开发者_运维技巧onnection string, the database server does not always show in the drop down of available servers. On some machines it does - on others it doesn't. I'm taking here about the local server as well - not just networked servers.

Who knows the magic?

Thanks

Ray


To the best of my knowledge that is reliant on SQL Browser.

http://msdn.microsoft.com/en-us/library/ms165724%28v=sql.90%29.aspx

So some instances may reside on machines that do not have the service running, or may not be listening for remote requests, or may not have the proper port open.

0

精彩评论

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