SQL Server Configuration Manager-Change Pending-Server Down
-
Server is unavailable. After attempted restart Confg manager reports change pending.
Are the databases recovering? What should I look at?
Help if you can.
-
Last entry in error log. Login failed for user x. Only administrators may connect at this time
-
I ended up doing a reboot and everything came back up clean. I'll review the logs and post again if there is anything interesting.
-
So, did you find something in the errorlogs?
-
I can help you, if you provide me the log
jay -
Thank you for your offer. This looks like the relevant part of the log.
When I rebooted the server it went down quickly and also came back up quickly but I could not get SQL Server responsive through the configuration manager.
If there is anything else I can provide please let me know.
A cancelled query may have been the precipitating event. Or it was coincidental.
Date,Source,Severity,Message
09/01/2011 14:34:57,Server,Unknown,The current event was not reported to the Windows Events log. Operating system error = 31(A device attached to the system is not functioning.). You may need to clear the Windows Events log if it is full.
09/01/2011 14:34:57,Server,Unknown,Error: 17054<c/> Severity: 16<c/> State: 1.
09/01/2011 14:34:57,Server,Unknown,The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required.
09/01/2011 14:34:56,Server,Unknown,SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
09/01/2011 14:25:36,Logon,Unknown,Login failed for user 'SSRS_Reporting_Credential'. Only administrators may connect at this time. [CLIENT: 192.168.1.130]
09/01/2011 14:25:36,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.
09/01/2011 14:25:16,Logon,Unknown,Login failed for user 'SSRS_Reporting_Credential'. Only administrators may connect at this time. [CLIENT: 192.168.1.130]
09/01/2011 14:25:16,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.
09/01/2011 14:25:07,Logon,Unknown,Login failed for user 'SSRS_Reporting_Credential'. Only administrators may connect at this time. [CLIENT: 192.168.1.130]
09/01/2011 14:25:07,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.
09/01/2011 14:00:17,Logon,Unknown,Login failed for user 'Mydomain\muser'. Only administrators may connect at this time. [CLIENT: 172.16.20.70]
09/01/2011 14:00:17,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.
09/01/2011 14:00:11,Logon,Unknown,Login failed for user 'Mydomain\muser'. Only administrators may connect at this time. [CLIENT: 172.16.20.70]
09/01/2011 14:00:11,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.
09/01/2011 14:00:11,Logon,Unknown,Login failed for user 'Mydomain\muser'. Only administrators may connect at this time. [CLIENT: 172.16.20.70]
09/01/2011 14:00:11,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.
09/01/2011 14:00:07,Logon,Unknown,Login failed for user 'Mydomain\muser'. Only administrators may connect at this time. [CLIENT: 172.16.20.70]
09/01/2011 14:00:07,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.
09/01/2011 14:00:07,Logon,Unknown,Login failed for user 'Mydomain\muser'. Only administrators may connect at this time. [CLIENT: 172.16.20.70]
09/01/2011 14:00:07,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.
09/01/2011 13:51:09,spid58,Unknown,Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
09/01/2011 13:50:16,Backup,Unknown,BACKUP failed to complete the command BACKUP LOG MultiSystemProcessing. Check the backup application log for detailed messages.
09/01/2011 13:50:16,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> State: 1.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply