Intellipaat Back

Explore Courses Blog Tutorials Interview Questions

Why is SQL Server Agent not starting?

0 votes
2 views
in SQL by (6.1k points)

I have installed my SQL Server 2014 on the top of Windows Server 2012. However, after the installation, the SQL Agent is not starting.

Can anyone help me solve this? 

Below is the screenshot:

enter image description here

1 Answer

0 votes
by (12.7k points)
edited by

It is because you have installed the SQL Server Express (mentioned by the instance name SQLEXPRESS), the SQL Server Agent is not supported in this version, it installs the service, however, it does not allow it to run. 

You should have one of the non-free SQL server editions in order to use SQL Server Agent.

Become a SQL expert with this complete SQL Training Course!

For more details on SQL, refer to the below SQL Tutorial video. 

Related questions

0 votes
1 answer
How to check for Is not Null And Is not Empty string in SQL server?
asked Jul 13, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
Why does NULL = NULL evaluate to false in SQL server
asked Jul 19, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
SQL Server 2014- can't connect to local db - can not find server
asked Dec 18, 2020 in SQL by Appu (6.1k points)

Browse Categories

© COPYRIGHT 2011-2024 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...