Re: how to migrate users/logins with different domain account

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/12/05

  • Next message: Gianluca Torta: "mapping Windows credentials to access linked server" 
    Date: Tue, 12 Jul 2005 15:36:53 -0400

    There are no tools specific to this that I know of. But if you know how to
    do it manually you should be able to easily script this. Any thing you can
    do in EM can be done in simple TSQL. If you want to know what commands EM
    uses you can run profiler and see what commands it issues. Also see if
    these help:

    http://vyaskn.tripod.com/generate_scripts_repetitive_sql_tasks.htm

    http://vyaskn.tripod.com/sql_server_security_best_practices.htm

    http://www.sqldbatips.com/showcode.asp?ID=2 

    -- 
Andrew J. Kelly  SQL MVP
"Brian Brian" <BrianBrian@discussions.microsoft.com> wrote in message 
news:F2193C01-D4C8-4F76-9598-BE0B7D07CF69@microsoft.com...
> Hi all,
>
> Our company are changing domain names, but logins and group name will 
> remain
> the same (e.g. from DomainOld\brian to DomainNew\brian). As our sql boxes 
> are
> setup to use domain accounts (user and group), we need to setup users to 
> have
> same access rights as they had with old domain name. For example,
> DomainNew\brian need to have the exact same access as DomainOld\brian, and 
> we
> would like to drop all users accounts associated with DomainOld domain.
>
> I know how to do it manually, but with the number of servers and accounts 
> we
> have, it is just impractical. I would like to see if there is any tools, 
> or
> scripts/tricks out there that might help to speed up the process.
>
> Any feedback will be very much appreciated.
>
> -- 
> Brian
  • Next message: Gianluca Torta: "mapping Windows credentials to access linked server"

    Relevant Pages

    • Re: Pubstro rash
      ... passwords against all of the accounts. ... We see this type of attack regularly in the .EDU world. ... administrator password on many machines, ... if there is a local administrative user named "brian" on that same ...
      (Incidents)
    • Re: How do I move Outlook pst folders to a briefcase file?
      ... Hi Brian, I saw your response & would like to pick your brain. ... When I dble click mail I have no show profiles choice. ... Can I set each of my email accounts for deliver to ... > that will be distinct from your default delivery location. ...
      (microsoft.public.outlook.general)
    • Re: How do I remove all traces of my office installation from the reg.
      ... After struggling with the setup of those ... > accounts, I've decided to start with a clean slate and define them. ... > registry or do I have to rebuild my XP Pro system? ... Hi Brian B, ...
      (microsoft.public.outlook.installation)
    • Re: Too Many Personal Folders
      ... Brian - Thanks for all your reponses and help. ... Fortunately, just a couple accounts, so that should be quick. ... time for a new profile. ... > accounts, reset the send/receive settings, and if you use autocompletion, ...
      (microsoft.public.outlook)