An example of deployment Topology for SQL Server Reporting
Services 2008 in SharePoint Integrated Mode:
Distributed Server Deployment
with Three computers.
Services 2008 in SharePoint Integrated Mode:
Distributed Server Deployment
with Three computers.
| Download a .doc version of this post |
Summary
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px">href="#Prerequisites-">1 - Prerequisites
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Windows-Server-Domain-and-Active-Directory">01 - Windows Server Domain
and Active Directory
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Service-Accounts">02 - Service Accounts
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Available-Server-">03 - Available Server
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px">href="#Installation-Overview-">2 - Installation Overview
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Topology-description">01 - Topology description
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#--Computers">- Computers
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#--Service-Accounts">- Service Accounts
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Recommended-installation-sequence-">02 - Recommended installation
sequence (installation overview - workarounds)
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px">href="#Installation">3 - Installation
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Step-1:-Installation-of-SQL-Server-2008-on-SQLSERVER2008">3.1 - Step 1:
Installation of SQL Server 2008 on SQLSERVER2008
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Start-SQL-Server-2008-installation">01 - Start SQL Server 2008
installation
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Selecting-Installation-features-">02 - Selecting Installation
features
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Server-Configuration">03 - Server Configuration
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Not-to-forget">04 - Not to forget
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Step-2:-Installation-of-SQL-Server-Reporting-Services-2008">3.2 - Step
2: Installation of SQL Server Reporting Services 2008 on SSRS2008SPIM
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Start-SQL-Server-2008-installation-on-report-sever-computer">01 -
Start SQL Server 2008 installation
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Selecting-Installation-features-for-report-sever-computer">02 -
Selecting Installation features
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Server-Configuration-for-report-sever-computer">03 - Server
Configuration
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Reporting-Services-Configuration-Page">04 - Reporting Services
Configuration Page
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Check-Installation-">05 - Check Installation
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Step-3:-Installation-of-SharePoint-2007-on-SHAREPOINT2007">3.3 - Step
3: Installation of SharePoint 2007 on SHAREPOINT2007
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Create-SharePoint-databases-and-grant-permissions-to-SPS_SETUP-domain-account">01
- Create SharePoint databases and grant permissions to SPS_SETUP domain
account
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Start-SharePoint-installation-on-SHAREPOINT2007">02 - Start
SharePoint installation on SHAREPOINT2007
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Running-SharePoint-Product-and-Technologies-Configuration-Wizard">03
- Running SharePoint Product and Technologies Configuration Wizard
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Creating-a-Web-Application-on-port-81">03 - Creating a Web
Application on port 81 and a TestReportingServices Site Collection
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Step-4:-Installation-of-SharePoint-2007-on-SSRS2008SPIM">3.4 - Step 4:
Installation of SharePoint 2007 on SSRS2008SPIM
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Start-SharePoint-installation-on-SSRS2008SPIM">01 - Start SharePoint
installation on SSRS2008SPIM
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Check-SharePoint-installation-on-SSRS2008SPIM">02 - Check SharePoint
installation on SSRS2008SPIM
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Step-5:-Configuration-and-test-of-the-Report-Server-on-SSRS2008SPIM">3.5
- Step 5: Configuration and test of the Report Server on SSRS2008SPIM
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Preparing-SSRS_SERVICE-account-to-configure-Reporting-Services-">01 -
Preparing SSRS_SERVICE account to configure Reporting Services
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Creating-report-Server-databases-">02 - Creating report Server
databases
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Provisioning-Report-Server-Web-Service-">03 - Provisioning Report
Server Web Service
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Step-6:-Installation-of-SQL-Server-Reporting-Services-2008-Add-In">3.6
- Step 6: Installation of SQL Server Reporting Services 2008 Add In for
SharePoint on SHAREPOINT2007, Configuration and Check
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Installation-of-SQL-Server-Reporting-Services-2008-Add-In">01 -
Installation of SQL Server Reporting Services 2008 Add In for SharePoint on
SHAREPOINT2007
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Configuration-of-reporting-services-in-SharePoint-Central-Administration">02
- Configuration of reporting services in SharePoint Central
Administration
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Step-7:-BIDS-installation,-Report-creation,-deployment-and-test-">3.7 -
Step 7: BIDS installation, Report creation, deployment and test
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Step-7:-BIDS-installation,-Report-creation,-deployment-and-test-">01
- BIDS installation
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Report-Creation">02 - Report Creation
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Report-Deployment">03 - Report Deployment
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Report-Data-Source-Configuration">04 - Report Data Source
Configuration
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px"> href="#Report-Displaying">05 - Report Displaying
This tutorial includes the key steps for deploying and
configuring:
environment composed of three computers.
This tutorial is
completing these previous ones:
href="http://mosshowto.blogspot.com/2009/01/integrating-sql-server-2008-reporting.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 1 - SQL Server 2008
Installation
href="http://mosshowto.blogspot.com/2009/01/reporting-services-2008-sharepoint-2007.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 2 - SharePoint Installation
href="http://mosshowto.blogspot.com/2009/01/sharepoint-report-server-2008.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 3 - Configuring Reporting
Services for SharePoint 3.0 Integration - Part 1
href="http://mosshowto.blogspot.com/2009/01/integrating-ssrs-2008-sharepoint-2007.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 4 - Configuring Reporting
Services for SharePoint 3.0 Integration - Part 2
href="http://mosshowto.blogspot.com/2009/01/adventure-works-2008-installation-sql.html">Installing
SQL Server 2008 samples: Adventure works (Integrating Reporting Services 2008
with SharePoint 2007 Step 5)
href="http://mosshowto.blogspot.com/2009/02/reporting-services-2008-report.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 6 - Report Creation and
Deployment
that was showing how to install SQL Server Reporting
Services 2008 in SharePoint integrated mode with SharePoint 2007 but on a
single computer. In this tutorial, we are going to build a real
Production Environment.
Of course it would be better before doing this
installation to have done at least once the installation on a single machine
with one service account: local administrator account.
show a complete example of installation with the required service accounts, in
order to allow an Infrastructure Administrator to install SQL Server Reporting
Services 2008 in SharePoint Integrated mode with SharePoint 2007 on three
different computers for a real production environment compliant with the
principle of least privilege administration.
What I have noticed
performing several interventions for different clients, is that the knowledge
required installing even Microsoft Office SharePoint Server 2007 in a QA,
staging, or Production Environment is increasing more and more because the
involved products (SharePoint, SQL Server, IIS, etc.) are becoming more and more
complex. For that reason, it is difficult for people working in Infrastructure
and Network Area to have the entire required acknowledgement, and very often
they need the support of SharePoint developers that are used to install
SharePoint on their own development environment.
However, on the opposite,
SharePoint developers are not deploying very often the products on several
machines using the several service accounts required by the least-privilege
administration policy that is recommended when you configure a Production
Environment. They are often, not either aware of the configuration key elements
that are needed by SharePoint, SQL Server, IIS, etc. to work on a multiple
server environment.
If you add SQL Server Reporting Services 2008 to
SharePoint 2007, the number of operations to perform and choices to take, much
more increases.
So there is a knowledge gap to fill...
configuring:
- SQL Server 2008 Database Engine
- SQL Server Reporting Services 2008
- SharePoint 2007 (Windows SharePoint Services 3.0)
environment composed of three computers.
This tutorial is
completing these previous ones:
href="http://mosshowto.blogspot.com/2009/01/integrating-sql-server-2008-reporting.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 1 - SQL Server 2008
Installation
href="http://mosshowto.blogspot.com/2009/01/reporting-services-2008-sharepoint-2007.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 2 - SharePoint Installation
href="http://mosshowto.blogspot.com/2009/01/sharepoint-report-server-2008.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 3 - Configuring Reporting
Services for SharePoint 3.0 Integration - Part 1
href="http://mosshowto.blogspot.com/2009/01/integrating-ssrs-2008-sharepoint-2007.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 4 - Configuring Reporting
Services for SharePoint 3.0 Integration - Part 2
href="http://mosshowto.blogspot.com/2009/01/adventure-works-2008-installation-sql.html">Installing
SQL Server 2008 samples: Adventure works (Integrating Reporting Services 2008
with SharePoint 2007 Step 5)
href="http://mosshowto.blogspot.com/2009/02/reporting-services-2008-report.html">Integrating
Reporting Services 2008 with SharePoint 2007 Step 6 - Report Creation and
Deployment
that was showing how to install SQL Server Reporting
Services 2008 in SharePoint integrated mode with SharePoint 2007 but on a
single computer. In this tutorial, we are going to build a real
Production Environment.
Of course it would be better before doing this
installation to have done at least once the installation on a single machine
with one service account: local administrator account.
01- Tutorial goal
In this installation tutorial, I will show a complete example of installation with the required service accounts, in
order to allow an Infrastructure Administrator to install SQL Server Reporting
Services 2008 in SharePoint Integrated mode with SharePoint 2007 on three
different computers for a real production environment compliant with the
principle of least privilege administration.
What I have noticed
performing several interventions for different clients, is that the knowledge
required installing even Microsoft Office SharePoint Server 2007 in a QA,
staging, or Production Environment is increasing more and more because the
involved products (SharePoint, SQL Server, IIS, etc.) are becoming more and more
complex. For that reason, it is difficult for people working in Infrastructure
and Network Area to have the entire required acknowledgement, and very often
they need the support of SharePoint developers that are used to install
SharePoint on their own development environment.
However, on the opposite,
SharePoint developers are not deploying very often the products on several
machines using the several service accounts required by the least-privilege
administration policy that is recommended when you configure a Production
Environment. They are often, not either aware of the configuration key elements
that are needed by SharePoint, SQL Server, IIS, etc. to work on a multiple
server environment.
If you add SQL Server Reporting Services 2008 to
SharePoint 2007, the number of operations to perform and choices to take, much
more increases.
So there is a knowledge gap to fill...
The machines ready for installation have joined a Domain.
An Active Directory is available in this Domain.
The name of the Domain used
in this tutorial is "CORPORATE".
As
this tutorial is rather made for people working in Infrastructure Area, I do not
show how to create a domain account in Active Directory, and I put in the
prerequisites the presence in the Active Directory of the following Service
Accounts in order to be able to build an environment compliant with the
principle of least privilege administration (href="http://technet.microsoft.com/en-us/library/cc263445.aspx">Plan for
administrative and service accounts (Office SharePoint Server)):
- SQL_SERVICE
- SPS_SETUP
- SPS_FARM
- SSRS_SERVICE
- SPS_AppPoolWebApp81
and roles in the next section.
Of
course you have three available Servers running Windows 2003 Server OS ready for
the installation. The machine names I use in this post are the followings:
- SQL2008
- SSRS2008SPIM (for SQL Server Reporting Services 2008 in SharePoint
Integrated Mode)
- SHAREPOINT2007
section (that is to mean if they need to be Application Server or not, thus if
IIS is needed to be installed or not).
this is a part of the MSDN article (href="http://msdn.microsoft.com/en-us/library/bb510781.aspx">Deployment
Topologies for Reporting Services in SharePoint Integrated Mode)
[...]
Three-Computer Deployment
The following illustration shows
components for a three-computer deployment.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih1Si9XU04EQwsfqhAPtVE3rl58wBKDjfwU3oGTKWXHoxhumfe4Vat6AkO8KcuOsgEOdfJdLK9ebOQhSoXFFRZV0mtySx0zKE324gLb879usA7RWk3UT9ELWcYDpKoiqR2yDBrL7v_Z0jY/s1600-h/Bb510781_26270af9-caf3-4cd9-ab2e-a699b393011c(en-us,SQL_100).gif">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 49px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih1Si9XU04EQwsfqhAPtVE3rl58wBKDjfwU3oGTKWXHoxhumfe4Vat6AkO8KcuOsgEOdfJdLK9ebOQhSoXFFRZV0mtySx0zKE324gLb879usA7RWk3UT9ELWcYDpKoiqR2yDBrL7v_Z0jY/s320/Bb510781_26270af9-caf3-4cd9-ab2e-a699b393011c(en-us,SQL_100).gif"
border=0>
The first computer hosts an instance of a SharePoint
product or technology. The second computer hosts SQL Server Reporting Services.
The third computer hosts an instance of the Database Engine.
In the
illustration, notice that the Database Engine does not require a local
installation of a report server or an instance of a SharePoint product or
technology.
To use a remote database server with a deployment of a
SharePoint product or technology, choose the Advanced installation option when
installing an instance of a SharePoint product or technology, or use Central
Administration to modify the database server setting. To select a remote
database server for Reporting Services, use the Reporting Services Configuration
tool. For more information about edition and connection requirements for a
report server database, see href="http://msdn.microsoft.com/en-us/library/ms157285.aspx">Creating a Report
Server Database and href="http://msdn.microsoft.com/en-us/library/bb283151.aspx">How to: Create a
Report Server Database for SharePoint Integrated Mode (Reporting Services
Configuration) .
[...]
1 Name:
System:
2003 Server
Role
(no more need of IIS for SQL Server 2008)
products:
Server 2008 (Database Engine, Full Text, Basic Management Tools,
Management Tools Complete)
instance (no named)
2 Name:
(for SQL Server Reporting Services 2008 SharePoint Integrated Mode)
System:
2003 Server
Roles:
Server (no more need of IIS for Report server 2008 since it has its own
IIS, but we need IIS for SharePoint)
products:
Server 2008 Reporting Services, Windows SharePoint Services 3.0
Server 2008 Reporting Services: one instance, simple (no Scale Out)
Windows SharePoint Services 3.0: Minimal Installation
3 Name:
System:
2003 Server
Roles:
Server (we need IIS for SharePoint)
products:
SharePoint Services 3.0
Farm
Name and Password:
Passw0rd
Description:
Server prompts for this account during SQL Server Setup. This account is
used as the service account for the following SQL Server services:
- SQL Server Database Engine
- SQL Server Agent
- SQL Full-Text Daemon Launcher
vs. Local
Account (can be a local account)
special permissions required
documentation:
Plan
for administrative and service accounts
Name and Password:
Passw0rd
Description:
SetUp user Account on SHAREPOINT2007 Server
SharePoint SetUp user
Account on SSRS2008SPIM Server
The service account that is used to
run:
- Setup of SharePoint on each server computer
- The SharePoint Products and Technologies Configuration Wizard
- The Psconfig command-line tool
- The Stsadm command-line tool
- Setup of Reporting Services on Report
Server computer
- Reporting Services Configuration Manager on
Report Server computer
account might be used in operations of recovery, when you need to
reinitialize Reporting Services Account for example if you tried to change
this account or its password has expired)
cf. : href="http://msdn.microsoft.com/en-us/library/ms160340.aspx">Configuring
the Report Server Service Account
vs. Local
Account (cannot be a local account)
of SHAREPOINT2007
Administrator of SSRS2008SPIM
SQL Server
login on the computer running SQL Server.
Member of the following SQL
Server security roles:
- securityadmin fixed server role
- dbcreator fixed server role
- dbowner of SharePoint_Config database
- dbowner of SharePoint_AdminContent database
documentation:
Plan
for administrative and service accounts
Name and Password:
Passw0rd
Description:
Server Farm Account
This account is also referred to as the database
access account.
This account is:
- The application pool identity for the SharePoint Central
Administration Web site.
- The process account for the Windows SharePoint Services Timer
service.
vs. Local
Account (cannot be a local account)
special permissions required
Its permission for SharePoint databases
will be granted automatically during installation process
documentation:
Plan
for administrative and service accounts
Name and Password:
Passw0rd
Description:
Server prompts for this account during SQL Server Reporting Services 2008
Setup. This account is used as the service account for the following SQL
Server services:
- SQL Report Server on SSRS2008SPIM
vs. Local
Account (cannot be a local account in the current topology: Distributed
Server Deployment with Three computers)
The
SharePoint Database Access will be granted during Report Server
Configuration in SharePoint Central Administration on SHAREPOINT2007
documentation:
How to:
Configure a Service Account for Reporting Services
Name and Password:
Passw0rd
Description:
Application pool identity
This account will be used when
creating the fist Web Application and its Application Pool.
vs. Local
Account (cannot be a local account in the current topology: Distributed
Server Deployment with Three computers)
No manual configuration is necessary.
Use a separate domain user account for each application pool.
This account should not be a member of the Administrators group on any
computer in the server farm
The following are automatically configured:
Membership in the db_owner role for content
databases and search databases associated with the Web application.
Access to read from the configuration and the SharePoint_AdminContent
databases.
Additional permissions for this account to front-end Web servers and
application servers are automatically granted.
documentation:
How to:
Configure a Service Account for Reporting Services
The installation performed in this tutorial includes the following steps:
- Step 1: Installation of SQL Server 2008 on SQLSERVER2008
- Step 2: Installation of SQL Server Reporting Services 2008 on SSRS2008SPIM
- Step 3: Installation of SharePoint 2007 on SHAREPOINT2007
- Step 4: Installation of SharePoint 2007 on SSRS2008SPIM
- Step 5: Configuration and test of the Report Server on SSRS2008SPIM
- Step 6: Installation of SQL Server Reporting Services 2008 Add In for
SharePoint on SHAREPOINT2007, Configuration and Check.
- Step 7: BIDS installation, Report creation, deployment and test.
WARNING:
when you are installing SQL Server Reporting
Services 2008 in SharePoint Integrated Mode, and want to keep being compliant
with the least-privilege administration principle, this principle and its
limited permissions become a problem because both, the configuration of report
server and the installation of SQL Server Reporting Services Add in for
SharePoint fail due to the limited access of all these accounts. But with a
workaround you can install the products combination properly and restore the
permissions keeping compliant with the least privilege administration. Read
carefully the following:
administrative and service accounts (Windows SharePoint Services)
[...]
Least-privilege administration requirements when using domain
user accounts
Least privilege administration is a recommended
security practice in which each service or user is provided with only the
minimum privileges needed to accomplish the tasks they are authorized to
perform. This means that each service is granted access to only the resources
that are necessary to its purpose. The minimum requirements to achieve this
design goal include the following:
- Separate accounts are used for
different services and processes.
- No executing service or process
account is running with local administrator permissions.
By using
separate service accounts for each service and limiting the permissions assigned
to each account, you reduce the opportunity for a malicious user or process to
compromise your environment.
Least privilege administration with domain user
accounts is the recommended configuration for most environments.
[...]
Regarding Windows SharePoint Services 3.0, let us examine the minimal
services and processes needed and we will understand least privilege basic
administration for SharePoint.
- Setting up SharePoint on each server computer: task requiring local
administrator permissions
- Running the SharePoint Products and Technologies Configuration Wizard:
task requiring local administrator permissions
- Executing a Psconfig command-line: task requiring local administrator
permissions
- Executing an Stsadm command-line: task requiring local administrator
permissions
- Running the process of application pool identity for the SharePoint
Central Administration Web site: process that does not require local
administrator permissions
- Running the Windows SharePoint Services Timer service: service that does
not require local administrator permissions
enumeration, if we assign the four first tasks to an account that has the local
administrator permission, and the two last to an account that has not the
administrator permissions, we are compliant with the least privilege
administration principle.
Thus, the least privilege administration principle
for SharePoint is based on two main user accounts:
- Setup Account
- Farm Account
of all the servers where SharePoint is deployed. It is used also to run the
SharePoint Products and Technologies Configuration Wizard, and to execute Stsadm
and Psconfig command. This account is also one of the Farm administrators, and
has access to the entire operations provided by the SharePoint Central
Administration.
The Farm Account appears as System
Account when you are signed in with it on a SharePoint site, but is not
Administrator of any SharePoint server, thus you cannot perform a Psconfig or
Stsadm command using it. You cannot run the SharePoint Products and Technologies
Configuration Wizard with it.
Furthermore, in SharePoint Central
Administration, the Farm account cannot access to the entire administration
tasks, for example, when you are connected to SharePoint Central Administration
with this account, in the Tab Operations, you cannot see the following links:
- Services on Server
- Incoming e-mail settings
- Remove SharePoint from IIS Web Site
The Application Pool Identity Account is an
account used during the creation of the first Web Application. The least
privilege administration requirements for this account are:
Use a separate domain user account for each application pool.
This account should not be a member of the Administrators group on any
computer in the server farm.
The Report Server Account
Adding Reporting
Services to SharePoint, there is a fourth account that must have least
privilege, it is the Report Server account, here called SSRS_SERVICE. For this
account, very simple, it has no permissions at all. However, it might be useful
to use it during installation process, you will see why...
The Installation Sequence overview with the workarounds
Now let us see how we are going to use these accounts performing an
installation of Reporting Services and Sharepoint on two different computers,
and the workaroud to install the Reporting Services Add In for SharePoint.
01 - Use the SharePoint Setup Account to install Reporting Services on
the Report Server computer (it has local administrator permissions for this
computer because it will be used to install SharePoint on this computer later).
02 - Use the SharePoint Setup Account to install SharePoint on the
SharePoint Server.
03 - Use SharePoint Setup Account to create
the Web Application but when prompted, refence the Application Pool
Identity Account
The additional operation will be to grant the dbo or
db_owner permissions for the new created content database to the SPS_SETUP
account as specified in Technet documentation previously mentioned:
After
each database has been created, change the database owner (dbo
or db_owner) to the Setup User account.
04 - Configuring Reporting Services on the Report Server.
Here again there is additional operation to perform.
Let us examine
the permissions required by the account configuring SQL Server Reporting
Services 2008.
- Local administrator of the Report Server computer
If the account you
are logged on with is not local admnistrator of the computer, you cannot open
Reporting Services Configuration Manager.
- high privileges on the Database Engine
During the Report Server
Databases creation, the configuration process is not only creating the
ReportServer and the ReportServerTemp Databases, but also configuring the
Databases (rights generation, connection rights application), and the account
used by the process needs high privileges on the Database Engine. For example,
there is a request on msdb database :USE msdb
if not exists (select * from sysusers where issqlrole = 1 and name = 'RSExecRole')
BEGIN
EXEC sp_addrole 'RSExecRole'
END
The consequence is that you cannot configure Reporting
Services with SPS_SETUP account, since it has unfortunately not enough
permissions on the database engine.
You have two solutions:
You grant temporary the database engine sysadmin
permission to the Setup account
You add temporary the SQL DataBase Engine
administrator account to the administrators group of Report Server computer, and
you use this account to configure reporting Services.
the second solution will be never used).
05 - Workaround for Add In installation:
When you are
installing Reporting Services Add In for SharePoint on the SharePoint computer,
you have temporary to grant the database engine sysadmin permission to the Setup
account AND to add temporary the Farm account to the machine Administrators,
otherwise the Reporting Services Add In installation fail over.
SharePoint Setup or Farm Account to configure Reporting Services on the
SharePoint Server.
Installation Trick:
In the current installation
tutorial I have taken advantage of this workaround to perform Reporting Services
Configuration with the Reporting Services Account (here called SSRS_SERVICE).
Doing that I am able to check that the Report Server Web Service works well
before installing Reporting Services Add In for SharePoint.
In order to be
allowed to do that, I had temporary to grant the database engine sysadmin
permission to the SSRS_SERVICE account and to temporary add this account to the
Report Server computer Administrators. (only computer Administrators can
configure Reporting Services)
Services with the SharePoint Setup account. In that case, you will still have to
grant special and temporary sysadmin permissions for this account but will
unfortunately have to wait the end of the installation to be sure that the
Report Server Web Service works properly.
I will remind these operations in time using the red
color.
3.1 - name=Step-1:-Installation-of-SQL-Server-2008-on-SQLSERVER2008>Step 1:
Installation of SQL Server 2008 on SQLSERVER2008
Installation of SQL Server 2008 on SQLSERVER2008
Logon to SQL2008 with a domain user account that is
administrator of the computer.
Launch SQL Server 2008 installation.
Follow all steps of the previous post href="http://mosshowto.blogspot.com/2009/01/integrating-sql-server-2008-reporting.html">Integrating
reporting Services 2008 with SharePoint 2007 Step 1 - SQL Server 2008
installation from step 1 to step 9.
On Step 10 - Selecting Installation features, select:
- Database Engine Services
- Full-Text Search (it is for SQL 2008 Samples: Adventure Works).
- Management Tools - Basic (SQL Server Management Studio).
- Management Tools - Complete (SQL Server Management Studio complement
included those for Reporting Services).
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4MpMFbi82Twahc6ckMyMuSrN3tfVaSwtSIVhe5s_qOY_0gubt8w7HVK7Oxk56DPOJiXTkX6X7PV61ctF_TRVhVhuQ1oteSAvCNvU_AzsQtKkbA2VTevaf9AeAXnEF_PkUS8XmDLFgL0zt/s1600-h/SSRS2008MultipleServersInstall_01_SQL2008Features.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4MpMFbi82Twahc6ckMyMuSrN3tfVaSwtSIVhe5s_qOY_0gubt8w7HVK7Oxk56DPOJiXTkX6X7PV61ctF_TRVhVhuQ1oteSAvCNvU_AzsQtKkbA2VTevaf9AeAXnEF_PkUS8XmDLFgL0zt/s320/SSRS2008MultipleServersInstall_01_SQL2008Features.JPG"
border=0>
Follow the procedure until step 12
Use the same account for all services: SQL_SERVICE.
Set the
SQL Server Agent account to be started Automatically, because it will be used
for Standard or Data Driven Subscriptions in Integrated mode and thus, has to be
enabled and always started.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ_fKtBfEEW0wKqnQ05PVDqQo6MGKk2qWTSheWJaSxcexBYXhoyI7YPrUKafAzfPcZxag-qMzSVEvRWjFILifIxSEz13tMuP-Rs-qGghjubCMp9765ByfbhFISbphEOJm4TzYqKdpeDu1r/s1600-h/SSRS2008MultipleServersInstall_02_SQL2008ServerConfiguration.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 241px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ_fKtBfEEW0wKqnQ05PVDqQo6MGKk2qWTSheWJaSxcexBYXhoyI7YPrUKafAzfPcZxag-qMzSVEvRWjFILifIxSEz13tMuP-Rs-qGghjubCMp9765ByfbhFISbphEOJm4TzYqKdpeDu1r/s320/SSRS2008MultipleServersInstall_02_SQL2008ServerConfiguration.JPG"
border=0>
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyOShZpuNv9ELzQdpdusJ6kz15P1u6JR6a-jP8pesiFODhLV6x7hXLN0wvIIVFWa729qTUZUpiOsKktsDkusQvjO2_lrTV6r6YfvmgUozc-ytsuXGn80osoSlj2q-c1UpVNblyrfx4O8Z1/s1600-h/SSRS2008MultipleServersInstall_03_SQL2008ServerConfigurationDone.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 241px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyOShZpuNv9ELzQdpdusJ6kz15P1u6JR6a-jP8pesiFODhLV6x7hXLN0wvIIVFWa729qTUZUpiOsKktsDkusQvjO2_lrTV6r6YfvmgUozc-ytsuXGn80osoSlj2q-c1UpVNblyrfx4O8Z1/s320/SSRS2008MultipleServersInstall_03_SQL2008ServerConfigurationDone.JPG"
border=0>
Do not
forget the Collation settings otherwise you will have an exception during
SharePoint deployment.
This is the Installation Complete Screen Shot.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigfoE7qIsjhqSzD6-a5qKJST4u4PapoB1UjuYd_nT8jjpCNLSQwoQrWD05cCcOl6all5RWPebtoK7fZitksOLE7LetIpMXj2Su0YwK2xi76FZvgoSi9cNfDo01e5g_cyr4vC_Temjzvq9D/s1600-h/SSRS2008MultipleServersInstall_04_SQL2008InstallationSuccess.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 241px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigfoE7qIsjhqSzD6-a5qKJST4u4PapoB1UjuYd_nT8jjpCNLSQwoQrWD05cCcOl6all5RWPebtoK7fZitksOLE7LetIpMXj2Su0YwK2xi76FZvgoSi9cNfDo01e5g_cyr4vC_Temjzvq9D/s320/SSRS2008MultipleServersInstall_04_SQL2008InstallationSuccess.JPG"
border=0>
and the screen shot of the SQL Server Management Studio
open.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtg_t8TzDjWTeRAagihXZNNqej_xyAEQoBuFejRS2B1IVCwEV77YnhCRSWcTnt7vyMFYspVu3AEfvYpiwWB72CjestEnt73O48IBYxcYqQOhP-smTSKWraCEg85gvIflYyMiMjn8K5EEtK/s1600-h/SSRS2008MultipleServersInstall_05_SQL2008InstallationCheck.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 190px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtg_t8TzDjWTeRAagihXZNNqej_xyAEQoBuFejRS2B1IVCwEV77YnhCRSWcTnt7vyMFYspVu3AEfvYpiwWB72CjestEnt73O48IBYxcYqQOhP-smTSKWraCEg85gvIflYyMiMjn8K5EEtK/s320/SSRS2008MultipleServersInstall_05_SQL2008InstallationCheck.JPG"
border=0>
Do not forget to configure connections protocol with SQL
Server Network Configuration Area
3.2 - name=Step-2:-Installation-of-SQL-Server-Reporting-Services-2008>Step 2:
Installation of SQL Server Reporting Services 2008 on SSRS2008SPIM
Installation of SQL Server Reporting Services 2008 on SSRS2008SPIM
01 - name=Start-SQL-Server-2008-installation-on-report-sever-computer>Start SQL
Server 2008 installation
Server 2008 installation
Logon to SSRS2008SPIM with a domain user
account that is administrator of the computer.
Launch SQL Server 2008
installation.
Follow all steps of the previous post href="http://mosshowto.blogspot.com/2009/01/integrating-sql-server-2008-reporting.html">Integrating
reporting Services 2008 with SharePoint 2007 Step 1 - SQL Server 2008
installation from step 1 to step 9.
On Step 10 - Selecting Installation features,
select:
- Reporting Services
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdSZkJPhLySj54Zydns7GO0JKiTrr512eu5-VlIH7cJUy6f-hE1yMzP4HgxXGIvmxx4LlMhsGSwd8yzD0X_6AzEK_h7jYKMmkbdPMIpvGlXwrq-k8Ioexze7eoWRvQV5dN0vsL2a2tgND9/s1600-h/SSRS2008MultipleServersInstall_06_SSRS2008Features.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdSZkJPhLySj54Zydns7GO0JKiTrr512eu5-VlIH7cJUy6f-hE1yMzP4HgxXGIvmxx4LlMhsGSwd8yzD0X_6AzEK_h7jYKMmkbdPMIpvGlXwrq-k8Ioexze7eoWRvQV5dN0vsL2a2tgND9/s320/SSRS2008MultipleServersInstall_06_SSRS2008Features.JPG"
border=0>
Follow the procedure until step 12
Use the SSRS 2008 service account: SSRS_SERVICE.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQDqTnnUvPbFpjh2KMXVSya9PIRdYb3hxzAEoCLPJY2k4GQQatW7tZLGFUdrTaxBpUSJIU3GOkCmk3ZMlBWnE60d4cc7RNEhT2SoupN0bp4j8ozO3ThF_Gi5iaZzcLMexB2TI9KKi5zP6_/s1600-h/SSRS2008MultipleServersInstall_07_SSRS2008ServerConfiguration.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 150px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQDqTnnUvPbFpjh2KMXVSya9PIRdYb3hxzAEoCLPJY2k4GQQatW7tZLGFUdrTaxBpUSJIU3GOkCmk3ZMlBWnE60d4cc7RNEhT2SoupN0bp4j8ozO3ThF_Gi5iaZzcLMexB2TI9KKi5zP6_/s320/SSRS2008MultipleServersInstall_07_SSRS2008ServerConfiguration.JPG"
border=0>
We have to select the last option because SharePoint is not
installed, neither on SHAREPOINT2007 computer nor on SSRS2008SPIM one.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNJGeoLGzZZk-dU_1sigk8k1ftQ-39B-niMaQ6a0UTUYkJLOh5BMzDjtcDrB_MAgg3jXb6NGILWF-p-4FDA9xGLjPxWy6MG0rtLtHX_mv5-M74hhXZ_Nph0YhDEnWaOHksdlgszRnvjGih/s1600-h/SSRS2008MultipleServersInstall_08_SSRS2008ReportingServicesConfiguration.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 182px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNJGeoLGzZZk-dU_1sigk8k1ftQ-39B-niMaQ6a0UTUYkJLOh5BMzDjtcDrB_MAgg3jXb6NGILWF-p-4FDA9xGLjPxWy6MG0rtLtHX_mv5-M74hhXZ_Nph0YhDEnWaOHksdlgszRnvjGih/s320/SSRS2008MultipleServersInstall_08_SSRS2008ReportingServicesConfiguration.JPG"
border=0>
This is the Installation Complete Screen Shot.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4Ig1NgYbsrdRvM4JaQfeCP49lsj1v1kHMyYWbm6-p1pPHkOZQFb8qnCjKHSBgUX6fmLIxg9JWrw5CncC1xcCJNKR_ZbCXAT-FMOBwHOQXoMhkiEAXUjI0vVL-2c-32DoOfDV73YT4lro3/s1600-h/SSRS2008MultipleServersInstall_09_SSRS2008InstallationSuccess.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 234px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4Ig1NgYbsrdRvM4JaQfeCP49lsj1v1kHMyYWbm6-p1pPHkOZQFb8qnCjKHSBgUX6fmLIxg9JWrw5CncC1xcCJNKR_ZbCXAT-FMOBwHOQXoMhkiEAXUjI0vVL-2c-32DoOfDV73YT4lro3/s320/SSRS2008MultipleServersInstall_09_SSRS2008InstallationSuccess.JPG"
border=0>
The screen shot of the Reporting Services Service.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKT36Cp80GNSoFhh_1-0dums11AlphopWheg5wbXfB0BrzfmBWq9vs4yWVNf4j-PZxQttvlEwwdr8MjWX1gu4YSJDNEjJrLjFoWRSY4YdhgIooGkdtggD9XQ_BTeMQCH_S7vmdGegQnaLU/s1600-h/SSRS2008MultipleServersInstall_10_SSRS2008InstallationCheck1.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 70px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKT36Cp80GNSoFhh_1-0dums11AlphopWheg5wbXfB0BrzfmBWq9vs4yWVNf4j-PZxQttvlEwwdr8MjWX1gu4YSJDNEjJrLjFoWRSY4YdhgIooGkdtggD9XQ_BTeMQCH_S7vmdGegQnaLU/s320/SSRS2008MultipleServersInstall_10_SSRS2008InstallationCheck1.JPG"
border=0>
The screen shots of the welcome Pages of the Report Server
Configuration Tool
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6HWCzoVd5nTniN34CGoAXS0HvGNmakTSNTQlIEVprLL-4KKDLQN22FJQ38SQtRuQT-DYmCrJoqB2FzqFSmFwJwYjA-E-HWRJ2bJqv1Sd6Kd5no6ZFpl0O3IiGylZGkqibEC7QposGfMkp/s1600-h/SSRS2008MultipleServersInstall_11_SSRS2008InstallationCheck2.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 150px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6HWCzoVd5nTniN34CGoAXS0HvGNmakTSNTQlIEVprLL-4KKDLQN22FJQ38SQtRuQT-DYmCrJoqB2FzqFSmFwJwYjA-E-HWRJ2bJqv1Sd6Kd5no6ZFpl0O3IiGylZGkqibEC7QposGfMkp/s320/SSRS2008MultipleServersInstall_11_SSRS2008InstallationCheck2.JPG"
border=0>
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKNxOAfMkfM5BwuDD8JQTr3YlgFd9Hyri_2bfydJj0NYJFtfP_fKkvsOTyhtaSXLa4oaADmn5ASgpZfmtkiBrKOJhHAoKwpK-SDhKfpn54N8zrNsmt_pvGiCFrq3EPm88BxHXnGvji_BCM/s1600-h/SSRS2008MultipleServersInstall_12_SSRS2008InstallationCheck3.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 254px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKNxOAfMkfM5BwuDD8JQTr3YlgFd9Hyri_2bfydJj0NYJFtfP_fKkvsOTyhtaSXLa4oaADmn5ASgpZfmtkiBrKOJhHAoKwpK-SDhKfpn54N8zrNsmt_pvGiCFrq3EPm88BxHXnGvji_BCM/s320/SSRS2008MultipleServersInstall_12_SSRS2008InstallationCheck3.JPG"
border=0>
3.3 - name=Step-3:-Installation-of-SharePoint-2007-on-SHAREPOINT2007>Step 3:
Installation of SharePoint 2007 on SHAREPOINT2007
Installation of SharePoint 2007 on SHAREPOINT2007
01 - name=Create-SharePoint-databases-and-grant-permissions-to-SPS_SETUP-domain-account>Create
SharePoint databases and grant permissions to SPS_SETUP domain account
Logon to SQL2008 with SQL_SERVICE domain service account. SharePoint databases and grant permissions to SPS_SETUP domain account
open SQL
Server management Studio.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUik1gTF-CLmsCiNWNvHJ0H61qPlBn9DTTSEChM-sibR6C61RvXaddB_JhHk_dMCXDBJUAICRF4DH1ZQ7hH_RlGCdHfe9orl7MHUKcT-EzrH-Wj6w-VXzCxkMs9GvmBseu3wcdwKUv8Di2/s1600-h/SSRS2008MultipleServersInstall_13_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm1.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 272px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUik1gTF-CLmsCiNWNvHJ0H61qPlBn9DTTSEChM-sibR6C61RvXaddB_JhHk_dMCXDBJUAICRF4DH1ZQ7hH_RlGCdHfe9orl7MHUKcT-EzrH-Wj6w-VXzCxkMs9GvmBseu3wcdwKUv8Di2/s320/SSRS2008MultipleServersInstall_13_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm1.JPG"
border=0>
Create databases as in the previous post: href="http://mosshowto.blogspot.com/2009/01/reporting-services-2008-sharepoint-2007.html">Integrating
Reporting Services 2008 with SharePoint 2007 - SharePoint Installation
In Management Studio right click Login node click "New Login"
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9vOU7bF6H183cF_hZ6KIUHWAoUFOm8Mfv5MWjgEyZrc0qAm6TGcD6cE9BoOECKZldT4pXYTDN8-vHjQD1Wb6mWOjq8Tk8C8J5kdXefVjlFMJokAiLXCqxy0Q5srxKxGE2YfqSNsvB1aeQ/s1600-h/SSRS2008MultipleServersInstall_14_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm2.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 190px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9vOU7bF6H183cF_hZ6KIUHWAoUFOm8Mfv5MWjgEyZrc0qAm6TGcD6cE9BoOECKZldT4pXYTDN8-vHjQD1Wb6mWOjq8Tk8C8J5kdXefVjlFMJokAiLXCqxy0Q5srxKxGE2YfqSNsvB1aeQ/s320/SSRS2008MultipleServersInstall_14_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm2.JPG"
border=0>
On the "Login-New" Pop Up type "CORPORATE\SPS_SETUP" as
new login name.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggMnkS4z2cRpCDUyuFdsOe2X-hNdAGtwKnFTMyIuNpLMo0obkw6vuNRuS_VSnG8TYIVMcd7ktwTY9uEiNljKAWDqMZgE1kkutt_ybaJT4CT7FPULNCtcVLEUWb9SqMSv9vWgDXgTSNbpUu/s1600-h/SSRS2008MultipleServersInstall_15_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm3.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 288px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggMnkS4z2cRpCDUyuFdsOe2X-hNdAGtwKnFTMyIuNpLMo0obkw6vuNRuS_VSnG8TYIVMcd7ktwTY9uEiNljKAWDqMZgE1kkutt_ybaJT4CT7FPULNCtcVLEUWb9SqMSv9vWgDXgTSNbpUu/s320/SSRS2008MultipleServersInstall_15_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm3.JPG"
border=0>
You can check the new Login creation in SQL Server 2008
Management Studio
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHboayKp9EcAMg59Hx3E_NJrebAZXKQePVxQspBvS4XXLG-WK4l1JOwvV6M8sikhw6r4c97_vgVmmZ4g59e969ri5nxYMKW1sCG4WVWX6iPIBLQ6xLJiNS86PxMqNfAW_dsTIZHG5HlmsK/s1600-h/SSRS2008MultipleServersInstall_16_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm4.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 190px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHboayKp9EcAMg59Hx3E_NJrebAZXKQePVxQspBvS4XXLG-WK4l1JOwvV6M8sikhw6r4c97_vgVmmZ4g59e969ri5nxYMKW1sCG4WVWX6iPIBLQ6xLJiNS86PxMqNfAW_dsTIZHG5HlmsK/s320/SSRS2008MultipleServersInstall_16_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm4.JPG"
border=0>
Right click the new login and click "Properties"
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizwYe5_q-q-mdcza6fEG20r5QwqEwiM2yWAOWd_2xOg9SQu-uHjtSO5pjLb8wVhhf85keJMaT881wMwX93EhllZa8BpKPUuWMSGNAUK1QsV0jb8rtJnObKYQ4XeI1wAkza1iQtn7n-lumd/s1600-h/SSRS2008MultipleServersInstall_17_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm5.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 206px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizwYe5_q-q-mdcza6fEG20r5QwqEwiM2yWAOWd_2xOg9SQu-uHjtSO5pjLb8wVhhf85keJMaT881wMwX93EhllZa8BpKPUuWMSGNAUK1QsV0jb8rtJnObKYQ4XeI1wAkza1iQtn7n-lumd/s320/SSRS2008MultipleServersInstall_17_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm5.JPG"
border=0>
Login-properties Dialog is opening.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwGU0_-40k0tKgxKZ6o0thH-h4X69kyjvjNh5llRsjRr0JKvm_r9t69cvpeYesizOnwvPD4CwBCZUKgVUtQbjWoEJjmF2W4fgZ7AS46m5fVFsqposMu7f6mxC2wa0hhpPWDFQLl79wpwmt/s1600-h/SSRS2008MultipleServersInstall_18_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm6.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 287px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwGU0_-40k0tKgxKZ6o0thH-h4X69kyjvjNh5llRsjRr0JKvm_r9t69cvpeYesizOnwvPD4CwBCZUKgVUtQbjWoEJjmF2W4fgZ7AS46m5fVFsqposMu7f6mxC2wa0hhpPWDFQLl79wpwmt/s320/SSRS2008MultipleServersInstall_18_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm6.JPG"
border=0>
Double click Server Roles, and in the opening Dialog,
check "SecurityAdmin" and "DbCreator".
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfzoS88UKZ9PnzsTGGNsMvbx4YCP0_p0E1EpYJPz-3MAtZ5Mr-hY0dW-pfTjF1w1sFhyphenhyphenIxojjXM4VKckdCFymo7fw1eaifz34hmqLQSeCtG9Ep0iWupNQL0kpbJ9tm3MG7LGeX0AokOMKO/s1600-h/SSRS2008MultipleServersInstall_19_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm7.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 287px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfzoS88UKZ9PnzsTGGNsMvbx4YCP0_p0E1EpYJPz-3MAtZ5Mr-hY0dW-pfTjF1w1sFhyphenhyphenIxojjXM4VKckdCFymo7fw1eaifz34hmqLQSeCtG9Ep0iWupNQL0kpbJ9tm3MG7LGeX0AokOMKO/s320/SSRS2008MultipleServersInstall_19_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm7.JPG"
border=0>
double Click User mappings, and in the opening Dialog,
locate the two SharePoint databases SharePoint_Config and
SharePoint_AdminContent.
For each of these databases, grant SPS_SETUP
account the following permission:
"DbOwner".
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN_zLljVxpEW7xY3FzpNDnfjEoKGpkswaQbEyDX7MxEuuSVUJozaw_XQj7q6wpwfHdSe2uZe5lDik-8xKDzB4yG7C8BrKwdiKTBQhhyphenhyphenVRBpv5-flaSu-tbaz8jgAM8-0pYlOQv52c90VSI/s1600-h/SSRS2008MultipleServersInstall_20_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm8.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 287px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN_zLljVxpEW7xY3FzpNDnfjEoKGpkswaQbEyDX7MxEuuSVUJozaw_XQj7q6wpwfHdSe2uZe5lDik-8xKDzB4yG7C8BrKwdiKTBQhhyphenhyphenVRBpv5-flaSu-tbaz8jgAM8-0pYlOQv52c90VSI/s320/SSRS2008MultipleServersInstall_20_SharePoint2007InstallationOnSHAREPOINT2007-AccountPerm8.JPG"
border=0>
02 - name=Start-SharePoint-installation-on-SHAREPOINT2007>Start SharePoint
installation on SHAREPOINT2007
installation on SHAREPOINT2007
Logon to SHAREPOINT2007 with the
SPS_SETUP domain user account.
Launch SHAREPOINT 2007 installation as in the
previous post.
Follows the steps 4 to 9. (Until closing the first
installation wizard with the check box unchecked).
Open a command prompt
and type the following line:
psconfig -cmd configdb -create -server SQL2008
-database SharePoint_Config -user CORPORATE\SPS_FARM -password Passw0rd
-admincontentdatabase SharePoint_AdminContent
execute the command.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEispFoN9CP0FEnu5CiSM2xGaectCDh3l0ov-EtceCE5tV4fUYfma7w_9No1j4dAmFZUzD8R-jkMrc6gWgxTF3xPGjTyMzL34A_QymqeR9d6zjW9C7Bm0vsl3aZXvgJOFxBupSPkRBryvcbk/s1600-h/SSRS2008MultipleServersInstall_21_SharePoint2007InstallationOnSHAREPOINT2007-psconfigCommand.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 130px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEispFoN9CP0FEnu5CiSM2xGaectCDh3l0ov-EtceCE5tV4fUYfma7w_9No1j4dAmFZUzD8R-jkMrc6gWgxTF3xPGjTyMzL34A_QymqeR9d6zjW9C7Bm0vsl3aZXvgJOFxBupSPkRBryvcbk/s320/SSRS2008MultipleServersInstall_21_SharePoint2007InstallationOnSHAREPOINT2007-psconfigCommand.JPG"
border=0>
You will obtain this window after performing the command.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1pJERKRzm0J_PiuHWjmebGDp_vWq86Q5fN_l_mA6RuR3w58Pa_Ei-YyP2z62SBawuiDcWHqn86TSplpcceL95eB3SEckDRkLD6FSjoU2cmVJPbveuZWph-plAt1R5deP8vS_aUmSy0NMP/s1600-h/SSRS2008MultipleServersInstall_22_SharePoint2007InstallationOnSHAREPOINT2007-psconfigCommandDone.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 218px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1pJERKRzm0J_PiuHWjmebGDp_vWq86Q5fN_l_mA6RuR3w58Pa_Ei-YyP2z62SBawuiDcWHqn86TSplpcceL95eB3SEckDRkLD6FSjoU2cmVJPbveuZWph-plAt1R5deP8vS_aUmSy0NMP/s320/SSRS2008MultipleServersInstall_22_SharePoint2007InstallationOnSHAREPOINT2007-psconfigCommandDone.JPG"
border=0>
03 - name=Running-SharePoint-Product-and-Technologies-Configuration-Wizard>Running
SharePoint Product and Technologies Configuration Wizard
Run the SharePoint SharePoint Product and Technologies Configuration Wizard
Product and Technologies Configuration Wizard as in the previous post, but with
the multiple Server Environment parameters.
You can check the parameters on
the following screen shots.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDPEEonROtJssHEAzCsT8CKsYLef7rw8ThUpzG7mOM8QCoaxMhjCymXUtfMMj14yjsFolLzLFHhhfZtZBqoUnJYlNy2ept87Jsnpy740znEWrhK2-oQ3hwIYub_wQrL-IesQyCIjh_LMQ1/s1600-h/SSRS2008MultipleServersInstall_23_SharePoint2007InstallationOnSHAREPOINT2007-SPPTWizard1.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 274px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDPEEonROtJssHEAzCsT8CKsYLef7rw8ThUpzG7mOM8QCoaxMhjCymXUtfMMj14yjsFolLzLFHhhfZtZBqoUnJYlNy2ept87Jsnpy740znEWrhK2-oQ3hwIYub_wQrL-IesQyCIjh_LMQ1/s320/SSRS2008MultipleServersInstall_23_SharePoint2007InstallationOnSHAREPOINT2007-SPPTWizard1.JPG"
border=0>
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5nZLTKq0DKw2_mgLpLtI_fQbhipyvhqyzqqx3aKZTb-nnkBpjy5myjGead-aFTpoWMr0birb3zjrEYV1HR_VUlMHAd10S8QSABajkbiRWkkloCJnve_D8yxhyphenhyphenFXgkOwb9OSS6t40IByU0/s1600-h/SSRS2008MultipleServersInstall_24_SharePoint2007InstallationOnSHAREPOINT2007-SPPTWizard2.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 274px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5nZLTKq0DKw2_mgLpLtI_fQbhipyvhqyzqqx3aKZTb-nnkBpjy5myjGead-aFTpoWMr0birb3zjrEYV1HR_VUlMHAd10S8QSABajkbiRWkkloCJnve_D8yxhyphenhyphenFXgkOwb9OSS6t40IByU0/s320/SSRS2008MultipleServersInstall_24_SharePoint2007InstallationOnSHAREPOINT2007-SPPTWizard2.JPG"
border=0>
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzLDEWxxyl9S3tnQ8fG3yXxTUp4zJ7bAO0b3w1vA3PDD35jXeFIY8_ydZkSVmdUMSXSNIzzCNB517hh8PuBPXP4ul0qLWHE667LlQlyl1DYMLuepL5tkt_uFwSIv1AWaD9sWvKxnjSgjyi/s1600-h/SSRS2008MultipleServersInstall_25_SharePoint2007InstallationOnSHAREPOINT2007-SPPTWizardDone.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 274px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzLDEWxxyl9S3tnQ8fG3yXxTUp4zJ7bAO0b3w1vA3PDD35jXeFIY8_ydZkSVmdUMSXSNIzzCNB517hh8PuBPXP4ul0qLWHE667LlQlyl1DYMLuepL5tkt_uFwSIv1AWaD9sWvKxnjSgjyi/s320/SSRS2008MultipleServersInstall_25_SharePoint2007InstallationOnSHAREPOINT2007-SPPTWizardDone.JPG"
border=0>
At the end of the process as usual, you will obtain the
displaying of the Central Administration Home page
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiII3GKHhwWQHB7FF15u0G72_1_3w85or5QWd7p-zUy8H9l7eDrFed1iqRTvzNiD_tAgKlvxIzYF7cMszrMa-_yCMDsF9v7V5NVmq-36EvcBoANbA2qhCRNE_ZGIx6J2-s0D0GozouEOpdE/s1600-h/SSRS2008MultipleServersInstall_26_SharePoint2007InstallationOnSHAREPOINT2007-CaentralAdmin.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 239px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiII3GKHhwWQHB7FF15u0G72_1_3w85or5QWd7p-zUy8H9l7eDrFed1iqRTvzNiD_tAgKlvxIzYF7cMszrMa-_yCMDsF9v7V5NVmq-36EvcBoANbA2qhCRNE_ZGIx6J2-s0D0GozouEOpdE/s320/SSRS2008MultipleServersInstall_26_SharePoint2007InstallationOnSHAREPOINT2007-CaentralAdmin.JPG"
border=0>
03 - name=Creating-a-Web-Application-on-port-81>Creating a Web Application on
port 81 and a TestReportingServices Site Collection.
port 81 and a TestReportingServices Site Collection.
In order to have a Site Collection with a Root Web Site that can display SQL
Server reporting services 2008 Reports, DataSources and so on in a SharePoint
2007 document library,
Perform the steps 2 to 4 of the previous
post:
href="http://mosshowto.blogspot.com/2009/01/integrating-ssrs-2008-sharepoint-2007.html">Integrating
Reporting Services 2008 with SharePoint 2007 step 4 - Configuring reporting
services for SharePoint 3.0 Integration
For step 5 because we are in a multiple server
environement and want to be compliant with the least privilege
administration principle, do the following:
style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px; FONT-WEIGHT: normal; FONT-SIZE: 10pt; PADDING-BOTTOM: 5px; MARGIN: 1px 0px; COLOR: gray; PADDING-TOP: 5px; FONT-FAMILY: arial; TEXT-ALIGN: justify">In
the "Create New Web Application" page, Application Pool section, select "Create
new application pool" option, type the name of your new Application Pool, select
"Cofigurable" and type the name and the password of the Application Pool
Identity domain account.
style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px; FONT-WEIGHT: normal; FONT-SIZE: 10pt; PADDING-BOTTOM: 5px; MARGIN: 1px 0px; COLOR: gray; PADDING-TOP: 5px; FONT-FAMILY: arial; TEXT-ALIGN: justify">Then,
perform your Site Collection creation and check that the Site Collection is
properly created.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNMAvgCjPX7dljX1LJvTd81arC78gNBnh22HS8aVaDj5mAyFmhZeNGIGozLczMfxi5NEJZplgzmTHcubJcENI8hv6Mns7Zn_e7D87H48l8IbhNz8NW9vi9b2P8VQ8sPMwrIea7ViTJFveC/s1600-h/SSRS2008MultipleServersInstall_27_SharePoint2007InstallationOnSHAREPOINT2007-TestSSRSSiteColl.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNMAvgCjPX7dljX1LJvTd81arC78gNBnh22HS8aVaDj5mAyFmhZeNGIGozLczMfxi5NEJZplgzmTHcubJcENI8hv6Mns7Zn_e7D87H48l8IbhNz8NW9vi9b2P8VQ8sPMwrIea7ViTJFveC/s320/SSRS2008MultipleServersInstall_27_SharePoint2007InstallationOnSHAREPOINT2007-TestSSRSSiteColl.JPG"
border=0>
Now, we have to grant the dbo permission to the
SPS_SETUP account for the brand new created WSS_Content_WEBAPP81 content
database. If we do not do that, we will not be able to perform operations using
stsadm command for the new created Web Application, its Site Collections,
its Web Sites, etc., because we will get an "Access Denied"
exception.
Logon to the SQL Server computer (SQL2008).
Open the SQL
Management Studio.
Locate the login for SPS_SETUP account.
Right Click the
Login and select properties.
In the opening dialog click "User
Mapping".
Locate the WSS_Content_WebApp81 database.
Check the check box
for the database.
In "Database role member ship
for: WSS_Content_WEBAPP81" pane check the check box for
db_owner.
Click OK.
3.4 - name=Step-4:-Installation-of-SharePoint-2007-on-SSRS2008SPIM>Step 4:
Installation of SharePoint 2007 on SSRS2008SPIM
Installation of SharePoint 2007 on SSRS2008SPIM
01 - name=Start-SharePoint-installation-on-SSRS2008SPIM>Start SharePoint
installation on SSRS2008SPIM
Logon to SSRS2008SPIM with the SPS_SETUP installation on SSRS2008SPIM
domain user account (that has Administrator permissions on this server too).
First of all start by stopping the IIS default web site in
order to avoid conflicts with the web service of Report server that also uses
port 80.
Launch SHAREPOINT 2007 installation as in the previous post: href="http://mosshowto.blogspot.com/2009/01/reporting-services-2008-sharepoint-2007.html">Integrating
Reporting Services 2008 with SharePoint 2007 - SharePoint Installation
Follows the steps 4 to 9. (Until closing the first installation
wizard with the check box unchecked).
When Setup finishes, a dialog box
prompt you to complete the configuration of your server. Be sure that the "Run
the SharePoint Products and technologies Configuration Wizard now" check box
IS selected. (It is the opposite of what we have done for installation of
SharePoint 2007 on SHAREPOINT2007 server).
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRV4vIstgRgkR9rxSWPfE4M3-RQPlfaRfOynt4pgQga1bazAZF1rLGGIbNZX0Id2hDD2NhHoPbdo_GjNSXos6tfUtTrxZQpdDasHSDwuSQRH1-lcdsflcYSYwZsymf3zmS-9Eo7L2_4Fd_/s1600-h/SSRS2008MultipleServersInstall_28_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard.JPG">id=BLOGGER_PHOTO_ID_5311368074982348338
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 270px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRV4vIstgRgkR9rxSWPfE4M3-RQPlfaRfOynt4pgQga1bazAZF1rLGGIbNZX0Id2hDD2NhHoPbdo_GjNSXos6tfUtTrxZQpdDasHSDwuSQRH1-lcdsflcYSYwZsymf3zmS-9Eo7L2_4Fd_/s320/SSRS2008MultipleServersInstall_28_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard.JPG"
border=0>
Click "Next". On the "Connect to a Server farm" dialog
select "Yes I want to connect to an existing Farm".
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl5Xr6ejoY7ke43W5v4JGmKDkVZ9O_HVoOV8sCUGYcF5HGPaK4Beb_vrCuTsO7DMBDuhnTv4tnX0IsTI8nXJnmM9C9kDGG9f8vZwmhNX1mdmJmm6ks3QSbYhEpLW8w6DlvhWt_anb383mT/s1600-h/SSRS2008MultipleServersInstall_29_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard2.JPG">id=BLOGGER_PHOTO_ID_5311368080390174082
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 274px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl5Xr6ejoY7ke43W5v4JGmKDkVZ9O_HVoOV8sCUGYcF5HGPaK4Beb_vrCuTsO7DMBDuhnTv4tnX0IsTI8nXJnmM9C9kDGG9f8vZwmhNX1mdmJmm6ks3QSbYhEpLW8w6DlvhWt_anb383mT/s320/SSRS2008MultipleServersInstall_29_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard2.JPG"
border=0>
Click "Next". On the "Specify Configuration Database
Settings" type "SQL2008" for the databases server name, then click "Retrieve
Database Names" button.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4Eg4jLHlDaag1FDaYPDQccjfS-5rb5NlPqpOmC_NUW5zJGV-w7eTHChvZUanUWA3Tc7a5-v9tHs-e3VkNBWr8TGAS0ISI4hgi24PX0KZkJrmNmEVWB7QrWUSfhmL9csiiy5h7BJT6fY_9/s1600-h/SSRS2008MultipleServersInstall_30_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard3.JPG">id=BLOGGER_PHOTO_ID_5311369360052657314
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 274px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4Eg4jLHlDaag1FDaYPDQccjfS-5rb5NlPqpOmC_NUW5zJGV-w7eTHChvZUanUWA3Tc7a5-v9tHs-e3VkNBWr8TGAS0ISI4hgi24PX0KZkJrmNmEVWB7QrWUSfhmL9csiiy5h7BJT6fY_9/s320/SSRS2008MultipleServersInstall_30_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard3.JPG"
border=0>
The wizard retrieves not only the SharePoint Configuration
database, but also the Farm Service Account...
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeG3JQx-rV-kLUjtWgvjRn51mYYFTBNvrMvxN_6SBIpI3c4Wpb_P_ajR0sadFghTW_TCDxdX6jWeYWTQQlgC6W-H6aDcgKLAnk6tatrsx56dY-4spCaCdUfqJeYRIgtRFxagD5Tzn1wVLf/s1600-h/SSRS2008MultipleServersInstall_31_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard4.JPG">id=BLOGGER_PHOTO_ID_5311369363789003618
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 272px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeG3JQx-rV-kLUjtWgvjRn51mYYFTBNvrMvxN_6SBIpI3c4Wpb_P_ajR0sadFghTW_TCDxdX6jWeYWTQQlgC6W-H6aDcgKLAnk6tatrsx56dY-4spCaCdUfqJeYRIgtRFxagD5Tzn1wVLf/s320/SSRS2008MultipleServersInstall_31_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard4.JPG"
border=0>
...so you just have the password to type.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiLlopVYfj9sysBwvWWCLrgOWKdy48g0RZhznuFQx8R4xgNNw6vc44TxGbGFqZVwYqweQwGzKDzO_NEOCmyg04hJelBzQBSr_n8Yc9Pu2pkOc6jpd-uq7MtGFFpHYIuk_lM5jx8VLvxfd6/s1600-h/SSRS2008MultipleServersInstall_32_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard5.JPG">id=BLOGGER_PHOTO_ID_5311369361035242434
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 273px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiLlopVYfj9sysBwvWWCLrgOWKdy48g0RZhznuFQx8R4xgNNw6vc44TxGbGFqZVwYqweQwGzKDzO_NEOCmyg04hJelBzQBSr_n8Yc9Pu2pkOc6jpd-uq7MtGFFpHYIuk_lM5jx8VLvxfd6/s320/SSRS2008MultipleServersInstall_32_SharePoint2007InstallationOnSSRS2008-Run+SPPT+Wizard5.JPG"
border=0>
Click "next" to launch configuration and wait until the
"Configuration Successful" dialog.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaafyiTDW_LYNMY9s3Qhn93TAePigQUttEa-QLkq_qIA0ERHKzvJwYFLopk8R_6OJVQFpMY_em389-KYhpq0JygRJ7L4-ZCye90-nsBOMpBmSSEDibDWVCiJsfbWRv5xlik-vt1Qzdyn43/s1600-h/SSRS2008MultipleServersInstall_33_SharePoint2007InstallationOnSSRS2008-SPS2007+Minimal+Install+done.JPG">id=BLOGGER_PHOTO_ID_5311369368117006802
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 273px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaafyiTDW_LYNMY9s3Qhn93TAePigQUttEa-QLkq_qIA0ERHKzvJwYFLopk8R_6OJVQFpMY_em389-KYhpq0JygRJ7L4-ZCye90-nsBOMpBmSSEDibDWVCiJsfbWRv5xlik-vt1Qzdyn43/s320/SSRS2008MultipleServersInstall_33_SharePoint2007InstallationOnSSRS2008-SPS2007+Minimal+Install+done.JPG"
border=0>
As usual, when you close this Dialog, SharePoint Central
Administration Web Site Home Page Appears.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJA_7jEVmIGX00o_bWar3ySmiurWSHXITsmcAEiJds2BayjCy-VRrWQprHDcjsaC9K2bktLRBRyGEixGHLlGEq6c3HP8kUpEEQJPl_n9eP5yW_QjX28A3QSnK7KE5fa6MmRHYwyTl69Ed0/s1600-h/SSRS2008MultipleServersInstall_34_SharePoint2007InstallationOnSSRS2008-SPS2007+Central+Admin+home+page.JPG">id=BLOGGER_PHOTO_ID_5311369371302750322
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 239px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJA_7jEVmIGX00o_bWar3ySmiurWSHXITsmcAEiJds2BayjCy-VRrWQprHDcjsaC9K2bktLRBRyGEixGHLlGEq6c3HP8kUpEEQJPl_n9eP5yW_QjX28A3QSnK7KE5fa6MmRHYwyTl69Ed0/s320/SSRS2008MultipleServersInstall_34_SharePoint2007InstallationOnSSRS2008-SPS2007+Central+Admin+home+page.JPG"
border=0>
02 - Check
SharePoint installation on SSRS2008SPIM
Take advantage of this page to check that SSRS2008SPIM server has now
joined the SharePoint Farm.
Click Operation Tab, then servers in farm link.
You can see the presence of the computer as a new Server of the SharePoint Farm.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2xD9oP3L2wr3ol8tSETXHu1kUw3kVpgiFhESMh6gAGr9Qat8aYTdjjE5bk6v-pyUD1Q5tBZjY33uVw0yw5toyQ3MdGBes3g7Nf_UlKvi8ifOBVbm5Q2JogcG8dyF1o50z3IlMD4CBCldz/s1600-h/SSRS2008MultipleServersInstall_35_01SharePoint2007InstallationOnSSRS2008-SPS2007+Central+Admin+Server+in+Farm.JPG">id=BLOGGER_PHOTO_ID_5311370994132400082
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2xD9oP3L2wr3ol8tSETXHu1kUw3kVpgiFhESMh6gAGr9Qat8aYTdjjE5bk6v-pyUD1Q5tBZjY33uVw0yw5toyQ3MdGBes3g7Nf_UlKvi8ifOBVbm5Q2JogcG8dyF1o50z3IlMD4CBCldz/s320/SSRS2008MultipleServersInstall_35_01SharePoint2007InstallationOnSSRS2008-SPS2007+Central+Admin+Server+in+Farm.JPG"
border=0>
There is another thing you can notice since SSRS2008SPIM
is a Web Front End. Open IIS and Notice that a "SharePoint - 81" Web Application
in now available. Right click the Web Application node in IIS and click
"Browse".
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK4s6ov1gLTFaJ_sJ5oPFSIylyEG8btyfnoPsC41d9E4-iqlfMsww1eks6t9wat4WD_uLctlztgCwjv_bso3yG4_DXiSJxsU5_A4Td499x4QqDyL0A6V0-Yg4rWDmQrn1d1f-nXW5RtPQZ/s1600-h/SSRS2008MultipleServersInstall_35_02SharePoint2007InstallationOnSSRS2008-SPS2007+Browse+81+Web+App.JPG">id=BLOGGER_PHOTO_ID_5311370997365772322
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 194px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK4s6ov1gLTFaJ_sJ5oPFSIylyEG8btyfnoPsC41d9E4-iqlfMsww1eks6t9wat4WD_uLctlztgCwjv_bso3yG4_DXiSJxsU5_A4Td499x4QqDyL0A6V0-Yg4rWDmQrn1d1f-nXW5RtPQZ/s320/SSRS2008MultipleServersInstall_35_02SharePoint2007InstallationOnSSRS2008-SPS2007+Browse+81+Web+App.JPG"
border=0>
The testReportingServices Site Collection Root Web Site
will be served by the SSRS2008SPIM computer as it is become a new Web Front End
of a SharePoint Farm.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE28LcrJ50RXrKDHsdSI2OkIGPgDwlTMNjvBv2X-vXIO-t3pp4xfjmBt-hAvO6yfpwquA0D1Y6TMwYdpAtLhaQu2Fc8S2B2_h_uQV1rsssJNRjpnyUpHn0KOwHKQoKx2Pks4kYl_boD-Zd/s1600-h/SSRS2008MultipleServersInstall_35_03SharePoint2007InstallationOnSSRS2008-SPS2007+81+Web+App+working.JPG">id=BLOGGER_PHOTO_ID_5311371005594271490
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 194px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE28LcrJ50RXrKDHsdSI2OkIGPgDwlTMNjvBv2X-vXIO-t3pp4xfjmBt-hAvO6yfpwquA0D1Y6TMwYdpAtLhaQu2Fc8S2B2_h_uQV1rsssJNRjpnyUpHn0KOwHKQoKx2Pks4kYl_boD-Zd/s320/SSRS2008MultipleServersInstall_35_03SharePoint2007InstallationOnSSRS2008-SPS2007+81+Web+App+working.JPG"
border=0>
3.5 - name=Step-5:-Configuration-and-test-of-the-Report-Server-on-SSRS2008SPIM>Step
5: Configuration and test of the Report Server on SSRS2008SPIM
I could 5: Configuration and test of the Report Server on SSRS2008SPIM
keep using SharePoint Setup account (SPS_SETUP) to configure report server, but
configuring Report Server with Reporting Services account will allow me to check
the Report Server Web Service before having installed Reporting Services Add In
for SharePoint on the SharePoint computer, and before having configured
SharePoint for Reporting Services.
(If you prefer to keep using SharePoint Setup account
(SPS_SETUP) to configure report server do not forget to Logon to SQL2008 and
grant the sysadmin permissions to SPS_SETUP since it has not enough permissions
to configure the Report Server Databases.)
01 - name=Preparing-SSRS_SERVICE-account-to-configure-Reporting-Services->Preparing
SSRS_SERVICE account to configure Reporting Services
SSRS_SERVICE account to configure Reporting Services
Add SSRS_SERVICE to the Administrators Group of the Report
Server computer (SSRS2008SPIM). To use Report Server Configuration Manager you
must be logged as an Administrator.
with SSRS-SERVICE.
Logon to SQL2008 and grant temporary the sysadmin
permissions to SSRS_SERVICE
Open Report Server Configuration Manager and
connect to the default instance of the current server
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb9NZtEgkmU62XOG6wxL89noLTq0_E83BqeMzdN2uQrJZeAihQ1UDFg9jckV3ThE9b0_LK8E61C5J3GqnUerBTkr59jccfPTd3qY3fEEUhcnzNcfhayyf20hf1ahxfE0EXiTxHvzk2fUdr/s1600-h/SSRS2008MultipleServersInstall_36_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Connect.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 190px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb9NZtEgkmU62XOG6wxL89noLTq0_E83BqeMzdN2uQrJZeAihQ1UDFg9jckV3ThE9b0_LK8E61C5J3GqnUerBTkr59jccfPTd3qY3fEEUhcnzNcfhayyf20hf1ahxfE0EXiTxHvzk2fUdr/s320/SSRS2008MultipleServersInstall_36_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Connect.JPG"
border=0>
On the left menu click database, then, on opening dialog,
click change database to open the change database dialog.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTA-806f_JWXxztowmu63z4RXyVQj5mKTmBR__3cTf1PgCgqKLQidXHVT4HKqXzRTWkFCAA1Rq9Yagb5lywy2jRdf-xCmOruG9XAp8XdF0rAY9sIdQFfgkrNhaJm_vX-iQ3_XRUAd9ozQ7/s1600-h/SSRS2008MultipleServersInstall_37_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB1.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 230px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTA-806f_JWXxztowmu63z4RXyVQj5mKTmBR__3cTf1PgCgqKLQidXHVT4HKqXzRTWkFCAA1Rq9Yagb5lywy2jRdf-xCmOruG9XAp8XdF0rAY9sIdQFfgkrNhaJm_vX-iQ3_XRUAd9ozQ7/s320/SSRS2008MultipleServersInstall_37_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB1.JPG"
border=0>
Select "create a new report Server Database", then click
"Next".
On database server dialog notice that the SQL 2008 Server
Computer has been retrieved, and that the account is SSRS_SERVICE.
Do not
forget to test database connection.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8WOr8m7zPd9A2tTp64cNIfmzGjPeKQZaIa2TAlOAGzg6UKy3yNXRzGUsSuCiIcIe-LJMhP46RE9wifroyNajflZv8baoPO7LsCChOSH-kFLO-9TUdZ3v05aeNX2zoU3NcMDjhBK7KnQRl/s1600-h/SSRS2008MultipleServersInstall_38_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Settings1.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 231px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8WOr8m7zPd9A2tTp64cNIfmzGjPeKQZaIa2TAlOAGzg6UKy3yNXRzGUsSuCiIcIe-LJMhP46RE9wifroyNajflZv8baoPO7LsCChOSH-kFLO-9TUdZ3v05aeNX2zoU3NcMDjhBK7KnQRl/s320/SSRS2008MultipleServersInstall_38_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Settings1.JPG"
border=0>
On the next dialog select SharePoint Integrated mode.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzSwVUjsnrvek8R30ow8Z-cHnXeBT9G9hj9qMZNmC-uUmCNzvUWC7rM6GpI60q-In4AafQ5RscyLnM0SwdKTrcAdqIcw6vTCjWf7agzqhgj5WmoQ3MuucWQNJQFsgK7Sp6NF8d64_F_rE7/s1600-h/SSRS2008MultipleServersInstall_39_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Settings2.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 230px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzSwVUjsnrvek8R30ow8Z-cHnXeBT9G9hj9qMZNmC-uUmCNzvUWC7rM6GpI60q-In4AafQ5RscyLnM0SwdKTrcAdqIcw6vTCjWf7agzqhgj5WmoQ3MuucWQNJQFsgK7Sp6NF8d64_F_rE7/s320/SSRS2008MultipleServersInstall_39_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Settings2.JPG"
border=0>
On the next dialog select windows credential and type
again SSRS_SERVICE
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqZqVkAwhyVpWxoGFgjWzr4e46UzBe13W2cqkKHnzpjKv4JI3VddLF-CcEf7MWc2s-Re1_rBwnRtaceLPn9XVmbQZI66iaA2iGxOU3cAwNZAXgla70z_XMf2eLYnP5grKY8BJCgiKFEYWG/s1600-h/SSRS2008MultipleServersInstall_40_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Settings3.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 230px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqZqVkAwhyVpWxoGFgjWzr4e46UzBe13W2cqkKHnzpjKv4JI3VddLF-CcEf7MWc2s-Re1_rBwnRtaceLPn9XVmbQZI66iaA2iGxOU3cAwNZAXgla70z_XMf2eLYnP5grKY8BJCgiKFEYWG/s320/SSRS2008MultipleServersInstall_40_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Settings3.JPG"
border=0>
Check the summary and launch database creation
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8rCjRNi-amFd5ZzsFhdheZTqD7EzECtfobF0h123qtwKG_okH5J3tD98nmnjYI7g4weaRu4rwjSNaQdGi7pKOm70EbpZum4DtMkUQhWVuAz2sMxTwucTnN4pMmqufm_yanf4crKQZVYSI/s1600-h/SSRS2008MultipleServersInstall_41_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Settings4.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 230px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8rCjRNi-amFd5ZzsFhdheZTqD7EzECtfobF0h123qtwKG_okH5J3tD98nmnjYI7g4weaRu4rwjSNaQdGi7pKOm70EbpZum4DtMkUQhWVuAz2sMxTwucTnN4pMmqufm_yanf4crKQZVYSI/s320/SSRS2008MultipleServersInstall_41_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Settings4.JPG"
border=0>
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGN9GBfCAsfNYAla2UTQzKASrUuvYxRLQWjWD0Z2rD2BWi8oCNqLAnMId7-VxFH1r8G8rWu0Bg2pL5jwuHGFTsHNhN0708jqNHU8QLX74qJYJ4lP9tJIhIHeiMbw3HI8lDtQcHem7JsqwT/s1600-h/SSRS2008MultipleServersInstall_42_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Complete.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 230px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGN9GBfCAsfNYAla2UTQzKASrUuvYxRLQWjWD0Z2rD2BWi8oCNqLAnMId7-VxFH1r8G8rWu0Bg2pL5jwuHGFTsHNhN0708jqNHU8QLX74qJYJ4lP9tJIhIHeiMbw3HI8lDtQcHem7JsqwT/s320/SSRS2008MultipleServersInstall_42_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+Create+SSRS+DB+Complete.JPG"
border=0>
On the left menu of the report server Configuration Manager, this
time click Web Service URL
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjom3UOvRHMLPSa0fGaO9ZarfdOmeWQ-YZUAO4RW5bWbgXkQ59ancj2S9wTKAtSWo84IWSkLGoxflo2xzHg9nRcWIcHxCcSihnXfrEAS6JLQW2tNUWTmhOlv6lL-gFYfOqtrmoLMAUHrFVa/s1600-h/SSRS2008MultipleServersInstall_43_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+URL+Settings.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 201px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjom3UOvRHMLPSa0fGaO9ZarfdOmeWQ-YZUAO4RW5bWbgXkQ59ancj2S9wTKAtSWo84IWSkLGoxflo2xzHg9nRcWIcHxCcSihnXfrEAS6JLQW2tNUWTmhOlv6lL-gFYfOqtrmoLMAUHrFVa/s320/SSRS2008MultipleServersInstall_43_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+URL+Settings.JPG"
border=0>
Click Apply to provisioning the Web Service.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivptqvQK9rSPUoyWA0Jr_2PGz2tJkriM9BR-cT7zT-nOz-iqTTgvMZhfeULkGfZKdyT8ik6Bi62oMjQq-0XiK4bDssJqpziQdVJXSU8SNlbDNI5mP-HwjvI7Q_Cac_zjVHZxAxr9riuJqq/s1600-h/SSRS2008MultipleServersInstall_44_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+URL+Settings+done.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 242px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivptqvQK9rSPUoyWA0Jr_2PGz2tJkriM9BR-cT7zT-nOz-iqTTgvMZhfeULkGfZKdyT8ik6Bi62oMjQq-0XiK4bDssJqpziQdVJXSU8SNlbDNI5mP-HwjvI7Q_Cac_zjVHZxAxr9riuJqq/s320/SSRS2008MultipleServersInstall_44_SharePoint2007InstallationOnSSRS2008-SPS2007+SSRS+Config+Manager+URL+Settings+done.JPG"
border=0>
Click the URL to check the Web service. Notice that no
mention of SharePoint is visible for the moment.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh50LE_tyW2GVrtFdktOGb0-CmA0H7Z07IebXmfERmYePUjwMYGzmXn57xF5ihLJ1YgO5gPDl99F9shzzAhtS4tFAt_imcCUP1UGctmr6M1as4r5K4RL0gqexefFYF_AF_yWl-6gbtUdqPU/s1600-h/SSRS2008MultipleServersInstall_45_SharePoint2007InstallationOnSSRS2008-SPS2007+01Report+Server+Web+Site+Checking.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh50LE_tyW2GVrtFdktOGb0-CmA0H7Z07IebXmfERmYePUjwMYGzmXn57xF5ihLJ1YgO5gPDl99F9shzzAhtS4tFAt_imcCUP1UGctmr6M1as4r5K4RL0gqexefFYF_AF_yWl-6gbtUdqPU/s320/SSRS2008MultipleServersInstall_45_SharePoint2007InstallationOnSSRS2008-SPS2007+01Report+Server+Web+Site+Checking.JPG"
border=0>
Logon to SQL2008 and remove the sysadmin permissions to
SSRS_SERVICE
connection requires now the configuration in SharePoint. But we will not be able
to perform it before having installed SSRS Add In for SharePoint on
SHAREPOINT2007 computer.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZDwclLyPer3_EhkTUYToK49bb5tRcYNkcU3v-gAYJBX1Innh7T7EYyJK-qoe-kcLwO0HskDxIhwU0_PoMSsfNNWAz-I8SbsYhv32-uRRmopoECPFeeJYTsFc1sk8eh-UkZcljTECEswHW/s1600-h/SSRS2008MultipleServersInstall_45_SharePoint2007InstallationOnSSRS2008-SPS2007+Report+Server+Web+Site+Checking+NoMore+SysAdmin.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 138px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZDwclLyPer3_EhkTUYToK49bb5tRcYNkcU3v-gAYJBX1Innh7T7EYyJK-qoe-kcLwO0HskDxIhwU0_PoMSsfNNWAz-I8SbsYhv32-uRRmopoECPFeeJYTsFc1sk8eh-UkZcljTECEswHW/s320/SSRS2008MultipleServersInstall_45_SharePoint2007InstallationOnSSRS2008-SPS2007+Report+Server+Web+Site+Checking+NoMore+SysAdmin.JPG"
border=0>
Remove SSRS_SERVICE from the Administrators Group of the
Report Server computer (SSRS2008SPIM)
3.6 - name=Step-6:-Installation-of-SQL-Server-Reporting-Services-2008-Add-In>Step
6: Installation of SQL Server Reporting Services 2008 Add In for SharePoint on
SHAREPOINT2007, Configuration and Check.
6: Installation of SQL Server Reporting Services 2008 Add In for SharePoint on
SHAREPOINT2007, Configuration and Check.
01 - name=Installation-of-SQL-Server-Reporting-Services-2008-Add-In>Installation
of SQL Server Reporting Services 2008 Add In for SharePoint on SHAREPOINT2007
of SQL Server Reporting Services 2008 Add In for SharePoint on SHAREPOINT2007
Logon to SQL2008 and grant the sysadmin permissions to
SPS_SETUP
Logon to SHAREPOINT2007 and grant the Administrator
permissions to SPS_FARM
In for SharePoint 2007 installation as shown in my previous post:
href="http://mosshowto.blogspot.com/2009/01/integrating-ssrs-2008-sharepoint-2007.html">Integrating
Reporting Services 2008 with SharePoint 2008 Step 4 - Configuring Reporting
Services for SharePoint 3.0 Integration - Part 2: Operations performed in
SharePoint Central Administration.
Step 1 to 8.
When it is done,
go to SharePoint central Administration, Application Management Tab, and locate
Reporting Services section.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLHrCawvEq4V6FauCzaC-E1XoYbfnhuDKd_x0fVTNqOHI9qaupT62c63Y2NEM1qDQ1FdamuOszUROUq8OQBGgMFIZZmMBAf9Iq0QiPfNpE3vJtl8qcKpvrz178CMnsNyFFhQtyIMbMBICa/s1600-h/SSRS2008MultipleServersInstall_46_SSRSAdInForSPSInstallationOnSharePoint-Operations+Reporting+Services.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 158px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLHrCawvEq4V6FauCzaC-E1XoYbfnhuDKd_x0fVTNqOHI9qaupT62c63Y2NEM1qDQ1FdamuOszUROUq8OQBGgMFIZZmMBAf9Iq0QiPfNpE3vJtl8qcKpvrz178CMnsNyFFhQtyIMbMBICa/s320/SSRS2008MultipleServersInstall_46_SSRSAdInForSPSInstallationOnSharePoint-Operations+Reporting+Services.JPG"
border=0>
02 - name=Configuration-of-reporting-services-in-SharePoint-Central-Administration>Configuration
of reporting services in SharePoint Central Administration
Open "Manage of reporting services in SharePoint Central Administration
Integration Setting" Page and type the report Server URL.
For the
"Authentication Mode" Section select "Trusted Account" that is the right mode
for the present configuration in multiple servers with NTLM.
For more
information there is a good post of Reza Alirezaei:
href="http://blogs.devhorizon.com/reza/?p=729">SSRS 2008 integrated mode:
security
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAeodfgxnp24AFUzx3x22fDfxcc5LMn8UIs1LjmXbvOnQO_qNpFRNT2wTybM1VdHmKce7DWv4KLe_rbwOpMBnRcFbmf1cEyH89aZOVyaWLk3v5qPFkjQ55D0UNfbbRqs0ApHzAwjNv4-jM/s1600-h/SSRS2008MultipleServersInstall_49_SSRSConfigOnSharePoint2007-ReportingServicesIntegration.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 138px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAeodfgxnp24AFUzx3x22fDfxcc5LMn8UIs1LjmXbvOnQO_qNpFRNT2wTybM1VdHmKce7DWv4KLe_rbwOpMBnRcFbmf1cEyH89aZOVyaWLk3v5qPFkjQ55D0UNfbbRqs0ApHzAwjNv4-jM/s320/SSRS2008MultipleServersInstall_49_SSRSConfigOnSharePoint2007-ReportingServicesIntegration.JPG"
border=0>
Open the Grant Database Access Page, and type the Report
Server Computer name.
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXIia7r2OvwryF9X8AWHr9bcQb-NbOiRG6S-4RBeyIOCCrXcHkkY6JgkEMr1eLOEQ3tGdWwNMQHyTpsWwjgKF9FJq5q3kHqwga6yD249wxEGfg2GU601Z-bqStSA7HE2_bNo-gPgQcQQE_/s1600-h/SSRS2008MultipleServersInstall_47_SSRSConfigOnSharePoint2007-GrantDataBaseAccess.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 214px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXIia7r2OvwryF9X8AWHr9bcQb-NbOiRG6S-4RBeyIOCCrXcHkkY6JgkEMr1eLOEQ3tGdWwNMQHyTpsWwjgKF9FJq5q3kHqwga6yD249wxEGfg2GU601Z-bqStSA7HE2_bNo-gPgQcQQE_/s320/SSRS2008MultipleServersInstall_47_SSRSConfigOnSharePoint2007-GrantDataBaseAccess.JPG"
border=0>
Click OK.
In the Enter Credentials dialog box, specify the User Name and Password to connect to the report server to retrieve the service account information. Be sure to enter credentials for an account that is a member of the local Administrators group on the report server computer.
In our case, SPS_SETUP has the required permissions to perform this task.
When the page is refreshed, you can open a browser window
and type the url of the report Server Web Service:
http://ssrs2008spim/reportserver
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEBiFG5SJDs3VEpVJRCR7lBKhlshhlU5VB8D4kLQKJNuHg6a0PurvyL4dIIuplOBls2ITAr0pAvG-cNbDYkcxLhL_5jwkShkW1aEYOhoOVVtJGiGqkguC0HyBDB24TZVShPTFzh2jdw4Kj/s1600-h/SSRS2008MultipleServersInstall_50_SSRSConfigOnSharePoint2007-Check+Report+Server+Web+Service.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 154px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEBiFG5SJDs3VEpVJRCR7lBKhlshhlU5VB8D4kLQKJNuHg6a0PurvyL4dIIuplOBls2ITAr0pAvG-cNbDYkcxLhL_5jwkShkW1aEYOhoOVVtJGiGqkguC0HyBDB24TZVShPTFzh2jdw4Kj/s320/SSRS2008MultipleServersInstall_50_SSRSConfigOnSharePoint2007-Check+Report+Server+Web+Service.JPG"
border=0>
Notice that you are now connected to the SharePoint Sites
and Libraries. Your Installation is done!
Don't forget to:
Logon to SQL2008 and remove the sysadmin permissions to
SPS_SETUP
Logon to SHAREPOINT2007 and remove SPS_FARM from the
Administrators group.
3.7 - name=Step-7:-BIDS-installation,-Report-creation,-deployment-and-test->Step
7: BIDS installation, Report creation, deployment and test
7: BIDS installation, Report creation, deployment and test
I
have chosen to install BIDS on SSRS2008SPIM computer to be as close as possible
to a real Production Environment where BIDS will not be installed on the
SharePoint machine.
Doing that, I will be sure to succeed in deploying
report remotely using the current environment.
Logon to SSRS2008SPIM
with SPS_SETUP account. Run the SQL Server installation package, and select "Add
a feature to the current installation". Select Visual Studio and wait until
installation process is complete.
Open
BIDS.
Create a report (if needed install Adventure Works as a sample
Database).
You can do my previous tutorial:
href="http://mosshowto.blogspot.com/2009/02/reporting-services-2008-report.html">Integrating
reporting Services 2008 with SharePoint 2007 Step 6 - Report Creation and
Deployment
For the project properties, type the following:
- TargetDataSourceFolder: http://SHAREPOINT2007:81/shared documents
- TargetReportFolder: http://SHAREPOINT2007:81/shared documents
- TargetServerURL: http://SHAREPOINT2007:81/
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA_VVAnKRgFoGW5Sp9KthoSknCs3gsNFjPq0KQerDpcISUDoCvEMhnmsWa1T54jnOCA84PPgsaCq0o3yOwxOthmoE_mO33bZXf-rhlz2CCyzfkOLvJrnl8B1sR60RPbGnpWpPzKOR0Svkj/s1600-h/SSRS2008MultipleServersInstall_51_BIDSReportDeployment-ProjectProperties.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 210px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA_VVAnKRgFoGW5Sp9KthoSknCs3gsNFjPq0KQerDpcISUDoCvEMhnmsWa1T54jnOCA84PPgsaCq0o3yOwxOthmoE_mO33bZXf-rhlz2CCyzfkOLvJrnl8B1sR60RPbGnpWpPzKOR0Svkj/s320/SSRS2008MultipleServersInstall_51_BIDSReportDeployment-ProjectProperties.JPG"
border=0>
Perform deployment with BIDS.
If you try to see the deployed report
now, you will have a credential exception. You will be able to see the type of
this exception only on the report Server machine: SSRS2008SPIM.
The
error type will only be displayed on the Report Server Web Service when you are
logged on to SSRS2008SPIM. And Reporting Services errors can be examined. This
is the path of the Log Files of SQL Server 2008 Reporting Services:
c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting
Services\LogFiles
To solve this error logon to SHAREPOINT2007.
Go
to the Shared Documents documents library of the TestReportingServices Web Site,
and locate the file Report1.rdl (that has not its extension visible).
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiuADZQZY0E_QMSgc3nbEOT1zFPgOR65Onhe60AulgCQcgRQNlPDJH2fMBHVBKnDX0S8ALlQXHMcggx_rWCVVb-W3VWI5Cuvdt-Yjg0-Tcmq_knYbdL8OOtT7PDKtBLkk2WRpgETQgwGvt/s1600-h/SSRS2008MultipleServersInstall_52_BIDSReportDeployment-ReportDataSourceConfiguration1.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 232px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiuADZQZY0E_QMSgc3nbEOT1zFPgOR65Onhe60AulgCQcgRQNlPDJH2fMBHVBKnDX0S8ALlQXHMcggx_rWCVVb-W3VWI5Cuvdt-Yjg0-Tcmq_knYbdL8OOtT7PDKtBLkk2WRpgETQgwGvt/s320/SSRS2008MultipleServersInstall_52_BIDSReportDeployment-ReportDataSourceConfiguration1.JPG"
border=0>
Expand the Report contextual menu and select "Manage Data
Sources".
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-05zV9yU3Drj37-ZvSvODOfrPcsFWHCTY-2XqNmwbShv3fQTXRJCo_KVppVqmAep2NTmr9h9jpfTQwJTF_HGMKFtfF8pwu1AHOpjlwQ4VEjQDsGe2YIXSvfn2ujEPfBJvsbWJXzeRJ2D-/s1600-h/SSRS2008MultipleServersInstall_53_BIDSReportDeployment-ReportDataSourceConfiguration2.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 187px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-05zV9yU3Drj37-ZvSvODOfrPcsFWHCTY-2XqNmwbShv3fQTXRJCo_KVppVqmAep2NTmr9h9jpfTQwJTF_HGMKFtfF8pwu1AHOpjlwQ4VEjQDsGe2YIXSvfn2ujEPfBJvsbWJXzeRJ2D-/s320/SSRS2008MultipleServersInstall_53_BIDSReportDeployment-ReportDataSourceConfiguration2.JPG"
border=0>
The Manage Data Sources Page is displaying
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibxGjVfQ7NyBnUypHTdGGy-C0MKLaUkM91STX2cySdno9CQCUoOKdaGdWwiu0UkZmMDFZ0mdP4ZPAvy-L2ZJgWot8X1WVDLYKz-v0xFq5VsjyyN-MgygUsAOm70CdJXqncLSqsSEaQqiBt/s1600-h/SSRS2008MultipleServersInstall_54_BIDSReportDeployment-ReportDataSourceConfiguration3.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 207px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibxGjVfQ7NyBnUypHTdGGy-C0MKLaUkM91STX2cySdno9CQCUoOKdaGdWwiu0UkZmMDFZ0mdP4ZPAvy-L2ZJgWot8X1WVDLYKz-v0xFq5VsjyyN-MgygUsAOm70CdJXqncLSqsSEaQqiBt/s320/SSRS2008MultipleServersInstall_54_BIDSReportDeployment-ReportDataSourceConfiguration3.JPG"
border=0>
Click the Datasource1 link to open the edit the data
source connection information.
Select "Stored Credentials"
Use an
account that have read permissions on the databse used for this report. For
example in my case, I used the SSRS service account credentials, that will be
quite never done in real life.
Check the check box: "Use as Windows
Credentials".
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOCcB0NbhR5zebKgAIfy7e8sBPC-vOrAFnTxXjsb2iqn76QaPXLPNHCtONuYOvfiYmR3w0VNiTCKquSsC8Sti0xwj5OTA_giABwjvH3VgMouWiVEAE6oYzPYQD3CBtKYWo-cvngOGyM9ux/s1600-h/SSRS2008MultipleServersInstall_55_BIDSReportDeployment-ReportDataSourceConfiguration4JPG.JPG">
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 229px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOCcB0NbhR5zebKgAIfy7e8sBPC-vOrAFnTxXjsb2iqn76QaPXLPNHCtONuYOvfiYmR3w0VNiTCKquSsC8Sti0xwj5OTA_giABwjvH3VgMouWiVEAE6oYzPYQD3CBtKYWo-cvngOGyM9ux/s320/SSRS2008MultipleServersInstall_55_BIDSReportDeployment-ReportDataSourceConfiguration4JPG.JPG"
border=0>
You
can now display your report in:
- RSViewerPage.aspx
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo6qLSV9620TguyZq7uzsVThEM3suG-sa-1enNvceWLHxKu7BNfHejewjLe4S87WOBRD3WpqF-bjE1zA-_B2GtRIwgkjA9N-S_GN3eNkxsT3u8scgqmgwH3lv4vjQEx5Vfp9weiziL7C0G/s1600-h/SSRS2008MultipleServersInstall_56_BIDSReportDispaying-RSViewerPage.JPG">id=BLOGGER_PHOTO_ID_5311381614653255634
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 269px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo6qLSV9620TguyZq7uzsVThEM3suG-sa-1enNvceWLHxKu7BNfHejewjLe4S87WOBRD3WpqF-bjE1zA-_B2GtRIwgkjA9N-S_GN3eNkxsT3u8scgqmgwH3lv4vjQEx5Vfp9weiziL7C0G/s320/SSRS2008MultipleServersInstall_56_BIDSReportDispaying-RSViewerPage.JPG"
border=0>
- Report Viewer Web Part
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgb5_oU3fyODNjzjf1k0gAOAJ0fTPXBxbyw9YOYgYDYXONaUQ_gF-vjQ9hyphenhyphend74Vk3FwLoeNkODzM-baYxU4eQCBKvgqtk6yxqePAHPfv79ajOe5UuZzkTHF8k8EC1lvWsHwq0Sw4ErziGqm/s1600-h/SSRS2008MultipleServersInstall_57_BIDSReportDispaying-ReportViewerWebPart.JPG">id=BLOGGER_PHOTO_ID_5311381621173180450
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 182px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgb5_oU3fyODNjzjf1k0gAOAJ0fTPXBxbyw9YOYgYDYXONaUQ_gF-vjQ9hyphenhyphend74Vk3FwLoeNkODzM-baYxU4eQCBKvgqtk6yxqePAHPfv79ajOe5UuZzkTHF8k8EC1lvWsHwq0Sw4ErziGqm/s320/SSRS2008MultipleServersInstall_57_BIDSReportDispaying-ReportViewerWebPart.JPG"
border=0>
- Report Server Web Service from the SHAREPOINT2007 computer
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEhXWzccuZ6GZRDtojqv5Qhvm0N6gFF1OBluVtzJ4fIFhS7dAu_3Rn8osVVi3pBobH4_AE6_tgp9Vtb_Rc6GBLCylcMu4_u_Uersc74mJDOZzYfOfcAOAOIoWXDIsp3H5AUSo5m1XreGO9/s1600-h/SSRS2008MultipleServersInstall_58_BIDSReportDispaying-ReportServerWebSite1.JPG">id=BLOGGER_PHOTO_ID_5311381626049354962
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 155px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEhXWzccuZ6GZRDtojqv5Qhvm0N6gFF1OBluVtzJ4fIFhS7dAu_3Rn8osVVi3pBobH4_AE6_tgp9Vtb_Rc6GBLCylcMu4_u_Uersc74mJDOZzYfOfcAOAOIoWXDIsp3H5AUSo5m1XreGO9/s320/SSRS2008MultipleServersInstall_58_BIDSReportDispaying-ReportServerWebSite1.JPG"
border=0>
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO_PLEjT0Z6BYg4FckJwt4jGfJ5HAkVph_vUjjMu6OVAbdGuTede1hwOAlfUJ0MhE75fuoL1KRZEMzZrih6c1WpPRtPtUfYeiff-IyhmxNcXVeSf4uabJA4ixyZooA_oAjQVnyLQSCUzdF/s1600-h/SSRS2008MultipleServersInstall_59_BIDSReportDispaying-ReportServerWebSite2.JPG">id=BLOGGER_PHOTO_ID_5311381624791392242
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 234px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO_PLEjT0Z6BYg4FckJwt4jGfJ5HAkVph_vUjjMu6OVAbdGuTede1hwOAlfUJ0MhE75fuoL1KRZEMzZrih6c1WpPRtPtUfYeiff-IyhmxNcXVeSf4uabJA4ixyZooA_oAjQVnyLQSCUzdF/s320/SSRS2008MultipleServersInstall_59_BIDSReportDispaying-ReportServerWebSite2.JPG"
border=0>
- Report Server Web Service from the SSRS2008SPIM computer
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg38k3FkR7lP3WHK2NfJi_8aiu95PKQsg2d72cHgKydm6FV67HUXOMBMx_HD9xw3Oz-GLocdOigNapA_Bvv_NGn4rTPcOf1qrpajveOCYBkKy_4z7D3ju67EdEvNrH7OPwa7jahdjGZeCAh/s1600-h/SSRS2008MultipleServersInstall_60_BIDSReportDispaying-ReportServerWebSite3.JPG">id=BLOGGER_PHOTO_ID_5311383849793084818
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 273px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg38k3FkR7lP3WHK2NfJi_8aiu95PKQsg2d72cHgKydm6FV67HUXOMBMx_HD9xw3Oz-GLocdOigNapA_Bvv_NGn4rTPcOf1qrpajveOCYBkKy_4z7D3ju67EdEvNrH7OPwa7jahdjGZeCAh/s320/SSRS2008MultipleServersInstall_60_BIDSReportDispaying-ReportServerWebSite3.JPG"
border=0>
A special thank you to Mahmoud Meflah for
his help regarding DataSource Configuration in SharePoint.
No comments:
Post a Comment