BPC 7.0 Server Installation Problem - Cannot connect to reporting services

[Former Member]

I am upgrading from 5.1 to 7.0 version for SAP BPC. Everything went smooth on the development server (single instance installation including SQL Server 2005 developers edition 32bit, web, reporting and application services on the same server). I tried to repeat the same process on the test server, and the installation went off the rails. I started with clean installations of SQL Server 2005 on both servers.

When I try to install the BPC server software, I get to the point of access to the report server, and everything stops. I get the following message: Cannot connect to reporting services. I have verified the reporting server name, and I have verified that the server name is correct in the installation panel. I have also verified that the reporting server is configured, started, and that there are no errors.

Any advice?

[sorin_radulescu · Accepted solution]

Hi,

I think the installation of Reporting Services was done in your case with a named instance not with default instance.

When you provided the information regarding Reporting Srevices during the installation something was not specify correct:

- Name of instance

- Name of Report Server folder

Kind Regards

Sorin Radulescu

[Former Member · Accepted solution]

Hi Sorin,

Thanks for the tip, but this was not the case. The problem was solved by re-loading the OS. Using Windows Server 2003 gave an issue during the re-installation of the SQL Server database. The problem was in the installation itself. After a clean install of both the OS and SQL Server, then SAP BPC 7 worked. The installation does require a number of tweaks, particularly, in my case, the entire Management console must be configured, even if not being used.

This problem is now solved.

J.

[Former Member]

solved with re-install of the operating system.

[james_lim]

J,

Please check below things.

1. Service account

2. Run Report service configuration tool and verify everything is ok.

3. Authentication of report service.

Thank you.

James Lim.

[Former Member]

I have verified these. They are OK. Seems that there are issues with the OS (Windows Server 2003). The system is being re-installed. I will try again with a clean sweep.