Home » SQL Server » Installation & Configuration of SQL Server 2008 on Windows Server 2008 R2



Installation & Configuration of SQL Server 2008 on Windows Server 2008 R2

Today We’ll start with Installing & Configuring SQL Server 2008 on Windows Server 2008 R2


Before we Install let’s go ahead and check Prerequisites required for Installing & Configuring


Hardware and Software Requirements for Installing SQL Server 2008


Installing SQL Server on a Domain Controller


Microsoft recommends that you do not install SQL Server 2008 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:


  • On Windows Server 2003, SQL Server services can run under a domain account or a local system account.
  • You cannot run SQL Server services on a domain controller under a local service account or a network service account.
  • After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.
  • After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.
  • SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.
  • SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.


Supported Clients (64-Bit)

SQL Server 2008 64-bit client components can be installed on Windows Server 2003 (64-bit).



Mount the DVD into the drive, it first checks for proper framework.

Window pops up


SQL-Inst & Config1


Click OK


In the SQL Server Installation Center go to Installation  & select “New SQL Server Stand-alone installation or add feature to an existing installation” as shown below


SQL-Inst & Config2


The SQL Server 2008 Setup processes the current operation as shown below:


SQL-Inst & Config3


Select the feature name you want to Install, by default name would be “Setup Support Files” -> Select and click Install as shown below:


SQL-Inst & Config4


Once you click Install you can see couple of “Rule check” to check this you can click show details


SQL-Inst & Config5


SQL-Inst & Config6


We have got warning message


As this SQL Server is being installed on DC


Note: Installing SQL Server on Domain Controller is not recommended, it’s Test Environment so moving on


Click Next


Here you get three free editions


1: Enterprise Evaluation

2: Express Edition

3: Express with Advance Services


we’ve selected Enterprise Edition or if you have product key you can select as shown below


SQL-Inst & Config7


Click Next….


License Terms


SQL-Inst & Config8


Accepts the License terms

Click Next….


Feature Selection


Now select the Instance Feature you want, also you can change the directory path here I’ve selected the default path


SQL-Inst & Config9


Click Next….


Instance Configuration


I’ve selected the Default Instance Name “MSSQLSERVER” you can change the Instance name if required based on your requirement


Instance ID would be Instance name

And Instance Root Directory path I’ve gave default system path, it can be changed based on your requirement.


SQL-Inst & Config10


Click Next….


Disk Space Requirements


Detailed summary as shown below:


SQL-Inst & Config11


Click Next…..


Server Configuration


If remote SQL Server is running under the Network Service account or a domain account, you must create a Service Principal Name (SPN) for the SQL service.

As per the below article


On the Service Accounts Tab change the SQL Server Agent to Automatic startup.  The agent is used for backup.  We are going to use the same account for all of our services.  just click on the Use the same account for all SQL server Services button to bring up a small dialog box.

In the Account Name field select NT Authority\SYSTEM then click OK



SQL-Inst & Config12


Click Next…..


Database Engine Configuration


SQL-Inst & Config13


Under Account Provisioning we’ve selected Mixed Mode, so that the Internal SQL Users also can manage. Post you select the Mixed Mode you need to provide the credentials of the “SA” Account which would be Internal SQL Server Administrator Account.


Domain Administrator Account can be added by selecting Add Current user, but for adding SQL Admin account you need to Add the users..


Recommended to add Built-in Administrator Account

You can also check the log files path under Data Directories, this log file path can be changed based on your requirement.

If you want stream the files you can go to FILESTREAM tab and enable the settings accordingly, here we  haven’t  made any changes and left as default configuration.


SQL-Inst & Config14


Click Next….


Analysis Services Configuration


Under the Account Provisioning -> Add the Domain Account by selecting Add Current User, also SQL Administrator Account can also be added by clicking on Add


Click Next….


SQL-Inst & Config15


Recommended to add Built-in Administrator Account aswell


You can also check the log files path under Data Directories, this log file path can be changed based on your requirement.


SQL-Inst & Config16


Click Next….


Reporting Services Configuration


Here you can select Install without or with Reporting Server.

We’ve selected first option “Install the native mode default configuration.


SQL-Inst & Config17


Click Next….


Error and Usage Reporting

Based on your requirement either you can select or Ignore and move on


SQL-Inst & Config18


Click Next….


Installation Rules


SQL-Inst & Config19


If you want to see the status of the Rule for warnings and error you can select Show details


SQL-Inst & Config20


Click Next….


Ready to Install

It will show the complete summary


SQL-Inst & Config21


Click Install


Installation Progress


SQL-Inst & Config22


SQL-Inst & Config23


Post completion Feature Name  and Status will shown also it will popup message will be shown to restart the computer to complete this process

Click Ok


SQL-Inst & Config24



SQL-Inst & Config25


Completion Status -> Need to restart you SQL Server -> Click OK


SQL-Inst & Config26


After restart you can check if all the services are started or not…


SQL-Inst & Config27


To open the SQL Server Management Studio

Click START -> Run -> Type SSMS -> Ok


SQL-Inst & Config28


SQL Server Management Studio will be opened


Authentication Selected : Windows Authentication ->  Click Connect


SQL-Inst & Config29


Oops SQL Server Agent was not started


SQL-Inst & Config30


Right Click -> Start


SQL-Inst & Config31


Popup message as “Are you sure you want to start -> Yes


SQL-Inst & Config32


SQL Server Agent is started Successful


From SQL Server Agent you can Execute the Report Standard report as shown below


SQL-Inst & Config33


If you want to generate the Server Dashboard


Right Click Local Admin -> Execute the Server Dashboard Report  as shown below:


SQL-Inst & Config34


SQL-Inst & Config35











Reporting Server Dashboard


SQL-Inst & Config36




We’ve configured SQL Server 2008


In the up coming post we’ll discuss about


i  : Configuring Windows Firewall for  Database Engines.

ii: Configuring Firewall for Report Server Access.



Praveen Kumar

Publisher @ Techrid.com

Leave a comment