SQL Server service will not Start

Published: June 1, 2015

 

Last Updated: 2015-11-12

 

Applies To

 

Symptoms

The SQL Server or Guard1 Plus service will not start. If Guard1 Plus was working and then after some time, it stopped working, it may be due to local group policy preventing the SQL Server service or Guard1 Plus service from starting. To review the local group policy, you need to have local admin rights on the workstation. If the group policy is pushed out from your network administrator you will not be be able to edit these rights. You will have to contact your IT department and request an exception for this Guard1 Plus workstation.

 

Cause

If you change the Report Server or SQL Server Windows service account name or password, you must restore the backup copy of the Reporting Services encryption key.If you do not have a backup of the encryption key, you will have to delete the current encryption key and refresh the reports. Deleting the encryption key will remove all stored data sources and credentials along with deactivating any subscriptions.

 

Resolution

If you do have a backup copy of the encryption key, follow these steps to restore this encryption key.
  1. Log in as a local administrator.
  2. Under Microsoft SQL server, Configuration Tools, open the Reporting Services Configuration Manager.
  3. Click Connect to select the report server instance.
  4. On the left hand side, open Encryption Keys.
  5. Click Restore. Browse to the backup encryption key file and enter the password.
  6. Click OK,
  7. The Results section should display that the backup key was restored successfully.
  8. Click Exit to close the Reporting Services Configuration Manager.

 

If you do not have a backup of the encryption key, you will have to perform these steps.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2013-2016 TimeKeeping Systems, Inc.