Re: Security Migration

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/22/04

  • Next message: Sue Hoegemeier: "Re: Ownership Chains Not Working?" 
    Date: Tue, 22 Jun 2004 09:12:56 +0530

    Hi,

    It is not required to move the logins every time. Only once you have to copy
    the syslogins table from the
    source to destination. THis will ensure that SID and password for logins are
    in sync with source.

    How to copy logins from one server to another:-

    Have a look into the below link , This script will provide a easy method to
    quickly generate a script that will move logins along with same sid and
    password from one server to other

    http://www.databasejournal.com/features/mssql/article.php/2228611

    Once you move logins to destination, on each restore the sysusers with
    automatically sync with syslogins. 

    --
Thanks
Hari
MCDBA
"Mike Dale" <MikeDale@discussions.microsoft.com> wrote in message
news:CDF205E9-6B75-4AB3-8CFE-4C52350EA66C@microsoft.com...
> Hey All, I realize this has probably been asked before, however I am a
fairly new DBA of SQL Server.
>
> I have just finished setting up SQL Server on our new hardware, and I have
used the previous day's comressed backup files to quickly copy the databases
from one server to another.  I then restored the databases on the new
server.  The only trouble is, each of the databases have Users that do not
exists as Logins on the new server.
>
> Is there an easy way to load all of the security login information from my
old server to the new server, such that it uses the same IDs in the
background, so that I don't have to rebuild the security settings?
>
> FYI:  I am moving from SQL Server 2000 SP3 on Server 2000 to SQL Server
2000 EE SP3+Hotfixes on Advanced Server 2003, if that makes any difference.
>
> Thanks,
  • Next message: Sue Hoegemeier: "Re: Ownership Chains Not Working?"

    Relevant Pages

    • Re: Compromised Server? Anyone recognize the suspect Services?
      ... I finally discovered that there was a whole folder structure under ... Event viewer shows normal logins, but I did not have it set to record ... there are a bunch of logins for Website Accounts created by the ... order to find those files on the Web Server I had to make sure that System ...
      (microsoft.public.windows.server.networking)
    • Re: Enabling STARTTLS in Exchange 2003 IMAP service?
      ... For the first, if you simply want to enable encrypted logins, then once you ... I guess I don't understand the need to have that command listed. ... > This section describes a means for "upgrading" an ordinary cleartext IMAP ... In order to use it, however, the server must advertise support for ...
      (microsoft.public.exchange.admin)
    • Re: Enabling STARTTLS in Exchange 2003 IMAP service?
      ... For the first, if you simply want to enable encrypted logins, then once you ... I guess I don't understand the need to have that command listed. ... > This section describes a means for "upgrading" an ordinary cleartext IMAP ... In order to use it, however, the server must advertise support for ...
      (microsoft.public.exchange2000.protocols)
    • Re: Enabling STARTTLS in Exchange 2003 IMAP service?
      ... For the first, if you simply want to enable encrypted logins, then once you ... I guess I don't understand the need to have that command listed. ... > This section describes a means for "upgrading" an ordinary cleartext IMAP ... In order to use it, however, the server must advertise support for ...
      (microsoft.public.exchange2000.admin)
    • Re: Transferring logins form 6.5 to 2000, anyone?!
      ... > server is case-insenstive, and the 2000 server is case-sensitive, then you ... > end up with all your passwords in upper case when they're copied. ... > /* Get 6.5 login information into the worktable, excluding system logins. ... >> Microsoft Online Support Engineer ...
      (microsoft.public.sqlserver.security)