February 17, 2003 at 2:53 pm
Has anyone found a fix for this.
When you click on the eclipse button to choose a server to connect to in Query Analyer or Click the arrow button in ODBC to choose the server name the program closes without any error.
Greg
February 18, 2003 at 8:45 am
There is a bug in the SQLBrowseConnect() routine. Typical cause of the error is you have a SQL Server on the network marked to hide. This puts it listening on TCP/2433 (hard-coded, can't be changed, also a bug). Also, even if you don't have a server toggled to hide, but it is listening on port 2433, it'll cause the error. Here's the relevant KB:
http://support.microsoft.com/default.aspx?scid=kb;en-us;814064
According to the updated article, there is now a supported fix, but you'll have to call Microsoft to get it.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 18, 2003 at 9:20 am
Working great after implementing the work around in the KB article you posted.
Thanks
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply