January 7, 2009 at 2:45 pm
Hello,
we sql server 2000 standard edition with SP4 and suddenly the sql server has been stoped and its not starting at all. In the event viewer We found the following warning
Event Type:Warning
Event Source:ASP.NET 2.0.50727.0
Event Category:Web Event
Event ID:1309
Date:1/5/2009
Time:11:00:45 PM
User:N/A
Computer:ABC
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/5/2009 11:00:45 PM
Event time (UTC): 1/5/2009 9:36:37 PM
Event ID: e0e352b6daf1488d8684eda08e788d93
Event sequence: 2
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3svc/1/Root/Iabc-1-128758377775781250
Trust level: Full
Application Virtual Path: /abc
Application Path: C:\Inetpub\WWWRoot\abc\
Machine name: ABC
Process information:
Process ID: 1916
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SqlException
Exception message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Request information:
Request URL: http://10.10.10.10/abc/LogonForm.aspx
Request path: /abcUsers/LogonForm.aspx
User host address: 10.10.10.10
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
January 7, 2009 at 3:16 pm
Have you gone thru http://support.microsoft.com/kb/911816
MJ
January 7, 2009 at 3:24 pm
Yes, we went through this link, but did not get any clue...
thanks
January 7, 2009 at 4:06 pm
Please try starting sql server from command prmopt and see what message it pops up.
To start the default instance of SQL Server
From a command prompt, enter one of the following commands:
net start "SQL Server (MSSQLSERVER)"
-or-
net start MSSQLSERVER
To start a named instance of SQL Server
From a command prompt, enter one of the following commands. Replace with the name of the instance you want to manage.
net start "SQL Server ( instancename )"
-or-
net start MSSQL$ instancename
MJ
January 7, 2009 at 11:34 pm
What does the error log say? It should have some info about the shutdown, and it will have a lot of info about why the service won't start up.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 8, 2009 at 7:23 pm
I'm having trouble seeing what the warning in the event log have to do with your problem.
The error is related to IIS/.NET and a SQL Server 2005 database server, wheras you are running SQL2000.
SQL Errorlogs should provide a great deal of information.
January 10, 2009 at 10:53 am
Are you running SQL 2000, IIS, and SQL 2005 all on this server?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply