Install SQL Express Edition with Advanced Service (64-bit)
After install successful, SQL Server start but $SQL Server Agent not start
Check from SQL Server Configuration Manager -> SQL Server Agent (MSSQLSERVER)
State -> Stopped
Right click ->Property->Service->Start Mode change from "Disable" to "Automatic" and press "Apply"
SQL Server give the below message :
"The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. [0x80070422]"
Google and found this from Microsoft Site.
SQL Server Features that Are Not Supported in SQL Server Express
One of the component is "SQL Server Agent and SQL Server Agent Service"
That is nothing wrong with installation but SQL Server Agent and SQL Server Agent Service by design is not supported in SQL Server Express 2008
4 comments:
i couldnt get any solution.. can you please clarify the solution required for it.. i am getting same problem
SQL Server Agent and SQL Server Agent Service is not available in express version. We need SQL with Enterprise/Standard/Workgroup or web version for SQL Server Agent
Refer to
Features Supported by the Editions of SQL Server 2008
under Management Tools and look for SQL Server Agent
Hello
I recently had the same error, but i could start the sQL Server Agent with this:
1. Restart de SQL server Services
2. Put Start Type to Automatic.
3. Start SQL Server Agent Services.
What SQL Version you using? SQL 2008 express don't have SQL Server agent service
Post a Comment