Nitin Dhawan CRM Discussion

A CRM Monster [MCDP, MCDS, MCTS, MCSD]

Configuring SQL Server Reporting Services

Posted by Nitin Dhawan on June 18, 2009


Prerequisites

  • SQL server 2005 with SP2 or 2008 reporting services  Installed in web server.
  • SRS Data Connector  Installed in web server
  • SQL server 2005 or SQL server 2008

Configuration

  • On the Reporting Server Virtual Directory tab create a new “Reporting Server Virtual Directory” with the  following [Name] and [Website] i..e Name: ReportServer, Website: Default Web Site
  • Select “Apply” and wait for the RS wizard to complete the creation of the reporting server virtual  directory. No changes are necessary for the SSL settings unless the customer environment has SSL configured.
  • Verify that all “Reporting Server Virtual Directory” tasks complete successfully.
  • On the Report Manager Virtual Directory, create a new “Report Manager Virtual Directory” with the  following [Name] and [Website] i.e. Name: Reports, Website: Default Web Site
  • Select “Apply” and wait for the RS wizard to complete the creation of the report manager virtual  directory.
  • Verify that all “Report Manager Virtual Directory” tasks complete successfully.
  • On the Windows Service identity tab specify the “Windows Service Identity” for the report server use the  following settings i.e. Built-In Account: Network Service
  • Select “Apply” and wait for the RS wizard to complete the report server account configuration.
  • Verify that all “Windows Service Identity” tasks complete successfully.
  • On the Web Service Identity configure the RS “Web Service Identity” by creating a new “Application Pool”  for both the Report Server and Report Manager.
    • The new identity was configured as follows:
    • Application Pool Name: ReportServer
    • Select the “Built-In Account” radio button
    • Select the “Network Service” account from the drop-down menu.
    • Select “ok”
      • In the “Report Manager” drop-down menu select the new pool “ReportServer” from the drop down menu.
      • Select “Apply” and wait for the RS wizard to complete the report server web service identity  configuration.
      • Verify that all “Windows Service Identity” tasks complete successfully.
      • On the Database Setup tab configure the database connection and create a Reporting Server database as follows:
        • Connect to the Database Engine that will be used for Reporting Services. Note that this is not the Master database, and is solely for the operational requirements of Reporting Services. Typically this will be a SQL Server 2005 Database Engine that resides on the same SQL Server instance as Reporting Services.
        • Select the “New” button and configure the Reporting Server Database as follows:
          • Server Name: LOCAL <or Designated SQL Server 2005 Database Engine> (should be completed if you successfully connected to the existing database)
          • Credentials Type: Current User – Integrated Security
          • Username: NULL
          • Password: NULL
          • Database Name: ReportServer
          • Language: English
    • Select “Ok” then select the “Apply” button to create the new database and complete the database connection configuration.
    • Verify that all “Database creation” tasks complete successfully.
  • Proceed to the “Initialization” tab and verify that the new database is initialized. If not, select the database and select the “initialize” button.
  • Select the “Apply” button and verify that all “Initialization” tasks complete successfully.
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: