Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Restore a portal gives permission problems

  Asked By: Bhairavi    Date: Aug 23    Category: Sharepoint    Views: 1084

I am running Sharepoint 2003 in a small server farm configuration based on two
servers, one running SPS (tsp-bhbrssps001) and one running SQL server
(tsp-bhbrssql001). They are test servers on which I am running some tests,
including backup and restore of a portal.
When I try to run the "Restore a portal" function from the SPS Central
Administration, I first perform a "delete this portal" without selecting the SQL
databases (DexiaBan1_PROF, _SITE & _SERV) so they are not deleted. Then I try to
run the restore from those databases, and it always fails. Here is what I get in
the log (extract):

15:42:13 Portal creation failed System.Data.SqlClient.SqlException: User does
not have permission to perform this action. 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

This clearly means that SOME user does not have sufficient rights to perform
SOME operation, but the rest is foreign language to me. Has anyone any idea
about which user is concerned (current user, adminstrative account user, IIS
application pool user) and what is the action he cannot perform, and on which
server (Sharepoint or SQL)?



1 Answer Found

Answer #1    Answered By: Richard Davis     Answered On: Aug 23

Check what user is setup as the Application Pool. This user may be used to
connect to SQL and may not have the sufficient right sin SQL Server to delete
and overwrite the database. One other option will be to delete or detach the
database and see if this works

Didn't find what you were looking for? Find more on Restore a portal gives permission problems Or get search suggestion and latest updates.