Can't start sql server Agent [closed]
Asked Answered
H

1

16

I want to start the SQL Server Agent (sql server 2008 R2 Enterprise edition), then I did:

  1. Open SQL Server configuration manager.
  2. SQL Server services.
  3. Right click on sql server agent.

but when I right click the start item is disable.

Hausner answered 5/4, 2013 at 12:47 Comment(4)
Is the SQL Server Agent service started?Tightlipped
I want to start sql server agentHausner
yes, but under services.msc, is your SQL Server Agent (MSSQLSERVER) service disabled?Tightlipped
check my answer and trySilverpoint
S
43

Go to run type services.msc

Right click on the SQL Server Agent (MSSQLSERVER)

Then check in the properties your startup type might be disabled change it to automatic or manual and try again it will enable the start option

Silverpoint answered 5/4, 2013 at 12:54 Comment(7)
I check it and set it ti manual , now start button is enable but when i click on it says : sql server agent service started and then stopped. some service stop automatically if they are not in use by another services or programsHausner
yes your are ri8 check out here to solve your problem sqlservercentral.com/Forums/Topic186166-146-1.aspxSilverpoint
sorry i edited my comment follow the link which i have given check out the other services which need to be startedSilverpoint
sorry i couldn't find the answer in follow link which comment?Hausner
This is not working properly.Whimwham
This also works on windows 10 with SQL Server 2017 (Which doesn't seem to provide the configuration manager)Unfetter
nullablereference.wordpress.com/2019/08/22/…Hendrix

© 2022 - 2024 — McMap. All rights reserved.