Reporting Services Integration with Sharepoint
Hi, I was trying to Integrate SSRS 2008 EE with WSS3.0. I have done Following. I have Installed SSRS 2008 EE on same Host where WSS3.0 (with SQL Embeded edition). I have also Installed SSRS Sharepoint Add-ins successfully. Now I have to integrate SSRS on Sharepoint Central Administrations. I could not see Option "Sit Collections Feature" Under Site Settings> Site Aadministration. Also I am looged in as Owner in Central administrator. Any One can help on this? SharePoint is running on Port 16020 and SSRS on 16010 I have also configured SSRS in sharepoint intreagetd mode. I able to open WEB Service URL but not Report Manger URL. Getting following error while opening Report Manager URL(This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode)). In SSRS Log file I could see following error: ERROR: HTTP status code --> 200 -------Details-------- System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: This operation is not supported on a report server that is configured to run in SharePoint integrated mode. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedSharePointModeException: This operation is not supported on a report server that is configured to run in SharePoint integrated mode. Cheers Sunil Gure
April 12th, 2011 2:23am

In SP Central Admin: 1. Click "General Application Settings" 2. Click "Report Server Integration" 3. Enter Report Server Web Service URL 4. Select "Windows Authentication" (see http://technet.microsoft.com/en-us/library/bb283324.aspx for more details) 5. Enter appropriate credentials for an admin account 6. Select "Activate feature in all existing site collections" 7. Click "OK" (if you don't have any existing SP sites this will fail) 8. On the "Report Services Integation Summary" page click "Close" 9. Click “Set server defaults” to verify that the Integration mode has been configured
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2011 9:24am

Thanks Stephen. My issue is diffrent here. It seems SSRS Addin installation is not able to add the feature in sharepoint site collection. Though I am administrator on server and sharepoint as well. Any suggestions?? Below error I got for %temp% directory: User: <mydomainID> Installing Report Server feature. Calling copyappbincontents command. copyappbincontents command completed successfully. Adding Report Server feature to farm. Installed Report Server feature. Activating Report Server feature to root level site collections. Activating feature in web app 'SharePoint - 80' Activating feature to root site collection: http://servername Feature already activated in site collection http://servername Activateing Report Server feature in all admin site collections. Activating feature in web app '' Activating feature to root site collection: http://servername:9235 ******* User does not have permission to add feature to site collection: http://servername:9235Cheers Sunil Gure
May 9th, 2011 6:06am

Thanks Stephen. My issue is different here. It seems SSRS Addins installation is not able to add the SSRS features in sharepoint site collection. Though I am administrator on server and sharepoint as well. Any suggestions?? Below error I got from %temp% directory: User: <mydomainID> Installing Report Server feature. Calling copyappbincontents command. copyappbincontents command completed successfully. Adding Report Server feature to farm. Installed Report Server feature. Activating Report Server feature to root level site collections. Activating feature in web app 'SharePoint - 80' Activating feature to root site collection: http://servername Feature already activated in site collection http://servername Activateing Report Server feature in all admin site collections. Activating feature in web app '' Activating feature to root site collection: http://servername:9235 ******* User does not have permission to add feature to site collection: http://servername:9235 Cheers Sunil Gure
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2011 1:04pm

Was able to install SSRS addins successfully after removing and readding my Domain ID into sharepoint farm.Cheers Sunil Gure
May 24th, 2011 12:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics