SSRS 2008 & MOSS 2007 Alternate Access Mapping Problem

Posted by Mauro on Server Fault See other posts from Server Fault or by Mauro
Published on 2010-02-24T15:30:10Z Indexed on 2010/04/10 12:53 UTC
Read the original article Hit count: 667

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

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about sharepoint2007