June 4, 2002 at 12:47 pm
I took a backup of a 2000 user database and restored it to a different 2000 server.
Then DTS over logins.
It seems no passwords for logins came over with the DTS.
Is this always the case with Backup/Restore?
Is there a fix?
June 4, 2002 at 5:09 pm
The actual passwords are stored in master in syslogins table. DTS most does not pull over the password in the wizard. You should be able to move the passwords directly.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 4, 2002 at 7:39 pm
whay do you mean "move the passwords directly".
I have a Peopleosft Databases with 400 Users.
June 5, 2002 at 5:10 am
This should help. Check out "INF: How To Transfer Logins and Passwords Between SQL Servers (Q246133)" http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply