Query on Microsoft Dynamics CRM 2013 & SQL Server 2012 SP2

mssql_v2005
mssql_v2005 used Ask the Experts™
on
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)?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Feridun KadirPrincipal Consultant

Commented:
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.

Author

Commented:
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?
Principal Consultant
Commented:
I can't say for sure but personally I would apply the Update Rollup first given that Microsoft states that UR3 for SP1 is required for SQL 2012 SP2. If you don't apply it and apply SP2 for SQL and things don't work you'll find it harder to get support from Microsoft.

There is also Update Rollup 4 for SP1 for CRM 2013, which you might want to install too but that is optional as far as SP2 for SQL 2012 is concered.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
--

Author

Commented:
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.
Feridun KadirPrincipal Consultant

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial