Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I currently have some SQL Servers that sit on a sub-domain. We are eliminating that sub-domain and moving everything to the regular domain.

As far as SQL Server configuration goes, is there anything I need to change aside from potentially using different service accounts?

Note this is simply a domain change - the server name should be the same.

share|improve this question

2 Answers 2

up vote 5 down vote accepted

We did the same thing a while ago. The change went smoothly, we just had to change the various service accounts. We stopped all services before the move, then changed the accounts, then started everything without a hitch.

share|improve this answer
    
Thanks! Glad your migration was easy ;) –  Derek Kromm Sep 8 '11 at 19:04
    
@Derek: yours should be the same. Changing the domains shouldn't include any problem out of the box, just check all the accounts and the connectivity between related servers. –  Marian Sep 8 '11 at 20:41

The domain name is part of the server name! Open up SQL Server, SSMS, expand security for the server and look at the users. Notice the Windows users are OldDomain\UserName? It never changed.

Also do a SELECT @@SERVERNAME. Notice it'll reference the old domain name.

Internally, SQL Server doesn't know the server changed domains and thus has a different 'fully qualified host name'.

Please do the following: -Rename it with the correct name if it showed up as the old domain following these instructions.

-Make sure you have admin rights to the machine, and add the new domain users mirroring permissions off the old one.

Those would be the main steps needed to ensure a smooth domain rename. Clustering is even more sensitive to it.

share|improve this answer
    
+1 for RTFM link but you are not correct. My SQL Servers 2012 SELECT @@SERVERNAME (as well as sys.servers) return: 1)old machine name (the one before renaming); 2)name without domain name. And all work for years. Actually "my" SQL servers recognize new server name for all purposes and fail to recognize the old one though the SQL Server metada has not been updated and return the old namу (and for quite a time) –  Gennady Vanin Геннадий Ванин Jan 13 at 4:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.