Error deploying GP 2010 SRS reports on SQL Server 2008
Thursday, May 27, 2010 at 3:07PM Working on a GP 10 to 2010 upgrade today I ran into an error while deploying the SRS reports, which indicated I needed a secure connection for the attempted operation. This server was running SQL Server 2008 Express, which I thought might have something to do with the problem, as I’d heard of people having issues with the GP SRS Reports and SQL Express.
As luck would have it this was an upgrade that I had quoted at a fixed amount so I didn’t have a lot of extra time to figure this out. After some frantic “Binging” I found a newsgroup posting regarding a CRM install with a similar error while deploying SRS reports and it led me down the correct path, which was to edit the rsreportserver.config file, which on this machine was located in C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer.
I changed the SecureConnectionLevel Value from “2” to “0”, re-ran the SQL Server Reporting Services Wizard again, and all reports deployed successfully and appear to be working.