update passwords for copied logins

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RobinMC - 25 Feb 2005 18:05 GMT

We have a "hot" disaster recovery site. The logins from outr production have
already been created on the disaster recovery site. however, I need a way to
be able to update the passwords on the disaster recovery server should a
recovery be necessay. sp_addlogin and other tools don't update they just
add. sp_password isn't applicable because it doesn't have the necessary
encryption parameter. Any help is greatly appreciated!!!

Reply to this Message

Andrew J. Kelly - 25 Feb 2005 18:11 GMT

You might be interested in these then:

INF: How to Remove Duplicate Rows From a Table

http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server

Signature

Andrew J. Kelly SQL MVP

> We have a "hot" disaster recovery site. The logins from outr production
> have
[quoted text clipped - 4 lines]
> add. sp_password isn't applicable because it doesn't have the necessary
> encryption parameter. Any help is greatly appreciated!!!

Reply to this Message