Transfer Logins

From: Paul Ilacqua (pilacqu1_at_twcny.rr.com)
Date: 02/27/04 

Date: Thu, 26 Feb 2004 19:57:01 -0500

Is there a script to clone (SQL not NT) logins from one server to another
with SID's. I want to set up a reporting sever and transfer several hundred
logins. Drop existing and on reporting server and script new in. Thanks

Paul

Relevant Pages

  • Re: How to move schedule jobs from one box to another during upgrade
    ... that will script all logins on a server. ... keeps the same passwords and sids for the logins. ...
    (microsoft.public.sqlserver.server)
  • Re: Transfer Logins
    ... > Is there a script to clone logins from one server to another ... I want to set up a reporting sever and transfer several ... Drop existing and on reporting server and script new in. ...
    (microsoft.public.sqlserver.security)
  • Re: Copying Databases From Server to Another
    ... Manager, for SQL Server instances, which takes care to move logins and msdb ... you can perhaps full backup and restore on the new server users databases... ... you could then script the logins out and recreate them on the destination ...
    (microsoft.public.sqlserver.msde)
  • Re: Copying users to new server
    ... I think although he/she has the same logins moving users to the new server ... > Generate SQL Script; ... > Script database users and database roles and ...
    (microsoft.public.sqlserver.security)
  • Re: Same Internal Server Error from last two days
    ... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script ... # have to place corresponding `LoadModule' lines at this location so the ...
    (perl.beginners)