Hey all,
I'm having a common problem under different circumstances. A little background information: I am running an "in-house" ASP web application in .NET 1.1 with a back-end in SQL Server 2000. The application is on a separate server from the SQL server. About 99% of the time users are able to sucessfully log into the SQL server and the other 1% of the time they get this nasty message "SQL Server does not Exist or Access Denied". When I get the dreaded call that it's "down" I simply remove the entire directory from the webserver and repost a copy of the application directory in place of it...and voila, it works...until the message comes up again. When this occurs, the logon page is displayed, but the first hit to the server (when logging on) produces this message. I'm sure it's not the SQL Server due to the fact that we have another application with the same setup running fine. I've looked into all the issue with IIS to no avail. Any ideas?
Thanks alot in advance,
Jason