November 19, 2003 at 7:07 am
I installed an app on a W2K server that connects to a sql server 2000 database. I can easily connect using Query Analyzer but the app cannot. The server cannot display a list of servers in QA or using osql -L. The app will only connect when I type the server name in. I can see the server name from other servers and workstations, but not from this app server.
I have a feeling the app's failure has something to do with the fact that it can't list the servers. Does anyone know how to troubleshoot this?
November 19, 2003 at 8:03 am
Does it work if you use the IP address instead of the name?
If so, you probably have a DNS server problem.
-SQLBill
November 19, 2003 at 9:51 am
I doubt it is a DNS problem check your protocol is it named pipes or tcp? Does the application only support WINS? osql -L will only list servers on the same subnet will not always return all servers. It only picks up servers "Broadcasting on the network" as well. Take a look at the method it is using to connect with.
Wes
November 21, 2003 at 2:40 pm
Did your network folks block UDP/1434 per chance?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
November 21, 2003 at 8:58 pm
Thanks everyone for your suggestions. I upgraded the app server's MDAC to 2.7 sp1 refresh and now I magically get the list.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply