Link to home
Start Free TrialLog in
Avatar of mssql_v2005
mssql_v2005

asked on

Query on Microsoft Dynamics CRM 2013 & SQL Server 2012 SP2

We have Microsoft Dynamics CRM 2013, SQL Server 2012 Ent edition with SP1 & Windows Server 2008 R2 OS.

We are planning to upgrade SQL Server 2012 service pack from SP1 to SP2. My question is, does the SQL Server 2012 SP2 work with Microsoft Dynamics CRM 2013 (Microsoft Dynamics CRM 2013 was compatible with SQL Server 2012 SP2)?
Avatar of Feridun Kadir
Feridun Kadir
Flag of United Kingdom of Great Britain and Northern Ireland image
As per this article, https://support.microsoft.com/en-us/kb/3005167, yes, But you do need to have installed Service Pack 1 and Update Rollup 3 for Service Pack 1 for CRM 2013.
Avatar of mssql_v2005
mssql_v2005

ASKER

Thanks Feridun for the response.

Currently we have CRM 2013 with Rollup 2. Will it create any issues/or problems If we apply MS SQL SP2 without updating Rollup3?
ASKER CERTIFIED SOLUTION
Avatar of Feridun Kadir
Feridun Kadir
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mssql_v2005
mssql_v2005

ASKER

--
Avatar of mssql_v2005
mssql_v2005

ASKER

Hello Ferridun, Our development is suggesting to upgrade UR4 instead of Rollup 3. will this compatible with SQL Server 2012 SP2?

I am not able to found links related above. Please advise me on this.
Avatar of Feridun Kadir
Feridun Kadir
Flag of United Kingdom of Great Britain and Northern Ireland image
Yes, upgrading to Update Rollup 4 is compatible with SQL Server 2012 SP2.

The link that I posted earlier (https://support.microsoft.com/en-us/kb/3005167) shows the minimum version of CRM 2013 (UR3 for SP1) that is compatible with SQL Server 2012 SP2.

So if you go straight to UR4 that will be fine.