DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 920114 - Last Review: May 3, 2010 - Revision: 2.0

Bug #: 451014 (SQLBUDT)

SYMPTOMS

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:
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."
When you examine the SQL Server error log, you receive the following error message:
Starting up database 'mssqlsystemresource'.
Error: 15209, Severity: 16, State: 1.
An error occurred during encryption.
For more information about how to view the SQL Server error log, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms187885.aspx (http://msdn2.microsoft.com/en-us/library/ms187885.aspx)
This 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.

CAUSE

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

WORKAROUND

To work around this problem, grant the Network Service account the Full Control permission on the Protect folder. To do this, follow these steps:
  1. Open My Computer.
  2. Type C:\Documents and Settings\NetworkService\Application Data\Microsoft in the address bar, and then press ENTER.
  3. Right-click the Protect folder, and then click Properties.
  4. In the folder Properties dialog box, click the Security tab.
  5. Under Group or user names, determine whether NETWORK SERVICE is listed. If NETWORK SERVICE is not listed, follow these steps to add this account:
    1. Click Add to show the Select Users or Groups dialog box.
    2. Click Locations, select your computer name in the Locations dialog box, and then click OK to return to the Select Users or Groups dialog box.
    3. Type Network Service in the Enter the object names to select box, and then click Check Names.
    4. Click OK to close the Select Users or Groups dialog box.
  6. Click NETWORK SERVICE under Group or user names, and then click to select the Allow check box for Full Control under Permissions for NETWORK SERVICE.
  7. Click OK to close the folder Properties dialog box.
  8. Click Retry in the error message dialog box to continue to install SQL Server Express Edition or SQL Server Express Edition with Advanced Services.
For a related issue that might occur when you are installing SQL on FAT partitions, see the following blog post on MSDN:
https://blogs.msdn.com/blakhani/archive/2009/11/24/sql-server-2005-express-setup-failure-with-error-an-error-occurred-during-encryption.aspx (https://blogs.msdn.com/blakhani/archive/2009/11/24/sql-server-2005-express-setup-failure-with-error-an-error-occurred-during-encryption.aspx)

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

APPLIES TO
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services
Keywords: 
kbsql2005setup kbsql2005express kbexpertiseadvanced kbtshoot kbprb KB920114
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support