Re: Copying users to new server

From: Uri Dimant (urid_at_iscar.co.il)
Date: 03/22/05

  • Next message: marcmc: "RE: Copying users to new server" 
    Date: Tue, 22 Mar 2005 09:48:18 +0200

    Dejan
    I think although he/she has the same logins moving users to the new server
    may cause the problem due to the different SID of the logins.
    I'd go with two stored procedures provided by Microsoft to move logins.

    "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
    message news:eeySs4qLFHA.2988@TK2MSFTNGP14.phx.gbl...
    > > I'm new to SQL server and am installing a new server that I will be
    > copying
    > > from a old server to new. I've restored the databases but am trying to
    > copy
    > > over the users and security.
    > >
    > > Is there a simple way to copy over the users and security to the new
    > server?
    >
    > Yes, script them. In EM, right-click on your database, select All Tasks -
    > Generate SQL Script; on the Options tab, select
    > Script database users and database roles and
    > Script object-level permissions.
    > Generate the script and execute it in your new db.
    > BTW, I suppose you have the same logins.
    >
    > --
    > Dejan Sarka, SQL Server MVP
    > Associate Mentor
    > www.SolidQualityLearning.com
    >
    >

  • Next message: marcmc: "RE: Copying users to new server"

    Relevant Pages

    • Re: db repair
      ... Server. ... VB Script looks amazingly like VBA, since they're both based upon the same ... See http://www.mvps.org/access/general/gen0041.htm for the VBA code to ... this won't compact the database ...
      (microsoft.public.access.setupconfig)
    • RE: Creating a DB User *not* on current Machine
      ... detach/attach the database to a new server. ... Server.When you move a database from one server that is running SQL Server ... the security identification numbers of the logins in the master ...
      (microsoft.public.sqlserver.security)
    • Re: VB Script to dismount stores
      ... I have the exact script you are looking for in fact, ... I had to force my exchange hard drives back on so ... ' This code will dismount the selected mailbox database. ... I changed the server and store names but when I run the script I get ...
      (microsoft.public.exchange.admin)
    • RE: Cant call method "prepare" on an undefined value
      ... The error happen on the line to connect to that database: ... This script is working fine I located the script in same server as the ... I have one oracle database located at server A and setup the Oracle ... When I run the perl script, ...
      (perl.dbi.users)
    • Re: Logins
      ... no databases are checked, ... On the Server Roles tab, ... That server was upgraded to SQL Server ... moved, I recreated the SQL Server logins we had added, making sure that the ...
      (microsoft.public.sqlserver.security)