Re: update passwords for copied logins

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 13:13:18 -0500

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 

-- 
Andrew J. Kelly  SQL MVP
"RobinMC" <RobinMC@discussions.microsoft.com> wrote in message 
news:4B3122E7-4B23-4F42-8E39-F10C506E75BD@microsoft.com...
> 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!!!

Relevant Pages

  • Re: How to move SQL 2000 server to new hardware
    ... http://www.databasejournal.com/features/mssql/article.php/3379901 Moving ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore ... for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Access 97 to a more powerfull platform!?
    ... Moving to SQL Server is common when a database "outgrows" ... Design problems are far and away the usual reason why a database ...
    (microsoft.public.access.gettingstarted)
  • Re: Copy database
    ... Best way is either do backup and restore or attach it. ... http://www.databasejournal.com/features/mssql/article.php/3379901 Moving ... http://www.support.microsoft.com/?id=168001 User Logon and/or Permission ... for SQL Server ...
    (microsoft.public.sqlserver.tools)
  • Re: best method for switching to a new server
    ... I can get the moving the db thing, no prob, but it's the in between part ... > a Restore ... > for SQL Server ... >> to move the Sql Server 2K database from the old to the new. ...
    (microsoft.public.sqlserver.setup)
  • Re: MOVING SQL 2000 to a different computer, and domain
    ... http://msdn2.microsoft.com/en-us/library/ms345408.aspx Moving ... http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore ... for SQL Server ... articles on how to do a SQL move, but I cannot find one specific to my ...
    (microsoft.public.sqlserver.setup)