CODEWITHSUNDEEP
sql-serversql-server-2012-express
Abdullah Al Mamun
Abdullah Al Mamun

Reputation: 351

How to enable SQL Server Agent in SQL Server 2012 Express

When I try to start SQL Server Agent from SQL Server Configuration Manager
I get this error

the request failed or the service did not respond in a timely fashion.Consult the error log or other applicable error log for details

So how can I solve it?

Upvotes: 1

Views: 23959

Answers (2)

Alejandro
Alejandro

Reputation: 7819

The agent service is not included in the express editions of SQL Server, so it can't be enabled at all. Even though the error messages are misleading, the actual error is a licensing one. To get the agent you need to upgrade to any other edition. For just developing and testing the developer edition is the best choice.

Other than that, you can try to emulate such functionality by using the Windows task scheduler to run the SQL command line tools.

Upvotes: 1

DaddyCool
DaddyCool

Reputation: 11

Have you checked if your sqlServerAgent is running in windows admin tools / services? If it is stopped,just right click it and start it. Set also start type to automatic in next column.

Upvotes: 1

Related Questions