Jump to content


  • 0
amirhasan

Why installed instance of SSRS is not visible when Site database server is installed remotely?

Question

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!!


Link -->



https://social.technet.microsoft.com/Forums/en-US/143fca88-fb84-435c-9c32-09d17f122b0e/why-installed-instance-of-ssrs-is-not-visible-when-site-database-server-is-installed-remotely?forum=configmanagergeneral


Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.