ADO Connection to SQL Server drop down does not always show servers
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.
精彩评论