August 27, 2004 at 1:04 am
Hello
How can I transfer a existing database users to a existing database to the new server using a existing database.
August 30, 2004 at 8:00 am
This was removed by the editor as SPAM
August 31, 2004 at 10:09 am
Try using the DTS export wizard. Select the "Copy objects and data between SQL Server databases". In Advanced Copy Options, you can check "Copy database users and database roles" and "Copy SQL server logins".
Greg
Greg
August 31, 2004 at 11:14 pm
Thanks a lot...
Habib
September 6, 2004 at 2:20 am
Here are some pointers you can use:
MovingDB's between Servers : http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
Q246133 INF: How To Transfer Logins and Passwords Between SQL Servers
Q298897 Mapping Logins & SIDs after a Restore
Q168001 PRB: User Logon and/or Permission Errors After Restoring Dump
Q240872 How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
Q224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
All the above are KB articles and can be searched using the Q<number> from support.microsoft.com.
HTH,
Vinod Kumar
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply