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)?
mssql_v2005Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Feridun KadirPrincipal ConsultantCommented:
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.
mssql_v2005Author 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?
Feridun KadirPrincipal ConsultantCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

mssql_v2005Author Commented:
--
mssql_v2005Author 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 ConsultantCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.