Security is invalid when restoring a DB to another Server
From: Mike C. (noname_at_nonet.net)
Date: 05/22/03
- Next message: Stephen Dybing [MSFT]: "Re: grant permission on system sps,xps"
- Previous message: Jobi: "Re: Server login maps to DBO for a user account & can't change"
- Next in thread: Steve Thompson: "Re: Security is invalid when restoring a DB to another Server"
- Reply: Steve Thompson: "Re: Security is invalid when restoring a DB to another Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 22 May 2003 11:10:39 -0400
I made a backup of a database (DB1) from Server1.
I created a DB on Server2 with the name "DB1", then did a restore from the
backup.
I created a Security Login on Server2 with the same name as what is expected
from the DB1 database. When I attempt to assign database access to my newly
restored DB, I get a message that the Login already exists. I eventually had
to drop the user from the DB, create the Login, assign access to the DB,
then implicitly reassign his permissions to all the Stored Procs and various
tables in the DB. This was very time consuming and prone to errors.
Is there a way to accomplish this without all the overhead?
Thanks,
Mike C.
- Next message: Stephen Dybing [MSFT]: "Re: grant permission on system sps,xps"
- Previous message: Jobi: "Re: Server login maps to DBO for a user account & can't change"
- Next in thread: Steve Thompson: "Re: Security is invalid when restoring a DB to another Server"
- Reply: Steve Thompson: "Re: Security is invalid when restoring a DB to another Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
