Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 4 workgroup edition: Separate SQL Server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote 
    Hi


    Is it possible to install CRM 4.0 workgroup edition in a scenario, where I connect to a separate physical sql server in the domain?




    Patrick
    Tuesday, March 3, 2009 9:24 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, you can connect to a separate sql server.  Be sure to install the SRSS Connector after you have installed the other components.  This will ensure that accessing reports is more seamless and the user has a good experience.  The SRSS Connector is part of the CRM 4 install package.
    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Thursday, March 5, 2009 9:46 PM
    Wednesday, March 4, 2009 11:16 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, you can connect to a separate sql server.  Be sure to install the SRSS Connector after you have installed the other components.  This will ensure that accessing reports is more seamless and the user has a good experience.  The SRSS Connector is part of the CRM 4 install package.
    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Thursday, March 5, 2009 9:46 PM
    Wednesday, March 4, 2009 11:16 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Beaware of:

    ·         SQL Server 2005, Workgroup Edition is supported only if Microsoft Dynamics CRM is installed on Windows Small Business Server.

    ·         SQL Server 2005, Workgroup Edition is not supported for running the Microsoft Dynamics CRM Connector for Microsoft SQL Server Reporting Services when Microsoft Dynamics CRM Server is installed as an Internet-facing deployment (IFD). This is because SQL Server 2005 Workgroup Edition does not support custom data extensions. Therefore, some features such as report scheduling will not work.

    Jim Wang - MVP Dynamics CRM - http://jianwang.blogspot.com , http://mscrm.cn
    Thursday, April 9, 2009 3:15 PM
    Moderator