SQL server agent starts, then stops automatically

Question

Hi,

SQL server (SQLXPRESS2014) is getting stopped automatically. In the event viewer I am getting the following error message.

SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).

Can you please let me know what could be the reason of this issue ?
Kindly waiting for your resposne.

Thanks,
Santosh

Answer 1

It is very simple: SQL Server Express Edition does not support SQL Server Agent. It is somewhat klunky that the service is still there, so it lures you to think that it should work. But it doesn't.

If you need Agent, you will aim for a paid version of SQL Server. Then again, there is always WIndows Task Scheduler.

Answer 2

Hi @Santosh Umarani ,

Yes. Agree with Erland. SQL Server Express Edition is a free version that does not include the SQL Agent.
About SQL Server Agent: See FAQ and examples about the SQL Server Agent

Best regards,
Seeya

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Thanks for the answer.

When I try to click connect on SQL Server 2014, I am getting following error message:

TITLE: Connect to Server

---

Cannot connect to <machinename>\SQLEXPRESS2014.

---

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.) (Microsoft SQL Server, Error: 1225)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=1225&LinkId=20476

---

The remote computer refused the network connection

---

BUTTONS:

OK

---

Can you please let me know what could be the reason and what is the solution?
Kindly waiting for your response.

Thanks,
Santosh

Answer 4

Hi @Santosh Umarani ,

Here is the how to fix it and gain your connectivity back:

-Click WindowsKey + R and enter services.msc
-Once Services opens scroll down and locate service SQL Server
-Highlight the service and click START
-Wait for the service to start and retry to connect to your MSSQL instance

Answer 5

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.) (Microsoft SQL Server, Error: 1225)

This error means that you were not able to reach SQL Server. There can be many reasons for this error:

• SQL Server is not running.
• There is no SQL Server instance with that name on the machine.
• There is a firewall blocking.
• The Browser service is not running
• Etc.

Here is a link to a troubleshooter you can use: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-2017