Microsoft CRM 4.0 & SQL Server 2008 Reporting Services on the same server


Microsoft Dynamics CRM 4.0 was released at the end of 2007, so it worked really well (tested more) on Windows 2003, SQL Server 2005, Small Business Server 2003 environments.  However, now a days, I see more and more deployments of Microsoft CRM 4.0 on Windows 2008 R2, Exchange Server 2007/2010, SQL Server 2008, and Small Business Server 2008.
 
I’d recommend reviewing the following Microsoft articles to help:
 
 
For folks that want to setup an environment in which both Microsoft Dynamics CRM 4.0 and Microsoft SQL Server 2008 Reporting Services are on the same server (for small deployments or test machine) – you may encounter the following error "Publishing CRM reports failed" during the reports installation section (SBS 2008 environments are OK):
 
 
This is due to Microsoft SQL Server 2008 Reporting Services NOT relying on IIS for accessing reports.  Microsoft KB Article 957053 provide more info on running Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008 – see Issue 6.
 
On one of our environments, the article suggestions didn’t work – it also has Exchange 2010 on it (test server).  As a work-around, we created an IIS Virtual Directory in the Default Website (Port 80/443) referencing the "ReportServer" path (C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer) which allowed the Microsoft CRM 4.0 installation process to complete successfully:
 

 
We tested the reports after the installation and also after applying the latest Update Rollup (UR7) – they ran fine.  This approach is unsupported.
 
 

   

Contact us if you need help with your Microsoft CRM.  Free Estimate.
 
Frank
Workopia, Inc.
Microsoft Dynamics CRM MVP

Follow Workopia on Twitter

FREE 30-Day Trial, Setup & Training – Microsoft CRM Online
 Sign up for a FREE 30-Day Trial, Setup & Training

Advertisements

About Microsoft Dynamics CRM Online

Microsoft Dynamics CRM and CRM Online specialist. Microsoft CRM MVP since 2006
This entry was posted in Microsoft CRM Installation. Bookmark the permalink.

6 Responses to Microsoft CRM 4.0 & SQL Server 2008 Reporting Services on the same server

  1. y says:

    I have following Configurations for current MS CRM 3.0 system:1. Windows 2003 Servera. Crm 3.0 Serverb. Reporting Server 20052. SQL Server 2005(Windows Server 2003)a. MSCRM, andb. METABASE databasesI am planning to upgrade CRM 3.0 to 4.0 and SQL Server 2005 to 2008. For this upgrade I need help to successfully complete it. I have planned following steps for upgrade-1. Upgrade CRM 3.0 to 4.0 with current SQL Server 20052. Then using Deployment Manager to move the database from SQL Server 2005 to 2008. I read this article (http://support.microsoft.com/kb/957053) issues related to installing CRM 4.0 with SQL 2008. But the hot fixes can be installed during CRM 4.0 installation. But I am doing an upgrade with SQL Server 2005 and changing to SQL Server 2008 afterwards.Has anyone done this kind of upgrade? Please help.

  2. Frank says:

    Microsoft CRM 4.0 is supported on Microsoft SQL Server 2008. An upgrade of the Microsoft SQL Server 2005 to 2008 is a common and normal SQL upgrade path and is not dependent on the CRM 4.0 setup files but the SQL upgrade needs to be performed after the upgrade to CRM 4.0 since CRM 3.0 doesn\’t support SQL 2008. Review the Microsoft KB: How to move the Microsoft Dynamics CRM 4.0 deployment – http://support.microsoft.com/kb/952934 if you are using new servers. With any upgrade on a production environment – be sure to perform full backup in case some upgrade issues arise and TEST, TEST, TEST the process in a test environment first to minimize surprise. Good luck.

  3. y says:

    Thanks Frank! I read this article about moving the deployment. I\’ll do this in dev. environment first. I also want to upgrade the CRM 4.0 Server from Win 2003 to 2008. I have Reporting Services 2005 on CRM 4.0 Server. Do I have to upgrade SSRS 2005 to 2008 to work with SQL Server 2008(separate server)? Can you give me some tips what issues I may face and what may be the steps to make CRM 4.0 and SSRS 2005 working with Win. 2008 after Windows Server upgrade. Any article/link you may know?

  4. Muhammed says:

    HiI am new to installing CRM. Im cuurently installing CRM 4.0 on windows server 2008 and I have installed SQL server 2008 along with Visual studio 2008, all of which is running off a VM. When installing the CRM i get the following errors:1.) "Setup failed to validate specified Reporting Services Report Server http://CRM/ReportServer. Error: Client found response content type of \’\’, but expected \’text/xml\’.The request failed with an empty response.Client found response content type of \’\’, but expected \’text/xml\’.The request failed with an empty response."2.) "Service cisvc was not found on computer \’CRM\’.The specified service does not exist as an installed service"Any help will be highly appreciated.Thanks,Muhammed

  5. Frank says:

    Regarding the //CRM/ReportServer – are you able to access the ReportServer URL (HTTP) via browser? Same URL that you placed on the CRM 4.0 setup?

  6. Frank says:

    Regarding expected \’text/xml\’ – check out this Microsoft KB: http://support.microsoft.com/default.aspx/kb/946788

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s