SSRS 2008 & MOSS 2007 Alternate Access Mapping Problem
- by Mauro
I have a MOSS Server with SSRS 2008 Ent Ed configured in Sharepoint Integrated mode.
It all works well as http://servername:88/ on the default host header. MOSS works fine using the external host name too on the intranet AAM field (http://site.domain.com/) however SSRS fails on the same url with the message:
An unexpected error occurred while
connecting to the report server.
Verify that the report server is
available and configured for
SharePoint integrated mode.
I think the issue is further complicated by our Windows 2008 infrastructure in which we've never been able to get SPN's working for Kerberos. SQL Server however, is on the same machine so I dont think it is a kerberos double hop issue.
Extra info
MOSS/SSRS are on a VM running Windows 2003 R2
VM is hosted on Win2008 HyperV
DC is on Windows 2008 SBS