• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 848
  • Last Modified:

Move Member Servers to New Domain

hello all,

    I have a client that has a small network.  5 user computers and couple of servers.  He bought a new Windows 2008 server to replace his old Windows 2000 Servers.  This will be a new domain that he setup from scratch.  He bought 5 new computers that will now connect to the new domain.  My question is he has a member server that ran SQL Server on his old domain.  He wants to move the SQL server into the new domain.  Seems cut and dry but I want to make sure if there is anything we should look out for?    
0
bobohost
Asked:
bobohost
  • 5
  • 3
  • 2
  • +1
1 Solution
 
nordtorpCommented:
I can see you added the Zone SQL Server 2005, and would think that is the version you run.
This might help: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23835535.html

Resolve permission issues when you move a database between servers
http://support.microsoft.com/?id=240872

Changing domains for SQL Clusters:
http://nyc-dba.blogspot.com/2007/01/changing-domain-for-sql-2005-cluster.html
0
 
bobohostAuthor Commented:
looks like first link is what we are trying to do.  so I just need to add a domain account to the sql security account?
0
 
nordtorpCommented:
It depends how your SQL Server authenticates. If it is a standalone (use local user accounts) I don't think you need to do anything actually.

If it is in a domain and use domain user accounts you have to first make it local and set local groups and/or accounts to it. Then remove the domain membership and reboot. Then you might add it to the new domain, reboot and add domain groups and/or user accounts again.

Take my advice with a little pinch of salt as I do not have enough experience around SQL Servers.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
bobohostAuthor Commented:
Gotcha
0
 
Jason WatkinsIT Project LeaderCommented:
SQL 2000 and newer will authenticate with mixed mode authentication (sql and active directory users) , or integrated authentication (active directory only).   I would look at all of the server roles and users on the SQL server to see where they currently map, then recreate that mapping on the new domain.
0
 
joelmerryCommented:
Also make sure instance and agent services aren't using domain account instead of local system. You'll want to change to local system before moving. Firebar is also right in making sure you validate the user mappings. For such a small office I'm sure there are only 1-3 local SQL accounts, at most, that are probably used.
0
 
bobohostAuthor Commented:
So I tried just chaning it to the new domain and when I launch SQL 2005 it says it can't connect.  I went into services and noticed that SQL Server was not running and the logon account was olddomain\msql type of account.  How do I recreate those accounts in the new AD?  If i'm not mistaken those are created by SQL when it's first installed correct?
0
 
joelmerryCommented:
You need to manually create the service account in the new AD. Create it just like a regular user account (e.g., newdomain\s-sql), then add that account to the local administrators group of the SQL server.
0
 
Jason WatkinsIT Project LeaderCommented:
The SQL service account will also need to be granted the 'Log on as a service" right on the server's local GPO.
0
 
joelmerryCommented:
"Log on as a service" right will be automatically granted once the SQL service(es) is/are configured to use the service account. No additional steps are required.
0
 
bobohostAuthor Commented:
Thanks let me give it a try.
0
 
bobohostAuthor Commented:
That was it.  Once I created the new accounts it all worked.  Thanks
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

  • 5
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now