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" (919390)

WORKAROUND

1. Click Cancel to exit the installation of SQL Server 2005 Express Edition with Advanced Services.
2. Open SQL Server Configuration Manager.
3. In the left pane, click SQL Server 2005 Services.
4. 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.
5. 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.