Re: Move logins with passwords

From: MB (magnus.blomberg_at_skanska.se)
Date: 02/20/04

  • Next message: Roberto: "RE: ASP-Application"
    Date: Fri, 20 Feb 2004 15:11:52 +0100
    
    

    Thank you. It helped

    Regards Magnus

    "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
    news:OtBdL4w9DHA.1636@TK2MSFTNGP12.phx.gbl...
    >
    > 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 Server MVP
    >
    >
    > "MB" <magnus.blomberg@skanska.se> wrote in message
    > news:%23Qq4wnw9DHA.2404@TK2MSFTNGP12.phx.gbl...
    > > Hello!
    > >
    > > I will reinstall my server who has SQL server 2000, containing a few
    > > databases with logins.
    > > Which is the easiest way to store these on disk and when I have
    > reinstalled
    > > my server, add these to SQL again, hopefully containing passwords as
    well.
    > >
    > > Regards Magnus
    > >
    > >
    >
    >


  • Next message: Roberto: "RE: ASP-Application"

    Relevant Pages

    • Re: Error running Copy Database Wizard (CDW)
      ... I am not sure why the error but why not simply do a restore or an attach ... Issues When a Database Is Moved Between SQL Servers ... > I am using the Copy Database Wizard to copy a database from one SQL ...
      (microsoft.public.sqlserver.tools)
    • Re: Setting up Test of database using backup/restore
      ... Thanks Andrew...I have seen the references in your other posts but I just ... will the two be in production at one time, ... > I would go for the restore of the latest FULL backups as the least ... > Issues When a Database Is Moved Between SQL Servers ...
      (microsoft.public.sqlserver.server)
    • Re: How to cpy logins from one Server to another
      ... > to a New Location with Detach/Attach ... > Passwords Between SQL Servers ... > Issues When a Database Is Moved Between SQL Servers ...
      (microsoft.public.sqlserver.security)
    • RE: Moving databases to new server
      ... Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to ... When a Database Is Moved Between SQL Servers ...
      (microsoft.public.sqlserver.server)
    • Re: moving to a new server
      ... > to a New Location with Detach/Attach ... > Passwords Between SQL Servers ... > Issues When a Database Is Moved Between SQL Servers ...
      (microsoft.public.sqlserver.server)