Re: Help I've been an idiot
- From: "carriolan@xxxxxxxxxxx" <carriolan@>
- Date: Tue, 04 Oct 2005 10:19:59 GMT
Hi Jasper - sorted. It was the login as you suspected - thanks for
your help - Carriolan
On Tue, 4 Oct 2005 07:33:33 +0100, "Jasper Smith"
<jasper_smith9@xxxxxxxxxxx> wrote:
>You need to make sure that you readd any logins that were mapped to database
>users in the attached databases. For the ASPNET login you can simply add it
>back and it will automatically remap to the database user account (as they
>will have the same SID). However for some logins you may need to do some
>extra work, see the links below.
>
>INF: How to Resolve Permission Issues When a Database is Moved Between SQL
>Servers
>http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872
>PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
>http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274188
.
- References:
- Help I've been an idiot
- From: carriolan@xxxxxxxxxxx
- Re: Help I've been an idiot
- From: carriolan@xxxxxxxxxxx
- Re: Help I've been an idiot
- From: Jasper Smith
- Help I've been an idiot
- Prev by Date: Re: SQL 6.5 upgrading to SQL 2005 suggestion needed
- Next by Date: A question about MSSQL licenses
- Previous by thread: Re: Help I've been an idiot
- Next by thread: Re: Trouble registering a server
- Index(es):
Relevant Pages
|