We help IT Professionals succeed at work.

SQL 2008 Installation

Medium Priority
351 Views
Last Modified: 2012-05-12
Hi

I have installed SQL 2008 on a Windows 2008 R2 Enterprise server in my network. At first I was told that the server did not need to be part of my domain but now the consultants changed their minds and told me to make the server join the domain. Will this cause any problems with my SQL installation? Do I need to reinstall SQL after the server has joined the domain?

BTW the application that uses the SQL server only uses local users, by that I mean that no user domain accounts are defined on the SQL server.

Thank you!
Comment
Watch Question

Commented:
No - there shouldn’t be any problems. I am surprised that the server wasn’t made part of the domain to begin with since MS has put significant emphasis on Windows authentication mode starting with SQL 2000 already. Windows domain membership will allow you to use Windows authentication from users in your domain. You may want to switch the actual SQL service and SQL agent account to use a regular domain user account - instead of running as local system or other account so far while you were running this SQL server outside your domain. Letting it run under a domain account will facilitate working with the server inside the domain. You may encounter the dreaded SPN (service principal registration error in SQL server logs after you move the SQL server to your domain. If you encounter that problem we can further troubleshoot then.

If all the accounts are SQL accounts or local user accounts, then why the need to be on the domain?

But I digress.  No it won't matter if you join it to the domain if it is just a part of a workgroup only right now.  As long as you aren't changing the name of the server itself.  Joining it to the domain won't affect local user accounts or local rights.  You shouldn't need to reinstall SQL, etc.

As always though, be sure and have a good backup in case anything goes wrong...but a simple domain join should be a quick add and reboot.

Author

Commented:
Thank you very much to both of you! :-)

Explore More ContentExplore courses, solutions, and other research materials related to this topic.