Installing Microsoft Dynamics CRM 4.0 on Small Business Server 2008


This is commonly asked question in the MSDN forums so the CRM Support Team decided to create a post that could become the defacto FAQ.

Here are a few things to keep in mind when installing Microsoft Dynamics CRM 4.0 on Microsoft Small Business Server 2008.

  • Install the Windows Server 2008 Indexing Service Role
    • If you do not install Indexing Service Role you will see the following error during the installation.
  • Exception_Access_Violation

clip_image001

1. Click Start - Click Administrative Tools - Click Server Manager

2. Expand Roles

3. Right click the Files Services Role and choose add Role Services

clip_image002

4. Check the Indexing Service Role and then finish the wizard.

clip_image003

5. Start the Installation of Microsoft Dynamics CRM 4.0 and the Indexing Service required component should not be listed anymore.

  • Install Microsoft SQL Server 2008 Standard or Enterprise

Note: SBS 2008 installs SQL Express for monitoring, but that cannot be used to store the CRM 4.0 databases. You can install Microsoft SQL Server 2008 on the Small Business Server or on an additional server.

  • If you try to install Microsoft Dynamics CRM 4.0 and use the SQL Express install on SBS you will see this Error in the EDW.

clip_image004

  • If you install Microsoft SQL Server 2008 on the SBS 2008 Server and use the default configuration for SQL Server Reporting Services it sets SSL to be required.
    • If this is the case then you will need to use https when you enter the SRS server url during the installation of the Dynamics CRM 4.0 Server.
  • The second option would be to configure SRS to not require SSL. You can update the rsreportserver.config file to set the secureconnectionlevel = 0

1. Go to C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLServer\Reporting Services\ReportServer

2. Open the rsreportserver.config file in notepad

3. Update the secureconnectionlevel = 0

  • Once Microsoft Dynamics CRM 4.0 is installed you will need to install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services to run reports.
    • If the Data Connector is not installed you will see this Error when running reports

Execution 'xxxxxxxxx' cannot be found.

clip_image006

Installing the Data Connector

1. During the install of the data connector make sure to click the check for updates. http://support.microsoft.com/kb/950100

2. After the Data connector install you may need to give permissions to the SQL Service Account on the MSCRM_Config database if you are seeing the following error when running reports within CRM.

Reporting Error: The report cannot be displayed

clip_image008

If you check the SRS logs or run the report in SRS you will see the permission error “Cannot open database “MSCRM_Config” requested by login. The login failed.”

clip_image010

3. After adding the permissions in SQL make sure to restart the SQL Server Reporting Services service.

4. Run an IISReset

a. Click Start, Click Run and type in IISReset

b. If you have UAC enabled and you are not logged in as the admin.
Click Start, click All Programs, click Accessories and right click command prompt and choose Run as administrator

c. Type in IISReset and hit enter.

Hope this helps you get Microsoft Dynamics CRM 4.0 installed successfully on Small Business Server 2008.

Thanks,

Microsoft Dynamics CRM Support Team

Comments (10)

  1. Claudio Casonato says:

    Hi.

    We are installing CRM 4.0, and I’m struggling to find some clear indications on what kind of OS and SQL versions we shoul duse for our server farm.

    We intend to go for Windows Server 2008 and SQL Server 2008, BUT we are unsure what the best version is – 32 or 64 bits?

    Could you please address me to the right direction?

    Many thanks

    claudio.casonato@akzonobel.com

  2. 365blog says:

    If you have the choice of 32 or 64 bit processing, why wouldn’t you use 64 bit. Both work, 64 bit is better.

  3. Anne Stanton says:

    Commonly asked? Cool! Nice post!!

  4. Jeroen Hems says:

    I’ve written a post on installing CRM 4.0 on Windows Server 2008, running a named instance of SQL Server 2008.

    This took me about one and a half days, but I finally nailed it.

    Check it out on my blog (http://therealboerke.spaces.live.com).

  5. Jeff Loucks says:

    I should write a blog on how to migrate CRM 3 on SBS 2003 with SQL 2000 to CRM 4 on SBS 2008 with SQL 2008. That was a challenging process.

  6. Rajesh says:

    can i install Dynamic CRM 4.0 version on windows 2003 Ent. Ed. with SQL Server 2000 database.

  7. Frank says:

    Microsoft CRM 4.0 is not supported on Windows 2000;  Only supports Windows 2003 and 2008.

  8. lubergst says:

    Rajesh,

    Microsoft Dynamics CRM 4.0 only supports SQL 2005 and SQL 2008 in both 32 bit and 64 bit deployments.  If need additional information, then I recommend downloading the Implementation Guide.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=1ceb5e01-de9f-48c0-8ce2-51633ebf4714&displaylang=en

    HTH,

    Luis Bergstrom

  9. el_wolfy says:

    When I try to install Dynamics CRM I see as requirement Microsoft Exchange Server. Is true? or I can skip this step.

    Jorge Valenzuela

  10. small business file server says:

    I gotta try what has posted here. I had problems about my file server now and i hate it's capabilities. I hope that the  featured file server here will help me lessen my worries.

Skip to main content