MS SQL Server 2005 Set Up

Although its not a big deal to install MS SQL SERVER 2005 ..but here I Published some Step to install SQL Server 2005 alongwith Analysis server and reporting Server database....

Step 1

Sql Server Component update insatll the fallowing component

1-Dot Net framework 2.0

2-Ms sql native Client

3-MS SQL server 2005 set up support file

Click Next

Step 2

MS SQL Server Installation Wizard

Click Next

Step 3

System Configuration Check(system is checked for Potential Installation)

Fallowing Action is checked

1-IIS Feature requirement

2-Pending Reboot Requirement

3-Performance Monitor Requirement

4-Default Installation Path Permission Requirement

5-IE Requirement

6-COM plus Catalog Requirement

7-ASP.NET Version Registration requirement

8-Min MDAC Version Requirement

Status may be either Success or Failure

Click Next

Step 4

Registration Information Component to Install

1-SQL Server database service

2-Analysis Service

3-reporting Service

4-Notification Service

5-Integration service

6-Workstation Component ,Book Online and Development Tool

Authentication Mode

Instance Name

1-Default Name

2-Service Account

3-SA password

Enter the SA password *****

Click Next

Step 5

Collation Setting (Used for compatibility with older version of SQL Server)

Select Default setting

Click Next

Step 6

Report Server Installation Option(Specify How to Install a report Server Instance)

2 option are there

1-Install the default configration

2-Install but don't config the server

select option number one

Click Next

Step 7

Error and Usage Report setting

Fallowing Service are ready to install

1-SQL Server Database Service

2-Analysis Service

3-Reporting Servic

4-Notification Service

5-Intregration Service

6 Client Component

Click Next

Set Up In progress---Select Finish

MS DOT NET FrameWork 3.0 Installation

1-Open exe File

2-Select Install mode

3-Clicking Next will start installing Framework

4-Will send feedback for successful installation

SQL Server 2005service Pack 1 setup

step1

SQl Server 2005 Will Show It's Feature

1-SQL Server native Client

2-SQL Server native Client(64 bit)

3-DataBase service

4-Analysis service

5-Notification service

6-Reporting service

7-Intregration servic1

8-Client Component

9-MS XML 6.0 Parser

10-MS XML 6.0 Parser(64 bit)

11-SQL XML 4

12-SQL XML 4(64 bit)

13-Background Compatibility

14-Background Compatibility(64 bit)

15-MS SQl Server VSS Writer

16-MS SQl Server VSS Writer(64 bit)

End User License Agreement

Accept

Feature Section

1-SQL Server native Client

2-MS SQL server

i-Database service(sp1 2047 ENU)

ii-Analysis service(sp1 2047 ENU)

iii-Reporting Service(sp1 2047 ENU)

3-Reporting service

4-Client Component

5-MS XML 6.0 Parser

6-MS XML 6.0 Parser(64 bit)

7-SQL XML 4(64 bit)

8-Background Compatibility(64 bit)

9-MS SQL Server VSS Writer

Authentication Mode

All Instance

Windows Authentication

SQL Server Authentication

Select SQL Server Authentication mode

Password is *******

Click Next

Feedback will come about successful installation