locked
CRM 4 workgroup edition: Separate SQL Server RRS feed

  • Question

  • 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

  • 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

  • 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
  • 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