I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on the same server than our SharePoint 2007 server.
However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found". Please see screenshot:
I'm suspicious that there is a version mismatch between the report server and the Reporting Services Add-in. Our SQL Report Server is 2005 SP3 and the Report Server version is 9.3.4035. However the SRS 2005 Add-in for SharePoint version that I just
installed is only version 9.00.3294.00.
Is there a more updated version of the SRS 2005 Add-in for Sharepoint?... or is SRS 2005 with SP3 is not compatible with the Add-in?
Please let me know what would be the best solution for
View Complete Post