Hi Lee,

Yes, you can setup Sage CRM server by creating separate Application and SQL server. To make connectivity between SQL and Application server, you have to check whether below given settings are configured correctly or not?

1.SQL Server Native Client is installed and activated correctly on Application server .
2.TCP Port is correctly configured and Enabled on SQL server. For e.g. 1433 . please refer the below given link for the same.
http://msdn.microsoft.com/en-us/library/ms175043.aspx

Hope this helps!

Regards,
Dinesh

depends on the version of sql, sql database is accessed differently in both 2008 and 2012, sql native client has been brought back in v2012 as opposed to v2008

cheers

Kannan

Hi Dinesh,

I know CRM and SQL can be on different servers. I've done it several times. What I wanted to know was that when I come to patch SQL Server, does the SQL Server patch need to be run on the application server? Does the patch upgrade any of the SQL tools that are installed on there?

CRM is installed on Server A. SQL 2008 R2 is installed on Server B. I need to installed SQL SP2 on Server B to patch SQL. Does the patch also need to be run on Server A on which the SQL Tools are installed. The SQL tools were installed originally so that when I first installed CRM on there I could install the database onto Server B without having to first install SQL Express.

The simple question is, "Do I need to run the SQL SP2 patch on the CRM server to upgrade any SQL tools?"

Hi Lee,

Frankly speaking if it’s just the patch upgrade, I don’t think there will be any issues. Better approach is to always study the upgrade notes of any software. Usually client tools, native client version does not get affected by such updates and do it only when it does.

Hope this helps!

Regards,

Dinesh