June 8, 2007 at 4:11 am
Hi all,
The issue is bit rusty as I have not been able to track the root cause.
Few sites use asp pages to connect to database using the IP address which works for 2-3 hours and suddenly starts saying
Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Restarting the server solves the problem for another couple of hours and then same thing happens. No task running at this event occurs.
One thing to note is that the issue is resolved when using the server name instead of IP address.
Any hep will be greatly appreciated.
Keep smiling.........
June 8, 2007 at 6:49 am
Sorry if this is a stupid question, but have you checked the actual IP address on the machine before and after the problem occurs? While it is unlikely (three hours is a short period of time) but DHCP does have a lease period and I suppose something could be causing the server to request a new IP every there hours.
I know this is highly unlikely but I've seem weirder things happen.
James.
June 8, 2007 at 7:05 am
What kind of router do you have this server plugged to? Can you replace it and see if this solves the problem? Maybe the network card on the server is acting up. Or you need a new network card driver. Is it the SQL traffic that is blocked only or do you have some other issues? I assume you have some kind of firewall between the web server and the SQL server. Can you take it out for a while and see if this solves the problem?
This sounds like some bug in the IP protocol handling somewhere down the line.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
June 8, 2007 at 9:50 am
Definitely some type of network problem, but why use IP address? You should use an internal or even external FQDN, DNS name for the server. It will give you more flexibility and protection in the future. You can move to a new server, a cluster, or handle problems if needed with the DNS.
June 10, 2007 at 10:25 pm
Hello Dear,
When I use name instead of IP address it is working fine in case of ODBC or OLEDB Connection but for abstracted sqlconnection No one can work.
My sql server is 2000 and on my remote computer connection error is generated like " sqlserver2005" is not found.
I am work with Visual Studio 2005,if I am use Oledbconnection in place of sqlconnection than it is working well.
June 11, 2007 at 6:15 am
I assume you are connecting to servers that have static IP addresses. If this is the case, you can eliminate a lot of variables by adding the IP address to the host file on the machine or server that is acting as the client (I am not sure if this is a linked server or an actual client machine you are talking about).
If that eliminates your problem, you are probably looking at a routing or DHCP problem. If it does not, you are actually having a problem locally with the SQL client.
If you can provide some specifics like the type of program doing the connecting, network configuration, etc, it may help.
June 11, 2007 at 10:24 am
Their is not a lot of clues available so I'm going to make some assumptions and you can prove me wrong. The connection works with the computer name because you are switching to Named Pipes. What is you MAXImum connections settings for both NT and MS SQL Server and do you hit this number in about three hours. Typicaly you get a different messaeg about no available connections but its possible that you application is not gracefuly closing the connection. Using the telnet ipaddress port1344 command or telnet servername port1433 can provide some clues run this command after connections are refused and see if port 1433 is open. run a netstat -a -b on the server before the connections stop and then again after and see if a process has crashed. If it's a network error you'll see device error in the NT event log, I'm guessing this not the case.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply