Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lepeniotis
Yak Posting Veteran
75 Posts |
 Posted - 2008-09-19 : 06:36:41
|
| Hi guys,Sometimes (very rear) I get this error [408] SQL Server MSSQLSERVER is clustered - AutoRestart has been disabledThe SQL Server holds the Biztalk 2006 Server's databases. The SQL Server Service shuts down and I can fix it with a restart at the SQL Server Service on the system services. But, Do you have any idea why is this happening and how can I fix it for not happening again?It is very important for me that the specific instance of SQL Server doesn't stop not even for a second, Because Biztalk can't operate and when I restart the service it takes me 42 seconds.Any suggestion will be appresiated.MSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-19 : 08:26:55
|
| Do you recent build on SQL Server? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-19 : 10:00:54
|
| I mean Service Packs and Patches. |
|
|
|
lepeniotis
Yak Posting Veteran
75 Posts |
Posted - 2008-09-19 : 10:22:34
|
| Yes it has SP2 and I think that the hotfixes are the latests. I will write you the messages from the log to tell me your opinion.MessageLogin failed for user .. Only administrators may connect at this time. [CLIENT:xxx.xx.xx.xx]Error: 18456, Severity: 14, State: 23Error: 18451, Severity: 14, State: 1The client was unable to reuse a session with SPID xxx, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.Error: 18056, Severity: 20, State: 23.Login failed for user ',......'. Only administrators may connect at this time.Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.Error: 18456, Severity: 14, State: 16.The thing is that this happens very rare but I have to find out why this is happening.Thank you very much in advanced.MSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
|
|
|
|
|
|
|
|
Biztalk 2006 shuts down SQL Server