How To Install SSRS [SQL Server Reporting Service] On MS SQL 2005 server?

[Shane]

Hi,

You need to follow these steps in order to install Microsoft SQL Server 2005 Reporting Services.

1. Insert the Microsoft SQL Server 2005 product CD into the CD Drive.
2. Click Start, point to Settings, and then click Control Panel.
3. In Control Panel, double-click Add or Remove Programs.
4. In Add or Remove Programs -> click Microsoft SQL Server 2005 and then click Change.
5. On the Component Selection page, expand SQL Server 2005 instances, select MSSQLSERVER, and then click Next.
6. On the Feature Maintenance page, select Reporting Services, and then click Next.
The Microsoft SQL Server Installation Wizard starts.
7. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.
8. On the System Configuration Check page, click Next.
9. On the Change or Remove Instance page, click Change Installed Components.
10. On the Feature Selection page, make sure that Reporting Services will be installed on the local hard disk drive, and then click Next.
11. On the Ready to Update page, click Install.
12. On the Setup Progress page, click Next.
13. On the Completing Microsoft SQL Server 2005 Setup page, click Finish.

That’s it!

Thanks,

Shane G.

[kilter]

Re: How To Install SSRS [SQL Server Reporting Service] On MS SQL 2005 server?

Thanks for the information in my opinion the best way to use javascript in your forms page. using the onsubmit, enumerate every field and set the value if null. which will be released any minute now enables deep integration between Reporting Services and SharePoint technologies Windows SharePoint Services 3.0 and Office SharePoint Server 2007. This article is the first of four parts, which will provide in-depth coverage of SQL Server 2005 Reporting Services:
1) covers the basics of the SSRS. It demonstrates how to build quick, simple reports and will familiarize you with the basic Report Designer environment
2) will cover use of custom functions, aggregate functions, sub-reporting, the matrix control, drill-downs, and sorting.
3) will take an in-depth look at the charting control
4) digs into the actual Report Definition Language (RDL) and the new Report Builder tool.

Thanks

[MichaelHerry]

Re: How To Install SSRS [SQL Server Reporting Service] On MS SQL 2005 server?

Before you install SSRS you have to first install IIS 5.1 then you can install SSRS.

[TerryMoke]

Re: How To Install SSRS [SQL Server Reporting Service] On MS SQL 2005 server?

Before you install RSS you must enable Microsoft ASP.NET and Internet Information Services. To do this, you must configure a server role.

[JeffyBrown]

Re: How To Install SSRS [SQL Server Reporting Service] On MS SQL 2005 server?

I didn't install SSRS but when i wanted to install it. I had to first install IIS 5.1.

[JackMolen]

Re: How To Install SSRS [SQL Server Reporting Service] On MS SQL 2005 server?

I just understand the following points which are easy to get an idea
1. Its easy to install
2. The areas of the software are clearly marked
3. Intergration of CLR functions
4. Use of SQL Features inside Visual Studio