Simply put, when I try to access SQL Reports through SharePoint 2010 remotely I get a "The request failed with HTTP status 401: Unauthorized." error. When I access it locally the reports load up just fine.
Here's our basic environment:
- SharePoint 2010
- SQL 2008 R2
- UAG 2010 SP1
I've run myself in circles checking credentials and SPNs and gotten nowhere. Signs point to a Kerberos issue possibly and with Kerberos logging enabled on the SP server I do see this error when pulling reports remotely: "Error Code: 0xd KDC_ERR_BADOPTION". Still, I'm stumped as to the next best step. Anyone else dealt with the type of scenario of have ideas?