I’m trying to add a content database to an existing Web Application. I go into Central Administration > Application Management > Content Databases and Add a content database. I then get the error:
Attaching this database requires upgrade, which could time out the browser session. You must use the STSADM command ‘addcontentdb’ to attach this database.
The content database gets created in the separate SQL Server (2005). Running the STSADM command gives the following error in the error log:
The specified SPContentDatabase Name=blah_Content Parent=SPDatabaseServiceInstance has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object.
Nothing requires an upgrade, by following the steps in this article, I was able to create the content database and attach it to the web application.
Reproduced Content from Article (just in case link disappears):
Step a: Use SQL Query Analyzer to create the database
Use SQL Query Analyzer to create a new content database for use with the virtual server in Windows SharePoint Services. You cannot use the Create Database Wizard in the SQL Server Enterprise Manager tool to create the new database. Instead, run the following two queries in SQL Query Analyzer. When you use the following queries, make sure that you do the following:
· Replace each instance of WSS_Content in the queries with the name that you want to use for the database.
· Replace each instance of AdminVsAppPoolIdentity in the query with the account that is the SharePoint Central Administration virtual server application pool identity. This account is also the database owner (dbo) of the database.
· Replace each instance of ContentVsAppPoolIdentity in the query with the account that is the content virtual server application pool identity.
· Replace each instance of Domain in the query with the domain name.
Use the following query to create the database:
— Windows SharePoint Services Content Database Creation Script
— TODO: Change the database name from WSS_Content to the name of the database that you want to use
CREATE DATABASE [WSS_Content] COLLATE Latin1_General_CI_AS_KS_WS
exec sp_dboption [WSS_Content], autoclose, false
GO
Use the following query to configure permissions for the database that you created:
— Windows SharePoint Services Content Database Creation Script
use WSS_Content
— TODO: Change AdminVsAppPoolIdentity to the SharePoint Central Administration virtual server application pool account and change ContentVsAppPoolIdentity to the content virtual server application pool account.
DECLARE @AdminVsAppPoolIdentity nvarchar(128 )
DECLARE @ContentVsAppPoolIdentity nvarchar(128 )
SET @AdminVsAppPoolIdentity = N’Domain\AdminVsAppPoolIdentity’
SET @ContentVsAppPoolIdentity = N’Domain\ContentVsAppPoolIdentity’
EXEC sp_grantlogin @ContentVsAppPoolIdentity;
EXEC sp_grantlogin @AdminVsAppPoolIdentity;
— The following line will fail with error 15007 if @AdminVsAppPoolIdentity is the Network Service account. This is expected.
EXEC sp_changedbowner @AdminVsAppPoolIdentity;
— The following line will fail with error 15063 if the account is not the Network Service account. This is expected.
IF NOT EXISTS (SELECT * FROM sysusers WHERE name=@ContentVsAppPoolIdentity) EXEC sp_grantdbaccess @ContentVsAppPoolIdentity;
— The following line will fail with error 15410 if the account is not the Network Service account. This is expected.
EXEC sp_addrolemember ‘db_owner’, @ContentVsAppPoolIdentity;
Step b: Add the content database to the virtual server
Use Windows SharePoint Services Central Administration to add the content database to the virtual server. To do this, follow these steps.
-
Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
-
Click Application Management, and then click Content databases under SharePoint Web Application Management.
-
On the Manage Content Databases page, click Add a content database.
-
In the Web Application area, click the name of the Web application to which you want to add the content database.
-
In the Database Name and Authentication area, specify the name of the database, the name of the database server, and the authentication method.
-
In the Database Capacity Settings area, type the number that you want in the Number of sites before a warning event is generated box and in the Maximum number of sites that can be created in this database box, and then click OK.
Note If you configured permissions for the database with the NT Authority\Network Service account, you have to add the Network Service account to the System Administrators role in SQL Server before you can follow this step. You cannot make the Network Service account the database owner (dbo) of the database. You have to add the Network Service account to the System Administrators role before you can add the database to the virtual server. After you add the database to the virtual server, remove the Network Service account from the System Administrators role in SQL Server.