Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2010-08-23
4
994 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:DEA2008
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
Brad Howe earned 250 total points
ID: 33500455
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
 
LVL 4

Assisted Solution

by:GuyHochman
GuyHochman earned 250 total points
ID: 33509753
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
 
LVL 4

Expert Comment

by:MSSystems
ID: 33514335
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
 
LVL 4

Expert Comment

by:MSSystems
ID: 33514441
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question