June 6, 2002 at 11:44 am
I am moving databases from one SQL Server 2000 Standard server to another SQL Server 2000 server.
By using either a Backup/Restore OR Detach/Attach, I cannot seem to get the password over for the logins.
I move it over, then DTS over logins, then run a re-sysn script to line up the Login to User. So for each Login I have the Database Access, for each User I have the associated Login and Permissions. The only thing I don't have is the password for each Login.
HELP!!!!!!!!!!!!!!!
June 6, 2002 at 12:18 pm
The passwords are in master, so unless you move that db, it won't help.
I think there is a kb article somewhere on this. You may be able to export the pwd field from sysxlogins and import on the new server if the logins are there. May be tricky.
Sorry I don't have more info at my fingertips.
Steve Jones
June 6, 2002 at 12:48 pm
I agree. You can use sp_addlogin to help in the process, has a switch to pass that indicates the password is already encrypted (which you would get from server a).
Andy
June 6, 2002 at 1:54 pm
The key is to convert the password to varbinary and then to use sp_addlogin and script encryption. Brian Moran, et. al., detail it here:
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7777
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply