Hi,

Trying to install the monitoring role with reporting services but must have missed one or several steps! :)

Have 1 standard edition server and 1 server running Lync monitoring and SQL (that I installed myself, hopefully correct)

• Have installed SQL with instance LYNCSQL\LYNSQL (also checked the reporting services feature)
• Have intalled the Standard Edition server
• Have installed the Monitoring role

Now I want to "Deploy Monitoring Server Reports" from the Lync Server Deployment Wizard.

1. Specifying Monitoringserver with FQDN (the same server as the acctual SQL server)
2. Specifying LYNCSQL\LYNCSQL as the Instance\InstanceID
3. Specifying the systemaccount that I added during the SQL server installation
4. Don't specifying any usergroup

Receiving the following error:
Could not get objects from namespace root\Microsoft\SqlServer\ReportServer. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)Cannot get the ReportServerWebService URL. Verify that Reporting Services is deployed and configured properly on the target SQL instance:"LYNCSQL\LYNCSQL", and that WMI is included on the exception list of firewall setting on the server that is running Reporting Services.Invalid parameter

Windows Firewall is Off!
SQL Server 2008 x64 SP2

When looking in the Lync Server Console I see green status of Standard Edition and the Monitoring Server, but from my LYNCSQL\LYNCSQL i have status of N/A.

Where to start? :)

 ---

Update:

Logged on to the Reporting services configuration manager and here are the settings:

Use Built in Account: Local System -> correct or should it be sys.lyncsql as I mentioned before?
Virtual Directory: ReportServer_LYNCSQL
URL:  http://servername:80/ReportServer_LYNCSQL
SSL: Not Selected

Hi,

Firstly, you need make sure Web Service URL and Report Manager URL could be opened in both Lync FE and SQL server.

If prompt authentication chanllenges you have to change the built in account with "Network Service".

Furthermore, make sure firewall is turned off when troubleshooting to rule out ports and connection issue.

Update let us know.

I have a very similar error when trying to deploy monitoring server reports... I'm lost...

> Deploying Monitoring Server Reports... This might take a few minutes.

The Monitoring Server is using SQL instance "cinshrlnc03.domain.com".

The data source is using SQL instance "(local)".

Could not get objects from namespace root\Microsoft\SqlServer\ReportServer. Invalid namespace 

Invalid namespace 

Cannot get the ReportServerWebService URL. Verify that Reporting Services is deployed and configured properly on the target SQL instance:"cinshrlnc03.domain.com\default", and that WMI is included on the exception list of firewall setting on the server that is running Reporting Services.

Invalid parameter 

Any thoughts? Thanks!!

Stephen

• Marked as answer by [fredrik] Wednesday, March 30, 2011 8:09 PM

• Marked as answer by [fredrik] Wednesday, March 30, 2011 8:09 PM

Hi,

Firstly, you need make sure Web Service URL and Report Manager URL could be opened in both Lync FE and SQL server.

If prompt authentication chanllenges you have to change the built in account with "Network Service".

Furthermore, make sure firewall is turned off when troubleshooting to rule out ports and connection issue.

Update let us

I believe he refers to the account under wich the sql reporting service is running..

Regards
Jonatan

Last week I also encoutered this problem. Fixed the issue by loggin into the server from where the reports needed to be deployed with the SQL Server Reporting Services service account. During the errors we noticed several tokens on the SQL server and after a while we logged in with the service account, and then the reports where deployed without any problem. Therefore we concluded that we had to sign in with the service account and this fixed the issue immediately.

After deployment, change the permissions in the reporting services in order to provide proper permissions for you organisation.

• Edited by Amir_Ali 20 hours 14 minutes ago

• Edited by Amir_Ali Monday, March 24, 2014 2:40 PM