SQL Server service does not start | An error occurred during encryption.

Recently I was working on troubleshooting an issue with the SQL Server service. After installing SQL Server 2008 (Express Edition) on Windows 7, the SQL Server service was not starting up. The SQL Server Error Log had the following entries in it.

Starting up database 'mssqlsystemresource'.
The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
Error: 15209, Severity: 16, State: 1.
An error occurred during encryption.

I remembered reading Balmukund‘s blog post regarding a similar issue. But in this case SQL Server was not running on a FAT file system. The SQL Server service was configured to start using the Local System account. Hence this KB article was the right fit.

The reason for the SQL Server service not starting up is that the Network Service account does not have permissions on the
C:Documents and SettingsNetworkServiceApplication DataMicrosoftProtect folder.

After granting Full Control to the Network Service account on the Protect folder, SQL Server service started successfully.

4 thoughts on “SQL Server service does not start | An error occurred during encryption.

  1. Pingback: Something for the Weekend – SQL Server Links 11/02/11 | John Sansom - SQL Server DBA in the UK

  2. Pingback: SQL Server Service won’t start because I forgot to move the Resoruce database | SQLServerPedia

  3. Faded67

    The Documents and settings\networkservice folder does not exist on my machine. I am showing all hidden files and folders as well.

    Reply
  4. venky

    I get error 3417 when trying to start SQL service. I’ve already tried to decrompess my data files, add ‘network service’ to data folder, and tried to switch the sql server ‘log on’ from network service to local account and interface with desktop, all to no avail. It seems all the internet fixes that work for everyone else are not working for me, and I’m wondering if anyone can help me out?.

    Reply

Leave a Reply