Report Builder 3.0 and SharePoint

Question

I have an issue connecting to a Report Server from my desktop.  I can connect to the report server at http://sharepoint/sites/somesite when I am logged onto a SharePoint server but cannot connect from my desktop.  The reports run fine from my desktop, I just can't create a new one or edit an existing because it won't connect to the report server.  We are using Kerberos authentication and it kinda has a Kerberos smell to it but I'm not sure.  Any advice would be greatly appreciated!  Thanks!

Answer 1

Hi there

Yes, i think it is a Kerberos issue. Sounds like your data source for the report is on a different server than SharePoint? You facing the typical double-hop issue. Running the report on the sharepoint server, you dont need to pass credentials twice.

Troubleshooting Kerberos issues can be rather tricky but start by ensuring you have done the basics.

1) Site setup to use kerberos

2) SPN created

3) Delegation granted (server and app pool users)

Usually a quick way to tell if your Keb is working is if the web app you connecting to is configured to use kerberos and when you first access it (with a domain account that has permissions) you get asked for credentials, then more than likely something isnt working.

Looks for tools like Kerbtray and turn on loggin to help find the problem.

Kind regards

Riccardo

---

PS. Please remember to mark your question as answered if you got good advice.