locked
Changing domain RRS feed

  • Question

  • SW INFO
    SQL2008R2 mirroring
    WIN2008R2

    I am changing my AD entire domain from oldomain.local to newdomain.local by following this
    http://blogs.technet.com/b/justin_gao/archive/2011/06/30/windows-server-2008-r2-adds-domain-rename-operation-document.aspx

    SQL running as OLDDOMAIN\sqlsvc
    SQL authentication only Windows Auth

    PROBLEMS:
    1. After changing domain, owner of my db still point to OLDDOMAIN\sqlsvc instead of NEWDOMAIN\sqlsvc

    QUESTIONS:
    1. Beside changing sql service as NEWDOMAIN\sqlsvc
    2. What else I need to do to set owner db to NEWDOMAIN\sqlsvc

    thanks


    Monday, March 24, 2014 5:32 AM

Answers

All replies

  • ----Problems

    1. http://technet.microsoft.com/en-us/library/ms178630.aspx


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Monday, March 24, 2014 6:15 AM
  • 1. After changing sqlservice to runas NEWDOMAIN\sqlsvc then reboot, I can't login to Management Studio

    Error 18456

    I try to login as Domain admin and NEWDOMAIN\sqlsvc but can't login

    How to fix that

    2. EXEC sp_changedbowner 'NEWDOMAIN\user1'

    That will change db owner

    tq


    • Edited by nbctcp2 Tuesday, March 25, 2014 2:06 AM
    Tuesday, March 25, 2014 2:05 AM
  • I need to change every user login from olddomain to newdomain

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/79682ff1-cb98-40e1-95df-18c551d28369/domain-name-change-for-sql-server-login?forum=sqlsecurity

    I also encounter this

    http://nickstips.wordpress.com/2010/09/08/sql-ssl-and-sql-server-2008-service-doesnt-start-error-code-2146885628/

    After fix those, I am able to start sql service using NEWDOMAIN\sqlsvc

    Now I am checking any further problem or not

    • Proposed as answer by Sofiya Li Tuesday, March 25, 2014 7:41 AM
    Tuesday, March 25, 2014 5:32 AM