SSRS 2008 integration With MOSS 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raf008 - 06 Apr 2009 18:35 GMT

I am able to configure reporting services 2008 on its own machine and WFE is
configure with the addin. I am using Kerberos authentication. I can
successfully add the SSRS machine to the farm. When I try to grant database
access. I get "Unable to connect to the Report Server WMI provider" I have
dug through msdn forums and nothing. I have setup the spn's for reporting
services. Both SSRS and SQL are using the same service account. In Manage
integration settings I am trying to change from "Trusted" to "Windows
authentication". I get a bunch of 401 errors. I am not sure what else I am
missing. Any help or direction would be appreciated.

Reply to this Message

James Martin - 07 Apr 2009 00:53 GMT

Check the event log for authentication errors containing strange characters.
If that is the case check out this article for the resolution.

http://support.microsoft.com/default.aspx/kb/896861

Signature

Regards,
James M

> I am able to configure reporting services 2008 on its own machine and WFE is
> configure with the addin. I am using Kerberos authentication. I can
[quoted text clipped - 5 lines]
> authentication". I get a bunch of 401 errors. I am not sure what else I am
> missing. Any help or direction would be appreciated.

Reply to this Message

Raf008 - 08 Apr 2009 13:15 GMT

Hi James,

Thanks for the reply. But that link does not really help me much. What I am
looking to fix the Double hop issue in SharePoint. I am trying to publish
reports from BIDS to sharepoint Document Library. I know if Iconfigure to
NTML it works fine, however the problems with datasource. I do not want to
use basic or force a specific account in the datasource. I want to be able to
use kerberos. There problem is that the information is scarce on this topic.
IF you could point in a direction were I can get home as to how to configure
the SPn's and enable kerberos that would be great.

Here is the following configuration
1 - Sharepoint WFE - TESTWFE
1 - SSIS server - TESTSSIS
1 - SSRS server - TESTSSRS
1 - DB server (SQL server 2008) - TESTDB2008
All machines are running W3K
For domain accounts I have the following:
FarmAccount
SQLServiceAccount
PoolAccount

The SQLServiceAccount is used for SSIS, SSRS and the DB Server
Sharepoint is under the farmAccount.

So I have registered the following SPN's:

setspn.exe –A HTTP/TESTDB2008.corp.blue.on.ca:1433 Blue\ SQLServiceAccount
setspn.exe –A HTTP/TESTDB2008:1433 Blue\ SQLServiceAccount
setspn.exe –A HTTP/TESTSSIS.corp.blue.on.ca Blue\ SQLServiceAccount
setspn.exe –A HTTP/TESTSSIS Blue\ SQLServiceAccount
setspn.exe –A HTTP/TESTSSRS.corp.blue.on.ca Blue\ SQLServiceAccount
setspn.exe –A HTTP/TESTSSRS Blue\ SQLServiceAccount

setspn.exe –A HTTP/TESTWFE.corp.blue.on.ca Blue\ FarmAccount
setspn.exe –A HTTP/TESTWFE Blue\ FarmAccount

Is there anything else that I missing?

> Check the event log for authentication errors containing strange characters.
> If that is the case check out this article for the resolution.
[quoted text clipped - 10 lines]
> > authentication". I get a bunch of 401 errors. I am not sure what else I am
> > missing. Any help or direction would be appreciated.

Reply to this Message

Brad Baker - 02 Jul 2009 17:26 GMT

This error seems to occur when the SharePoint Central Administration website
is not on the same server as SSRS. The only workaround appears to be to move
the Sharepoint Central Administration website.

> Hi James,
>
[quoted text clipped - 49 lines]
> > > authentication". I get a bunch of 401 errors. I am not sure what else I am
> > > missing. Any help or direction would be appreciated.

Reply to this Message