Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Error message when you try to install SQL Server Express or SQL Server Express Edition or SQL Server Express Edition with Advanced Services: "The SQL Server service failed to start"
Article ID: 920114 - View products that this article applies to.
Bug #: 451014 (SQLBUDT)
When you try to install Microsoft SQL Server 2005 Express Edition or Microsoft SQL Server Express Edition with Advanced Services, you receive the following error message:
When you examine the SQL Server error log, you receive the following error message:
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
For more information about how to view the SQL Server error log, visit the following Microsoft Developer Network (MSDN) Web site:
Starting up database 'mssqlsystemresource'.
Error: 15209, Severity: 16, State: 1.
An error occurred during encryption.
http://msdn2.microsoft.com/en-us/library/ms187885.aspxThis problem may occur when you try to install SQL Server Express Edition or SQL Server Express Edition with Advanced Services on a Microsoft Windows XP Service Pack 2 (SP2)-based computer.
This problem occurs because the Network Service account does not have permissions on the following folder:
C:\Documents and Settings\NetworkService\Application Data\Microsoft\Protect
To work around this problem, grant the Network Service account the Full Control permission on the Protect folder. To do this, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.