Hello,

I've this hierarchy of CM12 implemented in lab, whereby the CAS is installed with its site database server is installed remotely i.e. the SQL server used is not installed on the site server for CAS.  The remote SQL server has only database engine service and reporting service (SSRS) installed and configured. Both are validated to be working OK. 

Now CAS (Central Admin Site) got installed OK, a primary site also got installed and hooked to existing hierarchy OK. Further...I would like to install the reporting services point onto site server housing CAS. 

When wizard is initiated it reaches the point where i specify the remote site database server; site database name etc. clicking Verify button connects OK; but further down it doesn't show the installed instance of SSRS on remote SQL server acting as site database server. Please see screenshot below. 

When we read this link: (https://technet.microsoft.com/en-us/library/gg712698.aspx) the second security note under heading "To install reporting services point on a site system" specifies following:

The current user must have Read access to WMI on the site system, or the Reporting Services instances cannot be retrieved.

That's what is happening evident from screenshot above. The installed SSRS instance is not displayed. 

Please bear in mind I'm doing all configuration with built-in Administrator's account, so there can be no question of permissions issue on WMI namespace on remote SQL server; or would it?

Please help!! 

Thanks.
Shahzad.

• Edited by Shahzad_Rasool 18 hours 55 minutes ago

Where's the reporting services installation? Is it on the remote SQL server? If so make sure you add the reporting point role to the SQL server and not another site system.

https://sccmentor.wordpress.com/2014/02/06/reporting-services-point-server-instance-blank/

what permissions does your account that you are using have on the remote sq

Hello,

.... the SQL server used is not installed on the site server for CAS. The remote SQL server has only database engine service and reporting service (SSRS) installed and configured <...>

<...>.I would like to install the reporting services point onto site server housing CAS. 

This is not possible.  The reporting services point MUST be installed on the server that is running the SSRS service.  It's literally just an agent that manages said service, which is why it needs to be local to the service.  This is the same as with WSUS, SQL Server, and any other role you plan on pushing with SCCM.  You cannot have the SCCM role and the service it manages be separate servers.

• Edited by Justin.King 6 hours 56 minutes ago