CODEWITHSUNDEEP
sql-server-2008
sky scraper
sky scraper

Reputation: 2184

Installed SQL Server 2008 - SQL Server agent is disabled - How to fix this?

I think my Microsoft SQL Server database is inaccessible because the SQL server agent is disabled and cannot be started. How can I fix this problem?

For SQL Server agent
State - stopped running
Start mode - Other(Boot,System,Disabled or unknown)
Log On As - NT AUTHORITY\NETWORK SERVICE

For SQL Server Browser
State - running
Start mode - auto
Log On As - NT AUTHORITY\LOCAL SERVICE.

For SQL Server agent
State - running
Start mode - auto
Log On As - LocalSystem

Upvotes: 4

Views: 31396

Answers (1)

David W
David W

Reputation: 10184

If it is disabled, go to Control Panel->Administrative Tools->Services, and look for the SQL Server Agent. Right-click, and select "Properties." From the "Startup Type" dropdown, change from "Disabled" to "Automatic".

Clarification from comments: The "SQL Server Agent" service must be differentiated from the "SQL Server" database process. The former runs jobs, performs monitoring tasks, things of that nature, but it alone should not prevent "SQL Server" from running or allowing connections. If you note the SQL Server service is running (not the "Sql Server Agent"), and cannot connect to it, something else is likely at hand, such as a firewall, or is misconfigured in some way that is preventing connections.

If you note that the SQL Server service is not running, and will not start, there is a broader configuration issue you should research in the event logs.

Upvotes: 9

Related Questions