{}

Our Brands

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
How to Configure SQL Server Agent to Restart Services Automatically

Xssue
SQL Server and SQL Server Agent services automatically stop unexpectedly.

Product
Struxureware Power Monitoring 7.0.x

Power  Monitoring Expert 7.2.x

Power  Monitoring Expert 8.x

Power  Monitoring Expert 9.x

ION Enterprise

ION EEM

Environment
SQL Server 2005

SQL Server 2008 R2

SQL Server 2012

SQL Server 2014

Cause
Troubleshooting possible system issues.

Resolution
You can configure SQL Server Agent to restart the SQL Server and SQL Server Agent services automatically if they stop unexpectedly.
Configuring automatic restart of these services is a best practice because it may prevent a prolonged system outage if the server is
unmonitored and these services stop for some reason.

To configure automatic service restart :

1) Open the SQL Server Management Studio Management folder, right-click the SQL Server Agent entry, and select Properties.
2) On the General page, select the Auto Restart SQL Server If It Stops Unexpectedly check box.
3) Also select the Auto Restart SQL Server Agent If It Stops Unexpectedly check box.
4) Click OK.

Schneider Electric Ireland

How to Configure SQL Server Agent to Restart Services Automatically

Xssue
SQL Server and SQL Server Agent services automatically stop unexpectedly.

Product
Struxureware Power Monitoring 7.0.x

Power  Monitoring Expert 7.2.x 

Power  Monitoring Expert 8.x

Power  Monitoring Expert 9.x

ION Enterprise

ION EEM

Environment
SQL Server 2005

SQL Server 2008 R2

SQL Server 2012

SQL Server 2014

Cause
Troubleshooting possible system issues.

Resolution
You can configure SQL Server Agent to restart the SQL Server and SQL Server Agent services automatically if they stop unexpectedly.
Configuring automatic restart of these services is a best practice because it may prevent a prolonged system outage if the server is
unmonitored and these services stop for some reason.

To configure automatic service restart :

1) Open the SQL Server Management Studio Management folder, right-click the SQL Server Agent entry, and select Properties.
2) On the General page, select the Auto Restart SQL Server If It Stops Unexpectedly check box.
3) Also select the Auto Restart SQL Server Agent If It Stops Unexpectedly check box.
4) Click OK.

Schneider Electric Ireland

Explore more
Range:
Explore more
Range:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Range:
Explore more
Range:
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.