From: "Shane Young" <Shane @ SharePoint911 dot on
If you look at the security role for that account in the SQL
security>logins>Server Roles what do you see?

--
Shane Young
SharePoint911 - "SharePoint Help...Now!"


"Yousef" <Yousef(a)discussions.microsoft.com> wrote in message
news:24D4D7E8-6412-46F9-A56E-01A1C63A0CCC(a)microsoft.com...
> Thanks for your response. There is no other error messages. and the
> permissions for all SPS DB are db_owner.
>
> "Shane Young" wrote:
>
>> Look around a bit more. Are there any other error messages? What
>> permissions does your SPadmin account have on the SQL server?
>>
>> --
>> Shane Young
>> SharePoint911 - "SharePoint Help...Now!"
>>
>>
>> "Yousef" <Yousef(a)discussions.microsoft.com> wrote in message
>> news:C824E4D0-1815-4529-A00C-666012C15470(a)microsoft.com...
>> >I am trying to restore a Portal on a different machine.I restored my
>> > _SITE, _SERV and _PROF databases to the new server. I went to
>> > Sharepoint
>> > Admin, create portal site, and selected
>> > restore. Fill in the correct database names, and it starts going, put
>> > at
>> > 1%,
>> > it fails. The log shows this:
>> >
>> > 09/11/05 16:28:35:421 UNK 00000000 00000F3C Portal creation failed
>> > System.ApplicationException: Unable to find entry for Portal Site in
>> > sites
>> > hosted by database at Microsoft.SharePoint.Portal.Admin.c.f()
>> >
>> > Pls. Help
>> >
>>
>>
>>