We help IT Professionals succeed at work.

Integrating SharePoint 2010 with SSRS

Medium Priority
524 Views
Last Modified: 2012-08-13
Hi,

I'm trying to integrate SharePoint 2010 server with Reporting Services on SQL 2008 server (SP server & SQL server reside on separate Windows machines). I've installed the reporting services on SQL Server and have completed the Reporting Services Configuration Manager set-up.

When I try to configure Reporting Services Integration from Central Admin on SharePoint I get an error (please see the attached image).

After some research I found a solution on msdn blog; to add Service Principal Name to the domain controller.

Solution:

1. Open the Reporting Service Configuration Management.
2. Go to 'Service Account' tab, remember the account name.
3. Logon the Domain Control with domain administrator.
4. Register the SPN for the account we got from step2. We need to register the following two SPNs.
        SETSPN -A HTTP/VMT-MOSS:86 <service account>
        SETSPN -A HTTP/VMT-MOSS.domain.com:86 <service account>
5. Now, make sure we are able to access the Report Server from all clients(e.g. the SharePoint server, the clients)


My Question:

I believe the above solution will fix my problem as well, however, both the SharePoint 2010 server and SQL server are part of different domains. I do not know from which domain controller will the SPN needs to be added? DC for SharePoint or SQL?

I'd appreciate any help. Thanks. ErrorMessage
Comment
Watch Question

You need to give the login for sql server. It could be either windows or sql authentication. Windows authentication should work as long trust is setup between the domains...

Author

Commented:
I actually did provide windows credential for an administrator account. Didn't catch that during the screenshot though.

Author

Commented:
Thanks, I think I need to add the Report Server to the SharePoint farm. Will try the above steps and will get back with the results.

Author

Commented:
Perfect! That was the issue. Added the Report server to the SharePoint farm and was able to Integrate the Reporting Services with SharePoint 2010.

Thanks much for your help!

Author

Commented:
Apart from the link provided in the solution here are some additional helpful links if anyone else needs it:

Deployment Topologies for Reporting Services:
http://msdn.microsoft.com/en-us/library/bb510781.aspx

Add a Web or Application server to SharePoint 2010 Farm:
http://technet.microsoft.com/en-us/library/cc261752.aspx#configure

Explore More ContentExplore courses, solutions, and other research materials related to this topic.