Select the product you need help with

"Portal creation failed System.Data.SqlClient.SqlException" error message is logged to the log file when you use SharePoint Central Administration to restore a portal site

Article ID: 827849 - View products that this article applies to.

SYMPTOMS

In a server farm deployment of Microsoft Office SharePoint Portal Server 2003, when you use the Create Portal Site for ServerName page of SharePoint Central Administration to restore a portal site, the restore operation does not complete successfully and an error message that is similar to the following is logged to the SPS_SiteCreation_PortalSiteName.log file:

<Time> Portal creation failed System.Data.SqlClient.SqlException: The user does not have the authority to run this operation at Microsoft.SharePoint.Portal.Data.a.c(SqlCommand A_0, Boolean A_1) at Microsoft.SharePoint.Portal.Data.a.c(SqlCommand A_0, Boolean A_1) at Microsoft.SharePoint.Portal.Data.a.b(SqlCommand A_0) at Microsoft.SharePoint.Portal.Data.a.b(SqlCommand A_0) at Microsoft.SharePoint.Portal.Topology.Database.d(a A_0, String A_1) at Microsoft.SharePoint.Portal.Topology.Database.a(String A_0, String A_1, String A_2, Boolean A_3) at Microsoft.SharePoint.Portal.Admin.c.b() at Microsoft.SharePoint.Portal.Admin.c.f()

You do not experience these symptoms when you restore the portal site by using the SharePoint Portal Server Data Backup and Restore tool (Spsbackup.exe).

Back to the top | Give Feedback

CAUSE

This problem may occur if the user account that is configured as the CentralAdminAppPool application pool account is not a member of the local Administrators group on the server that is running Microsoft SQL Server.

The restore operation calls the sp_changedbowner stored procedure. This stored procedure requires the sysadmin fixed server role in SQL Server. However, the CentralAdminAppPool application pool is a member of the securityadmin and dbcreator fixed server roles, and is not a member of the sysadmin fixed server role in SQL Server.

Back to the top | Give Feedback

WORKAROUND

To work around this problem, add the CentralAdminAppPool application pool account to the sysadmin fixed server role in SQL Server, and then use SharePoint Central Administration to restore the portal site. After you restore the portal site, remove the CentralAdminAppPool application pool from the sysadmin fixed server role.

To add the CentralAdminAppPool application pool account to the sysadmin fixed server role, follow these steps:

Determine the user account that is configured as the CentralAdminAppPool application pool account. To do so, follow these steps:
1. Start Microsoft Internet Information Services (IIS) Manager.
2. Expand ServerName, expand Application Pools, and then expand Application Pools.
3. Right-click CentralAdminAppPool, and then click Properties.
4. Click the Identity tab.
5. Under Configurable, note the user account that is displayed in the User name box.
6. Click Cancel, and then quit Internet Information Services (IIS) Manager.
Add the user account that is configured as the CentralAdminAppPool application account to the sysadmin server role in SQL Server. To do so, follow these steps:
1. Start SQL Server Enterprise Manager.
2. Expand ServerGroup, and then expand the appropriate server.
3. Expand Security, and then click Server Roles.
4. In the right pane, right-click System Administrators, and then click Properties.
5. Click the General tab, and then click Add.
6. In the Add Members dialog box, click the user account that is configured as the CentralAdminAppPool application pool account, click OK, and then click OK.

Back to the top | Give Feedback

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Back to the top | Give Feedback

MORE INFORMATION

For more information about how to back up and restore SharePoint Portal Server, see the "Backup and Restore" topic in the Microsoft Office SharePoint Portal Server 2003 Administration Guide. The Microsoft Office SharePoint Portal Server 2003 Administration Guide (Administrator's Help.chm) is located in the Docs folder in the root of the SharePoint Portal Server 2003 CD.

For more information about SharePoint Portal Server, visit the following Microsoft Web site:

http://office.microsoft.com/en-us/sharepointserver/FX101494611033.aspx

(http://office.microsoft.com/en-us/sharepointserver/FX101494611033.aspx)

Back to the top | Give Feedback