19 07 2012
Reporting Web Service Proxy does not exist in the farm – SharePoint 2013 Preview and SQL Server Reporting Services
If you get the above error when trying to create a SQL Server Reporting Service Service Application with SharePoint Server 2013 Preview, you will need to register the RS Service Proxy via powershell..
Follow these steps to do this:
- SharePoint 2010 Management Shell with administrator privileges.Right click the icon and click, “Run As Administrator”. Run the following three cmdlets from the shell:
- Install-SPRSService
- Install-SPRSServiceProxy
- Get-SPServiceInstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance
- Verify the SQL Server Reporting Services Service shows status as “Started” on the page: SharePoint 2010 Central Administration -> “Application Management” -> “Manage Services on Server”
Now attempt to create a RS Service Application, it should complete without fail.
This information was found on the SQL Server 2012 Reporting Services Tips, Tricks, and Troubleshooting page on TechNet.
SharePoint Server 2013 Preview – Testing BI on SQL Server 2012? You need CTP3! SharePoint Conference 2012
Thanks Jim – this saved mine and Cherry’s lives 😀