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

Translate:

Archives

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

http://go.microsoft.com/fwlink/?LinkId=88057.

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

 

Great…

 

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

Translate »