Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gercr
Yak Posting Veteran
53 Posts |
 Posted - 2002-10-14 : 11:33:25
|
| Hi all. I try to restore a DB of SQL 2000 on a new box it create the logins but all are created with no Password, how I can to restore the lasted password storage ?? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-10-14 : 17:25:23
|
| Logins and Passwords are not stored in individual databases, but rather are in the master database. You might want to read this article from Microsoft on How To Transfer Logins and Passwords Between SQL Servers for some tips that might help you, assuming you still have your master database. |
 |
|
|
|
|
|
Restore DB on a new SQL instance