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.