December 14, 2007 at 1:49 am
I have two instances of SQL 2005 on a server.
Im log shipping from database A on the first instance to database B on the second instance.
The log shipping works perfectly fine but i loose all my DB users on the second instance.
I cant re-map the users to the DB because its in Standby - Read_only state.
Is there a way to connect the users without restoring the database.
December 14, 2007 at 1:57 am
You can use SSIS to transfer the logins from the primary server to the secondary server. Just make sure you specify the option to copy the SIDs with the logins so that the associated database users retain their association to the logins.
December 14, 2007 at 5:29 am
How do i do this ?
December 14, 2007 at 5:52 am
It's fairly easy to do.
Just open up SQL Server Business Intelligence Studio and create a new project.
On the left hand side, in the Tool Box, select the Transfer Logins Task and drag into the center screen. Then right-click the task and select Edit.
You'll then need to supply a source and destination server and set the CopySIDs option to True.
Alternatively, check out this KB article, which shows another method of doing it, which might prove simpler.
http://support.microsoft.com/kb/918992/
Hope that helps,
Karl
December 14, 2007 at 7:26 am
Thanx Karl
December 14, 2007 at 8:56 am
Did this work, in sql 2000 this can't be done until fail over, when you try to use packge to move logins, part of whart it tries to do is add users to the db which it can't they are RO
December 14, 2007 at 9:03 am
Did this work, in sql 2000 this can't be done until fail over, when you try to use packge to move logins, part of whart it tries to do is add users to the db which it can't they are RO
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply