Re: Restore of Portal Fails

Thanks for the info. I had to add the Sharepoint account I was using to the
admin group on th SQL server as well. Once I did that the restore went
smoothly. So far everything looks good. Thanks again for replying.

Ben
"Ben" <benhough@xxxxxxxxxxxxxxxxx> wrote in message
news:%23nc8WiaZGHA.3652@xxxxxxxxxxxxxxxxxxxxxxx
Hello, here is my situation. I am trying to move Sharepoint to a new
server. I have a small farm with one front end web server running the
job, search, etc. and one backend SQL server. I want to replace the web
server with a newer more powerful box.
Here is what I have done. I installed Sharepoint onto new server. I had
it create a new config DB. I created a web site in IIS and named it the
same as the site on the old server. When I installed Sharepoint I used
the same accounts I used on the original. Both installs are the same
version(SP1). The default file location in both web sites is the
same(C:\Intetpub\wwwroot). The install path of Sharepoint is the same on
both servers.
I open Sharepoint admin and click on Create Portal at which point I have
the option to restore. I choose this and my SQL server is selected and I
type in the name of the the 3 existing DB's(SITE, PROF, SERV). I then
select the website I created to extend in to. I hit ok and after a couple
seconds I get the error that the portal restore failed. I look through
the log and see the following entry..Obviously I am missing something.
Can someone help me out with what account it is referring to? Again I
used the same domain account used on the original install. This account
does have admin rights of the server. Thanks much.

Ben

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
Microsoft.SharePoint.Portal.Admin.c.f()



.

Relevant Pages

  • RE: SharePoint and Company Web not working
    ... How did you install the SharePoint 3.0, side by side install or In-place ... If you made in-place upgrade for companyweb, you must uninstall SharePoint ... Select Windows Small Business Server 2003, ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS2K3 Share Point Services re-install?
    ... Welcome to SBS newsgroup. ... I am not sure how you reinstall the sharepoint services on SBS 2003, ... 829114 How to remove and how to install the Windows Small Business Server ...
    (microsoft.public.windows.server.sbs)
  • RE: Reinstall Internal Web
    ... It did not fix the sharepoint but the ... This is a clean install of ClientX. ... > http://companyweb in Windows Small Business Server 2003 ... Rename Program Files\Microsoft Integration\Windows Small Business Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange 2007 OWA Broken - Please help!
    ... with the sharepoint services on the W2K3 installation CD. ... Well, once the new server was online, the only hiccup I ... accounts' passwords being out of sync (between AD & IIS). ... To install BES and have it work I had to install ...
    (microsoft.public.exchange.admin)
  • Re: Ive broken Sharepoint V2.0 by running aspnet_regiis.exe -i
    ... all Windows Small Business Server Website and Virtual ... SharePoint Central Administration ... Right click Companyweb and select Properties. ... After finish the installation, ...
    (microsoft.public.windows.server.sbs)