Re: How to RESTORE USERS PASSWORDS in MS SQL 2K when you restore db from a bkup?
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 05/18/04
- Next message: chrystal boyle: "Restore Failure"
- Previous message: CC&JM: "Kill Process"
- In reply to: ktf: "Re: How to RESTORE USERS PASSWORDS in MS SQL 2K when you restore db from a bkup?"
- Next in thread: ktf: "Re: How to RESTORE USERS PASSWORDS in MS SQL 2K when you restore db from a bkup?"
- Reply: ktf: "Re: How to RESTORE USERS PASSWORDS in MS SQL 2K when you restore db from a bkup?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 May 2004 12:37:17 -0500
Can you give them an arbitrary password that they will set the first time they log in?
You may also find this helpful:
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
-- Keith "ktf" <anonymous@discussions.microsoft.com> wrote in message news:891BB281-C620-4CDE-B08A-A8C526FEFA7E@microsoft.com... > > I meant even me should not know about the users passwords, in event of restoring a database I am not allowed to create new passwords. All users should be able to use their original passwords to login. >
- Next message: chrystal boyle: "Restore Failure"
- Previous message: CC&JM: "Kill Process"
- In reply to: ktf: "Re: How to RESTORE USERS PASSWORDS in MS SQL 2K when you restore db from a bkup?"
- Next in thread: ktf: "Re: How to RESTORE USERS PASSWORDS in MS SQL 2K when you restore db from a bkup?"
- Reply: ktf: "Re: How to RESTORE USERS PASSWORDS in MS SQL 2K when you restore db from a bkup?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
