Configure Portfolio Server 2007 with Reporting services on distributed environment

  • Article

Installed two machines with Microsoft Windows Server 2003 R2, Enterprise Edition, Service Pack 2.

Added my domain (Domain\Sriram) account on both the machines as Administrator.

Logged in using that account & Installed everything using the same account.

All the application pools are in Network Service.

SRIR1877706: (SQL Server with Reporting Services)

· Configured IIS and Installed Framework 3.0

· Installed SQL Server 2005 Enterprise Edition 2005 with Database Engine, Analysis service and Reporting service.

· Installed Service Pack 3 for SQL server 2005

SRIR1877707: (Portfolio server)

· Configured IIS and Installed Framework 3.0

· Installed PPS with default Installation and selected SQL server as SRIR1877706.

· Selected only ‘web site’ and provided https://SRIR1877706/reportserver as report server URL.

· When I browse the PPS (https://SRIR1877707/portfolioserver, got the error : Login failed for user 'Domain\SRIR1877707$'.

· Open SQL Management Studio at SRIR1877706 and Provided Sys Admin permission to the account 'Domain\SRIR1877707$ .

· Able to browse the PPS without any issues.

Report Server Configuration Part:

· When I generate the report using https://SRIR1877707/portfolioserver, got the following error

The item '/Reports' cannot be found. More Info: https://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsItemNotFound&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.4035.00

· Installed PPS at SRIR1877706 and selected only Reporting Services Configuration

  • Provided the path for “Report server” , but portfolio component with default path

· Later When I tried to build the report, first error vanished, got the following error

The permissions granted to user 'DOMAIN\SRIR1877707$' are insufficient for performing this operation. More Info: https://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.4035.00

· Added DOMAIN\SRIR1877707$ in Server SRIR1877706 with administrator groups, the issue has been resolved. Able to generate the report without any issues.