In this post i am going to explain the steps for installing the sql server 2008 which include Reporting service installation & it’s configuration also.
Before you start installation following requirement should be met.
Prerequisites :
Windows 2003
If you want to install Sql server 2008 on Server 2003 than your server should have service pack 2 install.if it’s not then download service pack 2 from the following link, install it ,reboot your machine and then start installing sql server 2008.
now,if you all set for installing environment,you can proceed for the following steps
Installation Steps:-
Step 1:
Start installation of sql server 2008 by double clicking on the “setup.exe”
Step 2:
If the prerequisites installation dialog box appears, click OK
Step 3:
If you machine don’t have .NET Framework 3.5 SP1 .It will give a dialog box ,accept the License Agreement and it will start installing it.after it complete installation Exit button will appear in the right bottom corner of the dialog box with setup completed message click on that.to Proceed further.
Step 4:
After installing the NET Framework 3.5 SP1 it may ask you to install the Hot Fix for xp/windows server 2003.Accept the License Agreement to Install it.after successfully installation it may give prompted to you for restarting your computer, restart it, and then restart SQL Server 2008 setup.exe.
Step 5:
When the prerequisites are installed, the Installation Wizard will run the SQL Server Installation Center. To installation of SQL Server 2008, click New Installation or Add Features to an Existing Installation.
Step 6:
It will check that you system is configure proper for installing the sql server 2008.if any Error occur during this test need to resolve that error and then only you able to Proceed further.Click ok when you pass all the check.
Step 7:
If you able to proceed further then,in next dialog box will ask you to either install free version or the product key.go one of the way to install.
Step 8:
Next step is to accept the License Agreement and click ok.
Step 9:
The Installation Wizard will install SQL Server prerequisites if they are not already on the computer. These include the following:
- .NET Framework 3.5 SP1
- SQL Server Native Client
- SQL Server Setup Support Files
To install prerequisites, click Install.
Step10:
Select the Feature form the Feature Selection you want to install.
Here is the some more information on the current choices:
- Data Base Engine is obviously mandatory
- Business Intelligence Development Studio aka BIDS
This is essential regarding Reporting Services integration as it is THE tool that will allow you to create reports and deploy them in SharePoint. For a SQL Server 2008 installation without Reporting Services you can avoid installing this feature. - Management-Tools Complete
This feature will install Microsoft SQL Server Management Studio
If you don’t need Reporting Services, you can avoid checking complete feature, but the complete one install elements that runs with Reporting Services as noticed in description that appears in the right pane after you select the feature name.
You can also specify a custom directory for shared components by using the field at the bottom of the Feature Selection page. To change the installation path for shared components, either update the path in the field at the bottom of the dialog box, or click Browse to move to an installation directory. The default installation path is C:\Program Files\Microsoft SQL Server\100\.
Step 11:
On the Instance Configuration page, specify whether to install a default instance or a named instance.
Step 12:
The Disk Space Requirements page calculates the required disk space for the features that you specify. Then it compares the required space to the available disk space.
Step 13:
On the Server Configuration — Service Accounts page, specify login accounts for SQL Server services. give your system Administrator account and specify the password so it has all the access.
Step 14:
Chose Mixed mode if you want to integrate you sql with share point to use SQL Authentication. you need to provide the password for the “sa” login if you have selected mixed mode.then Click on the Add current User.
Step 15:
if you planning to install the Reporting service.Reporting service configuration screen will com up.
select first option you you want to configure Reporting service automatically as installation process.
select second option if you have already install share point and want to configure Reporting service with sharepoint automatically as installation process.
Select third option you want to configure reporting service manually or you have not install the share point yet.
Step 16:
On the Error and Usage Reporting page, specify the information that you want to send to Microsoft that will help improve SQL Server. By default, options for error reporting and feature usage are enabled.
Step 17:
now one more time System configuration check will run to check that all the option will you selected are able to install in you current configuration.
in case,it fail to pass any of the one check ,need to resolve it to proceed further.
Step 18:
The Ready to Install page shows a tree view of installation options that were specified during Setup. To continue, click on Install will start the installing the sql server 2008.
Next Post:
Configuration of the Reporting service and integrating the reporting service with share point will going to come on my next post.
Enjoy you successful installation of SQl server 2008.
