Sunday, May 20, 2012

No report servers were found on the specified machine - SharePoint 2007

Hi All,

We got the below error in "Grant Database Access" step when trying to configure reporting services in SharePoint 2007 server.

"No report servers were found on the specified machine"

SharePoint 2007 and Database are on seperate machines. Hence, to install reporting services, we have first installed Microsoft SQL Server 2008 R2 Developer Edition with Reporting services database configured in SharePoint Integrated Mode.

We also installed Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint on SharePoint 2007 server. Then, when trying to grant database access in Central Administration, we got the above error.

To resolve this error, we have installed latest version of "Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies" from here.

Once this was done, we were able to render the SSRS reports properly.

Cheers !

No comments:

Post a Comment