"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 (827849)
The information in this article applies to:
- Microsoft Office SharePoint Portal Server 2003
SYMPTOMSIn 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). CAUSEThis 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.WORKAROUNDTo 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:
- Start Microsoft Internet Information Services (IIS)
Manager.
- Expand
ServerName, expand
Application Pools, and then expand Application
Pools.
- Right-click CentralAdminAppPool, and
then click Properties.
- Click the Identity tab.
- Under Configurable, note the user
account that is displayed in the User name box.
- 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:
- Start SQL Server Enterprise Manager.
- Expand
ServerGroup, and then expand the
appropriate server.
- Expand Security, and then click
Server Roles.
- In the right pane, right-click System
Administrators, and then click Properties.
- Click the General tab, and then click
Add.
- 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.
STATUS Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
Modification Type: | Minor | Last Reviewed: | 1/9/2006 |
---|
Keywords: | kbDatabase kberrmsg kbpending kbBug KB827849 kbAudITPRO |
---|
|