Adding SQL01 to the demo.local domain & Installing SQL 2008R2

In my previous blog I did setup my Domain Controller for the demo.local domain. This blog is about adding SQL01 as a SQL 2008R2 server to the domain. I will not explain how to Install SQL 2008R2, this is done before. Download the PDF here: Blog2 - SQL Server 2008R2 Installation (PDF Download)

This blog is not only for those who already know everything, but also for those who are only using SQL server and never installed there own servers or added them to a domain. So how simply this might be I will explain it below.

I hope you understand how to connect to your server as an administrator after you have installed Windows 2008.

Before we can install SQL 2008R2 on the server we need to add the server to the domain. The first thing to do is to set the IP-Configuration:

Next step is to get to the location where you can add the server to the domain.

Click the Windows Start button, then right click Computer and select properties.

Click Change Settings in Computer name , Domain and workgroup settings

On the System Properties screen , type a computer description if you like and then click Change

On the Computer Name / Domain Changes screen select member of Domain and type your chosen domain name. In my case demo.local and click OK.

When everything is correct, the server will find the domain controller and will ask for credentials that have the right to join the server SQL01 to the domain. In my case the demo.local\administrator.

After clicking OK it can take a while depending on your environment. But when correct the next screen will appear, click OK.

After clicking OK a warning will appear that you need to restart the server. Click OK.

Click Close on the System Properties Screen, now the restart screen appears, click Restart Now.

After the SQL01 Server is restarted start a remote desktop connection to the server again. Login with a domain demo.local\administrator account to the server to see or adding the server to the domain succeeded.

On the Server Manager page we can see the server joined the domain

We can check on some more places. Login to your domain controller and start Active Directory Users & Computers. Select the Computer node and notice that your server is there.

Start the DNS Manager on the domain controller, open the demo.local node and notice that your server is there.

So we now added the server to the domain, you can now repeat this for all other servers that you like add to the domain.

Hope you enjoy this blog! When you have comments, better solution and recommendation I like to hear from you.
Dynamic Intelligence | LinkedIn | Blog | Twitter