Thursday, April 27, 2006 5:22 AM
Manohar
Does the current release of Microsoft CRM Connector for Microsoft Dynamics GP support SQL Server 2005?
The
Microsoft CRM Connector for Microsoft Dynamics GP has three components:
- CRM Adaptor
- GP Adaptor
- Integration System
Now
depending on the deployment configuration each of these components could be on
a different server or on a common server (The Adaptor components need to be
installed on the respective applications with which they interface – the CRM
Adaptor on the CRM server and the GP Adaptor on the GP server). The Integration
System uses BizTalk Server 2004 and hence has a dependency on SQL Server 2000.
None of the other two components have this dependency.
So for
instance if you have a three server configuration where each of CRM Server, GP
Server and Integration Server are different, you could use SQL Server 2005 on
the CRM and GP Servers but you would have to use SQL Server 2000 on the
Integration server. If you have a one server configuration you would need to
have SQL Server 2000; similarly on a two server configuration you would need to
have SQL Server 2000 on the server on which you install the Integration System.