Experts only: SQL Server does not exist or access denied.

Hi,
I'm accessing MS SQL server standard edition using ASP.net 1.1 web applications
my site has traffic ranking 84,000 on alexa.com. all web applicationsare mounted on One sigle Application pool. I have developed
monitoring webservice for monitoring the runtime errors occured duringtransactions, where I came across below errors all the time. duringheavy traffic.
1. SQL Server does not exist or access denied.
2. General network error. Check your network documentation.
3. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
First one is very important as Microsoft it self agree that it was bug in their products. How can I fix it.

http://support.microsoft.com/kb/328306

Client uses TCP/IP and Named Pipes.

I'm hoping to get it fixed using this thread.

Thanks,
Satalaj.

Have you checked the server loads on the machine that is running SQL during peak times?

I'm far from an expert on this subject, but it seems the server can't respond due to server load. How many concurrent users do you have during peaks?

Cheers!

/Eskil

|||

Yes, It is happening during peak load. How can I fix it.

Server DB size is 3GB and RAM 1GB. server uses 60% to 99% of RAM during peak load.

|||

Did you check the Eventviewer to see if your SQL Server Service is getting restarted/recycled during this peak loads that makes it unavailable for a few seconds/minutes.

|||

Hi urstop

If this is the case then all my webapplications should produce same erro, It is only happening for someweb applications mounted on one application domain.

|||

But are your other web applications also have lot of traffic. Because if the traffic is less for other applications then there are chances that during this error period we do not have any traffic coming to your other web applications. Just a thought.

|||I have written a webservice whichkeeps log of all error it gets called from webapplication if any erroroccured in web applications. Do you know how can I stop recycling ofthe SQL server. or Do I need to update the RAM on SERVER. if so howmuch RAM will be required for DB of size 3GB|||

You have mentioned that you have 1GB of RAM. I think that should be good enough for your DB size.

Also, does your eventviewer has events which indicate that SQL Service is getting recycled? Becuase it should not be a case where we are looking in a wrong area

|||

RAM/CPU limitations on your SQL server will usually result in slow queries during peak times and not error messages. Take a look at your page file usage and memory available to see if this might be the case. I would definately suggest adding a gb, 2gb should be plenty but extra never hurts.

Is the web server separate from the SQL server or are they on the same machine? If they are on the same separating the two might help as well.

|||

Hi Dustin, web and SQl server are separated. I'm going to see the log as per urstop suggession