[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

SQL SERVER 2008 R2 Agent does not start after boot

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:

Date 8/27/2016 9:18:35 AM
Log Windows NT (Application)

Source WinMgmt
Category (0)
Event 3221231089
Computer school

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:



Date 8/27/2016 9:18:35 AM
Log Windows NT (Application)

Source MSSQLSERVER
Category Logon
Event 3221243928
User NT AUTHORITY\SYSTEM
Computer school

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?

One important thing is that we made a migration from an old server hardware to a new server hardware and IPs changed of course. All is working fine just the agent of sql server does not automatic start and like I mentioned before is required to start manually.

I almost not use ODBC I don't think that is the trouble for the auto start of sql server agent I configured 2 instances of ODBC years ago and I'm not interested in ODBC but I put here the logs because maybe each error at auto start the windows 2008 server R2 is the same cause of auto start of sql server agent.

Another note before migrate the server we updated windows 2008 to R2 and also SQL 2008 to R2 and worked fine but after change the IPs and new server began the problem.

Thank you
0
Alex E.
Asked:
Alex E.
  • 3
  • 2
2 Solutions
 
twolCommented:
You might go into SSMS and look for this user in the user list. See what the default database is set to when connecting. Make sure it is set to MASTER.
0
 
Alex E.Author Commented:
I went to SMSS but the user you mention to search is "NT AUTHORITY\SYSTEM" if yes that user exist and it has assigned like default database master then if that is the user to search all already is like you mention by default and the problem exist. Or is there other user to look for there what user if yes?

What could be?
0
 
twolCommented:
IN services, does the SQL Agent show a dependency on SQL Server?
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Alex E.Author Commented:
In services, the SQL Agent show:

This service depends on the following system components:

"SQL Server (MSSQLSERVER)"

The following system components depend on this service: Nothing is in ghost mode.
0
 
Alex E.Author Commented:
0
 
Daniel JonesData Research AnalystCommented:
Add your windows level user in following path:
Click on Start - Run - Secpol.msc Go to Local Policies - User right assignments
  1. Act as a part of the Operating system
  2. Bypass Traverse checking
  3. Lock pages in memory
  4. Log on as a service
  5. Log on a batch job
  6. Replace process level token
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now