Knowledge Base

Error message when you try to upgrade SQL Server 2005 Express Edition to SQL Server 2005 Express Edition with Advanced Services: "Login failed for user 'sa'. Refer to server error logs and setup logs for more information"

Article ID: 919390

Article Last Modified on 6/6/2006

APPLIES TO

Microsoft SQL Server 2005 Express Edition with Advanced Services

Bug #: 431174 (SQLBUDT)
Bug #: 434760 (SQLBUDT)

SYMPTOMS

When you try to upgrade SQL Server 2005 Express Edition to SQL Server 2005 Express Edition with Advanced Services, you receive the following error message:

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

CAUSE

This problem occurs because SQL Server 2005 Express Edition with Advanced Services cannot upgrade or configure the existing files in the following folder:

C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Template Data

Note MSSQL.x represents the Instance ID for the instance of SQL Server 2005 Express Edition that is installed on the computer.

WORKAROUND

To work around this problem, follow these steps:

Click Cancel to exit the installation of SQL Server 2005 Express Edition with Advanced Services.
Open SQL Server Configuration Manager.
In the left pane, click SQL Server 2005 Services.
In the right pane, verify that the SQL Server 2005 Express Edition service is running. If the SQL Server 2005 Express Edition service is not running, follow these steps:
1. Double-click the SQL Server 2005 Express Edition service. The Properties dialog box appears.
2. Click Build-in account, and then click Local System in the drop-down list.
3. Click Apply, and then click Start to start the SQL Server 2005 Express Edition service.
4. After the SQL Server 2005 Express Edition service starts, click Network Service in the Build-in account list, and then click Apply.
  
  When you click Apply, you receive the following message:
  
  This will cause the service to be restarted. Do you want to continue?
  
  Click Yes when you receive this message.
  
  The SQL Server 2005 Express Edition service will be restarted with the new build-in account.
Delete all the files in the C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Template Data folder, and then reinstall SQL Server 2005 Express Edition with Advanced Services. To do this, use one of the following methods:
- Manually empty the Template Data folder before the upgrade. To do this, follow these steps:
  1. Open the following folder:
    
    C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Template Data
    
    Note To determine the instance ID of the instance of SQL Server 2005 Express Edition, follow these steps:
    1. Open SQL Server Configuration Manager.
    2. On the left pane, click SQL Server 2005 Services.
    3. On the right pane, double-click the instance of SQL Server 2005 Express Edition from which you are upgrading.
    4. In the Properties dialog box of the instance, click the Advanced tab.
    5. Note the Instance ID value.
  2. Delete all the files in this folder.
  3. Reinstall SQL Server 2005 Express Edition with Advanced Services.
- Uninstall the existing installation of SQL Server 2005 Express Edition before you upgrade. When you do this, the files in the following folder are also deleted:
  
  C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Template Data
  
  After you uninstall SQL Server 2005 Express Edition, install SQL Server 2005 Express Edition with Advanced Services.
  
  Note You do not lose your databases when you uninstall the existing SQL Server 2005 Express Edition installation. The databases still exist in the Data folder under the Instance ID for the instance of SQL Server 2005 Express Edition that you just uninstalled. You must reattach the databases after you install SQL Server 2005 Express Edition with Advanced Services. To do this, use either the SQLCMD utility or SQL Server 2005 Management Studio Express.

STATUS

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

MORE INFORMATION

We strongly recommend that you use one of the methods in step 5 of the "Workaround" section before you install SQL Server 2005 Express Edition with Advanced Services.

Keywords: kbtshoot kbprb kbupdate kbexpertiseadvanced kbsql2005setup kbsql2005express KB919390

Microsoft KB Archive/919390

Contents