PC Review


Reply
Thread Tools Rate Thread

Intermittent SQL Server does not exist or access

 
 
roxy636@yahoo.com
Guest
Posts: n/a
 
      2nd Nov 2005
ASP.NET application with intermittent returns of 503 errors with the
following message:
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied. SQL Server does not exist or access denied.

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.

Servers running Windows 2003 SQL 2000. This has been a problem for a
long time (less than .3% of the time). No code changes have been made.
The only changes was Windows SP1 and post SP patches on all servers.
The patching may have made this issue more pronounced.

Any suggestions from the experts?


Thanks,
Roxanne

 
Reply With Quote
 
 
 
 
Greg Burns
Guest
Posts: n/a
 
      2nd Nov 2005
Do you have a processor license, or a fixed number of cals? Are you running
out of connections?

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> ASP.NET application with intermittent returns of 503 errors with the
> following message:
> System.Data.SqlClient.SqlException: SQL Server does not exist or access
> denied. SQL Server does not exist or access denied.
>
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of
> the exception can be identified using the exception stack trace below.
>
> Servers running Windows 2003 SQL 2000. This has been a problem for a
> long time (less than .3% of the time). No code changes have been made.
> The only changes was Windows SP1 and post SP patches on all servers.
> The patching may have made this issue more pronounced.
>
> Any suggestions from the experts?
>
>
> Thanks,
> Roxanne
>



 
Reply With Quote
 
 
 
 
roxy636@yahoo.com
Guest
Posts: n/a
 
      3rd Nov 2005
Everything is licensed and there are no licensing warnings or errors in
the eventlogs? The site load follows the workday, and these events
happen at very low traffic times as well as busy ones.

We get these errors in "bursts" lasting 5-20 seconds, impacting all of
the web servers. Makes me think the issue originates with SQL.

Roxanne


Greg Burns wrote:
> Do you have a processor license, or a fixed number of cals? Are you running
> out of connections?
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > ASP.NET application with intermittent returns of 503 errors with the
> > following message:
> > System.Data.SqlClient.SqlException: SQL Server does not exist or access
> > denied. SQL Server does not exist or access denied.
> >
> > An unhandled exception was generated during the execution of the
> > current web request. Information regarding the origin and location of
> > the exception can be identified using the exception stack trace below.
> >
> > Servers running Windows 2003 SQL 2000. This has been a problem for a
> > long time (less than .3% of the time). No code changes have been made.
> > The only changes was Windows SP1 and post SP patches on all servers.
> > The patching may have made this issue more pronounced.
> >
> > Any suggestions from the experts?
> >
> >
> > Thanks,
> > Roxanne
> >


 
Reply With Quote
 
Mark Rae
Guest
Posts: n/a
 
      3rd Nov 2005
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> We get these errors in "bursts" lasting 5-20 seconds, impacting all of
> the web servers. Makes me think the issue originates with SQL.


Unlikely - if I were you, the first thing I'd check would be networking
hardware - cabling, routers, switches, hubs etc...


 
Reply With Quote
 
alorent_z@msn.com
Guest
Posts: n/a
 
      17th Nov 2005
Search no further....

http://support.microsoft.com/default...b;en-us;328476

Note, this answer took forever to find so I'm posting everywhere...

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect SQL server via USB give "Server does not exist or access denied" after few succeful connect. but always work wireless Vincent Microsoft Dot NET Compact Framework 4 5th Sep 2006 01:51 AM
SQL Server does not exist after moving to new Sql Server Geoff Microsoft ASP .NET 3 16th Jan 2006 06:54 AM
"SQL Server does not exist or access denied" frank Microsoft Access 2 18th Oct 2004 04:23 AM
SQL Server does not exist or access denied. gg Microsoft Dot NET Framework 2 7th Aug 2003 03:28 PM
SQL Server does not exist or access denied. Tom Jorgenson Microsoft ADO .NET 1 31st Jul 2003 09:06 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:34 PM.