March 8, 2006 at 2:34 pm
I have a sql server 2000 database table which collects data from a web site. It was working fine until this morning. But from 10 am today when Users try to submit the request its giving the message sql server does not found .
But when I try to submit the info from query analyzer using the same login as application Login its working fine. What could be the problem.
Thanks.
March 8, 2006 at 3:04 pm
It could be a lot of reasons!
Most probably something happened (not by itself) on the network: either an additonal firewalll rule was installed, protocol disabled, port changed etc. i also had one case when an entry for another domain was added to the TCP/IPproperties of some users so the domain suffix for the domain where SQL Server belonged was moved closer to the bottom of the list and it is only 5 or 6 that matters. The resolution for these users was to use Fully Qualified Domain Name for the server like MyServer.My.Domain.MyCompany.com or to add an entry to the client network utility that includes the domain name.
First of all, if we are talking about the web app, then the Client Network Utility entry should be on the web server, in case of the desktop app it should be on the user'scomputer.
Connect from the computer that have problems (in case of the web app connect from the web server) and try to ping the server by the first name and by the fully qualified name and by IP address. If you can do all of these try to create an ODBC source on this machine and check if connection succeed. Also, verify with your network people that they did not make changes to the firewall.
Try to check if one of the prococols is working: TCP/IP or Named Pipes.
Let us know about the results and we will help you more
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply