Re: Copy the Logins

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 07/01/04

  • Next message: Dan Guzman: "Re: SQL Server View needs permission on underlying tabel" 
    Date: Thu, 1 Jul 2004 14:39:16 +0530

    Hi,

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

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

    --
Thanks
Hari
MCDBA
"Sathu Kutti" <anonymous@discussions.microsoft.com> wrote in message
news:240bb01c45f48$62086d60$a301280a@phx.gbl...
> Hi,
>
>   I have SQL Server 2000 in Machine 'Machine1'. SQL Server
> name is 'SQL1'.   In SQL1, some miscellaneous databases
> and some logins are there.
>
>   In a new Machine, 'Machine2', I've installed the another
> SQL Server 2000 and the sql server name is 'SQL2'.
>
>   I have taken the backup of miscellaneous databases from
> SQL1 and restored it in SQL2.
>
>   Now what I want is, how to copy the user logins from
> SQL1 to SQL2,  because all the logins are stored in master
> database in SQL1.
>
>   kindly help, plz.
>
>
>
> Sathu Kutti.
  • Next message: Dan Guzman: "Re: SQL Server View needs permission on underlying tabel"

    Relevant Pages

    • Re: help :Deploying a preconfigured database
      ... Transfer Logins and Passwords Between Instances of SQL Server ... You will want to make sure that you create appropriate script files to set ... lets say that your config requires the SQL Server login 'user.' ...
      (microsoft.public.sqlserver.setup)
    • Re: A script to capture Orphan userids
      ... to create logins on "downstream" servers. ... Transfer Logins and Passwords Between Instances of SQL Server ... So I'd like to set up an automation using a script to catch orphan ids. ...
      (microsoft.public.sqlserver.server)
    • Copy the Logins
      ... I have SQL Server 2000 in Machine 'Machine1'. ... In SQL1, some miscellaneous databases ... I have taken the backup of miscellaneous databases from ... how to copy the user logins from ...
      (microsoft.public.sqlserver.security)
    • Re: recovering logins
      ... It will generate a script for you where the script includes ... sp_addlogins and sp_grantlogin for your logins. ... The SQL Server logins will be created using the ... > I'm used to sybase where you can just bcp the syslogins table. ...
      (microsoft.public.sqlserver.server)
    • Re: System Administrator Implied Permissions
      ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
      (microsoft.public.sqlserver.security)
    • Quantcast