We help IT Professionals succeed at work.
Get Started

Integrating SharePoint 2010 with SSRS

531 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
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE