Does it matter if I install SQL 2008R2 before or after a Server has been added to the Domain?

I have a Windows 2008 Std server built, the server has not been named or added to the Domain. Does it matter if I install SQL 2008R2 on this server before the Server has been named and added to the Domain?
DEA2008Asked:
Who is Participating?
 
Brad HoweConnect With a Mentor DevOps ManagerCommented:
Hi,
Take a read at this. http://msdn.microsoft.com/en-us/library/ms143799.aspx
As long as it is standalone, you shouldn't have any issues. To rename after migration you can do the following.
To rename a computer that hosts a stand-alone instance of SQL Server  
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO
 
I would however suggest you rename the server before adding it to hte domain.
cheers,
Hades666
0
 
GuyHochmanConnect With a Mentor Commented:
Hi
Sure it does!

It is recomend that you install the SQL SERVER R2 (or any other version )
AFTER the server is in the domain
So you could use a dedicated user in the domain  (like SQLSERVERADMIN)
that will be a powerfull user
That will make your life easier in the future  (connecting to other servers, working with link servers.etc)

so first add it to the DOMAIN create a sqlserver user that will start the services and only then
start the installatino

goodluck!
Guy Hochman
0
 
MSSystemsCommented:
The only big reason for install SQL server after adding it to the domain is. Reporting services. You reporting services will give you endless problems and you will have to reconfigure some settings if join the domain after installing.
0
 
MSSystemsCommented:
The only big reason for install SQL server after adding it to the domain is. Reporting services. You reporting services will give you endless problems and you will have to reconfigure some settings if join the domain after installing.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.