"0x80040E14" or "HTTP 500" error message when you connect to your Windows SharePoint Services Web site after you install a Windows SharePoint Services service pack or a security update (841216)

RESOLUTION

To resolve this issue, use the Stsadm.exe command-line tool to force an upgrade of the content databases. To do this, follow these steps:

1. Click Start, click Run, type cmd in the Open box, and then click OK.
2. At the command prompt, type the following lines, and then press ENTER after each line:

   cd /d %commonprogramfiles%\Microsoft Shared\Web Server Extensions\60\Bin
   stsadm -o upgrade -forceupgrade

3. Type exit to quit Command Prompt.

Note If you run the Stsadm.exe command to manually force an upgrade of a Windows SharePoint Services installation, you may receive the following error message:You receive this error message because Windows SharePoint Services requires that the database owner (DBO) is one of the following:

• The account that the SharePoint Central Administration virtual server application pool is running as for Microsoft Windows authentication
• The SQL Server account that Windows SharePoint Services is connecting as for SQL Server authentication

If you are using Windows authentication, you must change the database ownership and permissions for the databases to grant permissions to the application pool accounts. If you are using SQL Server authentication, you must change the database ownership and permissions for the databases to grant permissions to the SQL Server account. To change the database ownership and permissions, use Microsoft SQL Query Analyzer.

You must change the DBO to be the Windows account or the SQL Server account that Windows SharePoint Services is running as. However, if for any reason you cannot make the change immediately, there is a temporary workaround. You can designate the Windows account or the SQL Server account that Windows SharePoint Services is running as to be the System Administrator in SQL Server. Then, you can continue running the stsadm -o upgrade command.

Note If your application pool account is running as Network Service and if you are using Windows authentication, you will not be able to designate Network Service as the DBO. Instead, you can grant System Administrators permissions in SQL Server to the Network Service group. For installations that use Windows authentication where Network Service is used as the application pool account that Windows SharePoint Services is running as, do not use the following procedure.

To change the DBO to be the Windows account or the SQL Server account that Windows SharePoint Services is running as, follow these steps:

1. Change the database ownership and permissions for the configuration database. To do this, follow these steps:
   1. On the computer that is running SQL Server, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
   2. In the Connect to SQL Server dialog box, type the server name in the SQL Server box, and then click OK.
   3. On the Query menu, click Change Database.
   4. In the Select Database of server_name box, click the configuration database (sts_config), and then click OK.
   5. In the Query pane, type the following appropriate query, depending on whether you are using Windows authentication or SQL Server authentication.
      
      If you are using Windows authentication, type the following.

      DECLARE @AdminVSAccount nvarchar(255)
      DECLARE @ContentVSAccount nvarchar(255)
      SET @ContentVSAccount = N'domain\contentaccount'; 
      SET @AdminVSAccount = N'domain\adminaccount'; 
      EXEC sp_grantlogin @ContentVSAccount;
      EXEC sp_changedbowner @AdminVSAccount;
      IF NOT EXISTS (SELECT * FROM sysusers WHERE name=@ContentVSAccount) 
        EXEC sp_grantdbaccess @ContentVSAccount; 
      EXEC sp_addrolemember 'db_owner', @ContentVSAccount; 
      EXEC sp_addsrvrolemember @AdminVSAccount, 'dbcreator'
      EXEC sp_addsrvrolemember @AdminVSAccount, 'securityadmin'

      Note In lines 3 and 4, replace domain\contentaccount and domain\adminaccount with the domain account for the content virtual server and the domain account for the SharePoint Central Administration virtual server. If the accounts are the same, SQL Query Analyzer will display an error message, but the process will still succeed.
      
      If you are using SQL Server authentication, type the following.

      DECLARE @SQLAccount nvarchar(255)
      SET @SQLAccount = N'sql_user_account'; 
      EXEC sp_changedbowner @SQLAccount;
      EXEC sp_addsrvrolemember @SQLAccount, 'dbcreator'
      EXEC sp_addsrvrolemember @SQLAccount, 'securityadmin'

      Note In line 2, replace sql_user_account with the name of the SQL Server account that Windows SharePoint Services is configured to use to connect to the computer that is running SQL Server. This must be an existing SQL Server account.
   6. Click Execute Query to update the database.
2. Change the database ownership and permissions for the content databases. To do this, follow these steps:
   1. On the computer that is running SQL Server, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
   2. In the Connect to SQL Server dialog box, type the server name in the SQL Server box, and then click OK.
   3. On the Query menu, click Change Database.
   4. In the Select Database of server_name box, click the content database you want to update, and then click OK.
   5. In the Query pane, type the following appropriate query, depending on whether you are using Windows authentication or SQL Server authentication.
      
      If you are using Windows authentication, type the following.

      DECLARE @AdminVSAccount nvarchar(255)
      DECLARE @ContentVSAccount nvarchar(255)
      SET @ContentVSAccount = N'domain\contentaccount'; 
      SET @AdminVSAccount = N'domain\adminaccount'; 
      EXEC sp_grantlogin @ContentVSAccount;
      EXEC sp_grantlogin @AdminVSAccount;
      EXEC sp_changedbowner @AdminVSAccount;
      IF NOT EXISTS (SELECT * FROM sysusers WHERE name=@ContentVSAccount) 
        EXEC sp_grantdbaccess @ContentVSAccount; 
      EXEC sp_addrolemember 'db_owner', @ContentVSAccount;

      Note In lines 3 and 4, replace domain\contentaccount and domain\adminaccount with the domain account for the content virtual server and the domain account for the SharePoint Central Administration virtual server. If the accounts are the same, SQL Query Analyzer will display an error message, but the process will still succeed. If you are using SQL Server authentication, in lines 3 and 4, replace domain\contentaccount and domain\adminaccount with the SQL Server account name.
      
      If you are using SQL Server authentication, type the following.

      DECLARE @SQLAccount nvarchar(255)
      SET @SQLAccount = N'sql_user_account'; 	
      EXEC sp_changedbowner @SQLAccount;

      Note In line 2, replace sql_user_account with the name of the SQL Server account that Windows SharePoint Services is configured to use to connect to the computer that is running SQL Server. This must be an existing SQL Server account.
   6. Click Execute Query to update the database.
3. Repeat the previous steps for each additional content database.
4. Verify that setting the DBO and the appropriate permissions was successful. To do this, follow these steps:
   1. On the computer that is running SQL Server, click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
   2. Under Databases, locate the configuration database, right-click the configuration database, and then click Properties.
   3. On the General tab, verify that the owner is the account that you specified in the queries. For SQL Server authentication, the owner is the SQL Server account. For Windows authentication, the owner is the application pool account that the SharePoint Central Administration virtual server is running as.
   4. Repeat these steps for each of the other content databases.