August 27, 2016 at 9:30 am
Hello I have a problem with the SQL Server 2008 R2 Agent not start after boot. If after boot I start manually starts perfect. I went to the SQL Logs and I see this in the SQL Agents Logs:
08/27/2016 09:19:35,,Information,[098] SQLServerAgent terminated (normally)
08/27/2016 09:19:34,,Error,[000] Failed to load any subsystems. Check errorlog for details.
08/27/2016 09:19:34,,Error,[165] ODBC Error: 0<c/> Unable to complete login process due to delay in opening server connection [SQLSTATE 08001]
Before that error I see in log of SQL in Windows NT section these errors:
Date8/27/2016 9:18:35 AM
LogWindows NT (Application)
SourceWinMgmt
Category(0)
Event3221231089
Computerschool
Message
The description for Event ID '-1073736207' in Source 'WinMgmt' cannot be found. The local computer may not have the necessary registry information or message DLL files to display the message, or you may not have permission to access them. The following information is part of the event:
Date8/27/2016 9:18:35 AM
LogWindows NT (Application)
SourceMSSQLSERVER
CategoryLogon
Event3221243928
UserNT AUTHORITY\SYSTEM
Computerschool
Message
Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
What could be the problem of the SQL Server agent that could not start automatic after reboot?
August 27, 2016 at 7:41 pm
I solved doing this:
Thank you anyway
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply