Reporting Services server cannot connect

[Former Member]

Hi,

I am trying to install the SAP BPC MS version and so far been hit with many issues. The latest issue is that the installer cannot connect to the Reporting Services server, in which from the installation documentation this should come as standard with MSSQL.

Any idea how to activate this manually?

Thanks.

[Former Member]

Hi,

There is no such services listed. I've installed the SQL as per the installation CD.

[Former Member]

Hi,

In that case, I believe, the reporting service was not installed. When you are installing SQL server, you need to check the reporting services from the list. If thats not selected, then it wont be installed.

I guess, you have to run the installation once again. While doing the installation, please check the required services from the list, including reporting services.

Hope this helps.

[Former Member]

Hi,

I would like to know how the options can be selected? I am running the standard SQL4SAP script which is included in the installation DVD.

Thanks.

[Former Member]

Hi,

Instead of that I would suggest you to go to the appropriate folder (x86 or X64, etc) and run the setup.exe file.

Hope this helps.

[Former Member]

Which Reporting services are you referring to? I've checked and all SQL relevant services has been started.

[Former Member]

Hi,

Please go to administrative tools -> services. There, you should get a service called "SQL Server Reporting Services (MSSQLSERVER)". This should be started.

Alternatively, you can open the SQL server configuration manager. There also, you should be able to see the services. You can start the service from here also.

Hope this helps.

[Former Member]

Hi,

Please check the services in the server. The reporting service is stopped, i guess. Please start that service. Please ensure that the setting is set to start automatically.

Hope this helps.