Prizes & Awards
My Profile
Active Members
TodayLast 7 Days
more...
|
 New Feature: Community Sites:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
|
Installing and Configuring the SQL Server Reporting Services
|
Introduction
Installing the SQL Server Reporting Services (SSRS) will be tough if you didn’t get your System configured properly. Here I present some of the problem that user will face on or before the SSRS is installed. Hope this Article will provide easy installation and Configuration of SSRS.
Reporting Service Installation Requirements
First step to install SSRS is to have SQL Server Installed. If you are using SQL Server 2000 then get the SSRS 2000 installed.
• SSRS 2000 comes in three editions Standard, Developer and Enterprise Editions.
• Respective Service pack needed to be installed for SSRS to function properly with SQL Server.
• Service pack required for SQL 2000 is SP 3a or 4
• Hot fixes SQL2000.RS-KB901383-v8.00.1042.00-ENG needed to be installed.
• SSRS SP2 should be installed
• Windows Server 2003 with SP1
SharePoint Service Installed
If the share point services are installed then SSRS will be installed but will not be automatically configured. We have to manually configure using various command line utility supplied like rsconfig.exe, rs.exe, rsactivate.exe, rskeyMgmt.exe.
We have to specify the Path of the ReportingServices.asmx file in the rsconfig.exe (or) with the rsactivate.exe to configure manually.
rsKeyMgmt.exe: While installing the SSRS Synchronous key will be written. While configuring manually this should be equal with the already written key. Use this utility to correct the problem.
SSRS 2005 Installation in SQL Server 2005:
SSRS comes as a component in the SQL 2005. So you just needs to select the component for installation.
Installation procedure
Previous Installation Failure
If the previous installation of SSRS is failed by any reason then you have to remove the two respective databases namely ReportServer, ReportServerTempDB manually from the SQL Server and uncheck the option to install AdventureWorks DB.
Installation
Instillation will go smoothly if all the mentioned above is followed.
Uncheck the SSL option. And check if Report Manager should be default website. Specify the SMTP address of the company and your Company E-mail id when asked.
Then installation goes smooth.
If share point is not installed Reporting Services will be installed and configured to you or else you have to do manually as mentioned earlier.
Now the you can see the two new folders in the SQL Server Database also in the IIS Default Website.
Now that you are done with the installation. You can go to the SQL Server option in Start ? Programs ? SQL Server ? Reporting Services ? Report Manager.
Report manager is the Web based management of the reporting services. You manage all your reporting services management task here. If you have administrative control you can see the four links Home, Site-Settings, Subscription,Help. If you don’t have administrative rights then you have only the three except the Site-Settings.
Site-Settings is the great link to work around.
Now that we are done with installation. Letz see the configuration.
Configuration
Creating of User (note user name you are specifying here and that you are going to create in the Report Server user creation are the same)
Go to the MyComputer (Right Click the mouse)?Manage?Computer management ? Users and Groups ? Create new user (give description as Report Server user )
Add the above created user to the VSDevelopers. This writes is given so the Visual Studio user can use the methods exposed by the reporting services web service.
Option 1
Creating user in the Report Server Database (note user name you Created above and that you are going to create here should be the same)
Start ? Programs ? SQL Server ? Enterprise Manager? Open the Database?Report Server
Creating a new user
• Drop down the DB or right click on the right pane.
• Select the new Database user.
• In the list select
• Specify the user and assign the public and RSExecRole rights.
Doing so will allow you to query the report server and Deploy the report.
Option 2
Start ? Programs ? SQL Server ? Reporting Services ? Report Manager?Properties (left corner)? select the New Role Assignment ? give the user name u created in the Report Server. Check the permission you wanna give to the user. Once this is done you can see that user is added in the properties page with the assigned rights.
Note: only user who has Content manager has the ability to create,build,deploy,query the reports in the Report Server.
You customize the new role and assign the rights in the Site-Settings. Keep in mind small mistake will not allow you to deploy the report.
Errors you will be facing if respective SP is not filled are
• If SQL SP 3a or SP 4 is not installed Reporting Service cannot be installed
• If SSRS 2000 Sp2 is not installed then you cannot have the report for more that 83.23 inch (even if you design while reopening you will get the Deserialization error will occur
• For not installing SSRS service pack your report parameter is read-only cannot be edited error will occur if you pass report parameter from the C# code
• If the above configuration and creation of the user and assignment are not followed then you will face the NT Service/NT Authorization failed. You cannot perform the request operation in the report.
• If you uninstall the reporting service for some unknown reason after deploying the report and you system is back with new installation. Your report would not deploy the report as before. You will get the Error “The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)".
• To get rid of the above error Report manager ? select your report? select the properties option
View
Properties
History
Subscriptions
•Select the datasource option
•Go to the check box named “Credentials stored securely in the report server”
•Check the box and give the database user name and password
•
Now you are done.
Summary
in this article we have seen installing and configuring the SQL Reporting Services.Keep in mind the u have Report User in the ReportServer. Only the user of Type ContentManager have rights to do all sorts of operation with the reprot Server. In the next article we will see how to create the Report template and deploy it in the Server.'
Happy Heporting..............
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|