An unexpected error occurred while connecting to the report server.

I have a distributed environment with SQL Server 2005 SP2 (RTM) running on one server. This server holds the databases for SharePoint and Reporting Services. I then have SharePoint 3.0 (32-bit version) with the reporting services add-in installed on a second server. I installed the sharepoint object model (64-bit version) on the database server as suggested and have configured Reporting Services to use domain user accounts. The Reporting Services configuration tool is reporting that integration has been successfully set up but I am unable to access the "Set Server Defaults" page without an error. This is the error I receive:

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

Please help.

Solaena,

I would suggest to take a look at the Report Server log files located on your Report Server machine in this location:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

Look for a log file whose name starts with ReportServerService and see what exception you find there.

Mihaela

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

After some digging I found an error message that led me to this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1282744&SiteID=1

I am now able to access the "Set Server Defaults" page but I am unable to open any reports and I can't add any reports to the web part. From what I can see I have two errors.

#1 - When adding a report to the web part I am denied access. Access is denied to my domain/user account. This account is a domain admin account.

#2 - NULL Reference exception at "...InternalFindObjectsNonRecursive."

Thanks,

Simone

|||Just thought I would updat that I have been working with Microsoft on this for a few weeks and I will post the outcome when it is resolved. Thanks to all for you insight.|||Just thought I would update everyone on this thread, we were finally able to get all of the integration working. To complete the process we needed to use Kerberos authentication and ensure that the browsers were all set up to enable windows authentication. With Kerberos it is important to be sure that SPNs are set up for the domain account used by the sharepoint and reporting service web services. When doing this, also make sure that duplicate SPNs are not inadvertently created. After two months of working to get this resolved I am thrilled to say we are up and running....|||

Hi Simone,

Did you have to create a SPN for just the MOSS site url or both the MOSS and reportserver url ?

Regards,

BC

|||

both servers. also, there is one for just the server name and one for the fully qualified name.

Simone