locked
Moving SQL 2005 Server from old domain to new domain RRS feed

  • Question

  • Hallo

    What is the most safe way to lift SQL server 2005 SP2 from one domain to another ( no IP or name changes, same box ). SQL agent ja MS SQL services running on Local system account and login to management is with Windows AD credentials.

     

    Thank You

    Raiko

     

    Monday, November 1, 2010 4:13 PM

Answers

  • Hi,
    1 and 2 are correct each other. You must add any necessary administrative rights to the new service account for example if SQL server accessed any network ressources as I mentioned you must add this new privileges to the new service account.
    
    You must also do this task:
    
    1- Change the login accounts for the MSSQLServer and the SQLAgent services using the services applet.
    
    
    
    
    


    Best Regards Don't forget to mark it as answer if it helps
    • Marked as answer by Tom Li - MSFT Wednesday, November 10, 2010 2:27 AM
    Tuesday, November 2, 2010 7:13 AM

All replies

  • Hi,
    
    Set the SQL Server Service to NOT start on system startup.
    Move the computer to the new domain.
    Grant the new service account administrator rights on the server.
    Use the services applet to change the login accounts for the MSSQLServer and 
    the SQLAgent services
    start the sql server. Start the SQL Agent
    If the SQL server accessed any network resources such as file shares, you 
    will need to replace the old service account with the new one.
    Test and go.

    Best Regards Don't forget to mark it as answer if it helps
    • Proposed as answer by Tom Li - MSFT Wednesday, November 3, 2010 7:13 AM
    Monday, November 1, 2010 5:02 PM
  • Like i understand

    1) I disable SQL service and agent service

    2) Move server to new domain and reboot then grant new service account administrator rights on the server.?

     

     

    PS: domains are not in same forest, there's no trust between them.

    Monday, November 1, 2010 5:29 PM
  • Hi,
    1 and 2 are correct each other. You must add any necessary administrative rights to the new service account for example if SQL server accessed any network ressources as I mentioned you must add this new privileges to the new service account.
    
    You must also do this task:
    
    1- Change the login accounts for the MSSQLServer and the SQLAgent services using the services applet.
    
    
    
    
    


    Best Regards Don't forget to mark it as answer if it helps
    • Marked as answer by Tom Li - MSFT Wednesday, November 10, 2010 2:27 AM
    Tuesday, November 2, 2010 7:13 AM