Quick Tip - Installing CRM 4.0 with SSRS 2008

Wow time does fly, it's been over a month since my last post!  However, now that the Ascentium / Avanade deal is closed and we are comfortably in our new home, I have the time to start posting again.

As part of our move to Avanade, I had to setup a staging CRM server for our incoming Ascentium team data.  I installed Microsoft Dynamics CRM 4.0 on an environment with SQL Reporting Services 2008 (SSRS) and then imported our old organization.  During the import we got the following error:

19:16:29|  Error| Import Organization (Name=Ascentium, Id=5223ab21-5a61-df11-ac17-00155d02a321) failed with Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x800700B7):

Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)

--- End of inner exception stack trace ---
at System.DirectoryServices.DirectoryEntry.Invoke(String methodName, Object[] args)
at Microsoft.Crm.Setup.Server.Utility.IIsUtility.StartWebSite(String metabasePath, String machineName)
at Microsoft.Crm.Setup.Server.Utility.ReportsUtility.ConfigureReports(Uri reportingUrl, String organizationName, Boolean grantNetworkService)
at Microsoft.Crm.Tools.Admin.DBImportHelper.RePublishReports(IDbCommand command, String organizationUniqueName, Uri reportUrl)
at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, String privilegedUserGroupName, String sqlAccessGroupName, String userGroupName, String reportingGroupName, String privilegedReportingGroupName, ICollection`1 users, MultipleTenancy multipleTenancy)

Unfortunately, this error is not very useful or accurate.  The problem really had nothing to do with creating a file, well maybe it did, but the real problem is that Internet Information Server (IIS) could not restart.  The error from the Windows Event Viewer was:

The World Wide Web Publishing Service (WWW Service) did not register the URL
prefix http://*:80/ for site 1. The necessary network binding may already be in use. The site has been disabled. The data field contains the error number.

As you can see, the real issue was that IIS could not start the default web site (port 80).  This was because another site (SSRS in fact) was already bound to port 80. Unfortunately, Microsoft Dynamics CRM setup is not aware that SSRS 2008 does not actually host its pages in IIS and instead hosts it from the SSRS service.  Because of this, setup (Deployment Manager) just default to assume it is the default web site.

The fix was to temporarily disable the other site (the SSRS 2008 service) on port 80, which allowed CRM to start the IIS set and get past the error.  After CRM was happy, I re-disabled the default web site.  CRM 5.0 is aware of SSRS 2008 and does not have this problem.

Cheers,

This posting is provided "AS IS" with no warranties, and confers no rights.

Comments

[ffxiv gil]

Microsoft Dynamics CRM setup is not aware that SSRS 2008 does not actually host its pages in IIS and instead hosts it from the SSRS service. Because of this, setup (Deployment Manager) just default to assume it is the default web site.

[coach suitcase]

Chairman Mao said it is necessary to drill as much as possible, and the more you apply it in real situations, the more natural it will become.

[oil paintings]

It is very glad to find your post about the topic here. I really benefit a lot from your post. Thank you for posting this.

[Nike Shox R4]

The article you have been posted on the webstie have some influence on the republic of letters. Good job. Go on working and you will achieve much more success.