Re: Restore SQL Security

From: Andrew J. Kelly (ajkellynospam@attbi.com)
Date: 03/25/03

  • Next message: Shannon Sheppard: "Re: sp_AddLogin" 
    From: "Andrew J. Kelly" <ajkellynospam@attbi.com>
Date: Mon, 24 Mar 2003 18:02:46 -0500

    It shouldn't be that much of a problem. You may want to browse thru these
    links as I am sure at least one of them will spark something:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546 Moving
    DB's between Servers
    Q246133 INF: How To Transfer Logins and Passwords Between SQL Servers
    Q298897 Mapping Logins & SIDs after a Restore
    Q168001 PRB: User Logon and/or Permission Errors After Restoring Dump
    Q240872 How to Resolve Permission Issues When a Database Is Moved Between
    SQL Servers

    Q224071 INF: Moving SQL Server Databases to a New Location with
    Detach/Attach 

    -- 
Andrew J. Kelly
SQL Server MVP
"Alma" <adcc69@hotmail.com> wrote in message
news:136001c2f254$57bdb3e0$3501280a@phx.gbl...
> Does somebody know about a tool or a way to restore SQL
> Security when restoring SQL 2000 databases? I've tried
> creating security scripts for the server and also for each
> database and then run those scripts on another server with
> the same DB, but I always have to manually fix it because
> passwords won't pass or some roles don't create, etc.
  • Next message: Shannon Sheppard: "Re: sp_AddLogin"

    Relevant Pages