Rename of domain

  • Domain name will be renamed in my firm.

    There are some users who work by Windows authentication with SqlServer

    Startup  service account is defined by domain\user.

    What must I do beforehand and after renaming of domain with these accounts?

    All advises will be appreciated .      

  • I would have ALL users added to a Windows group.  GRANT permissions to that GROUP inside of SQL.  This way you have to maintain a SMALL number of changes vs. LARGE....

    I would script ALL permissions to the server and save it.  You may have to add ALL the permissions back (If you have script should be simple modification and play)...



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • I'm sorry, but i don't understood

    what you mean by  "Windows group".

    There are only concepts : login, users, roles in SqlServer.

    Where can I create Windows group?

  • Lina,

    We had several domain migrations and I recently tried to answer someone elses similar question. Please read of the possible renaming issues in my reply for the topic "Convert the NT XXX domain to Microsoft Active Directory"

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=180370#bm180385

    Hope it helps.

    Yelena

    Regards,Yelena Varsha

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply