I am facing issue in configuring SQL Reporting 2008 R2 With SharePoint 2007, my enviorment details is i have already MOSS Farm and i create new SQL Server 2008 R2 for reporting services. When i brows my reporting server URL its gives me error
The report server has encountered a configuration error. If the report server is configured to use SharePoint integrated mode, verify that the server is joined to a SharePoint farm and that the Report Server service account has been granted access to the
SharePoint farm. (rsServerConfigurationError)
my question is how to join my Reporting server with existing MOSS server?
Note: My SharePoint environment is consist of 2 Web Front End Servers and 1 Indexing Server.
Please check what account you are using to run Reporting Services service, this account should have been granted access to the SharePoint
Databases, and you should be able to display the Report Server Web Service page properly.