Critical issue in SQL Server 2012 Service Pack 1 that could crash your SQL server

There is a known issue with SQL Server 2012 Service Pack 1 that everyone should be aware of.  If you have installed Service Pack 1 not part of a slipstream install, the registry on your SQL server could reach the 2GB limit and crash your SQL Server.  To avoid this issue for Dynamics products it is highly recommended to install at least Service Pack 1 Cumulative Update 5 for SQL Server 2012 or above as this version addresses some other issues that impact Dynamics.  As of this blog article, Service Pack 1 Cumulative Update 6 is the current release.

You can read more about this issue at:

 http://blogs.msdn.com/b/psssql/archive/2013/07/31/after-applying-service-pack-1-for-sql-server-2012-you-may-encounter-a-known-issue-details-inside.aspx

As with all Microsoft patches, it should be applied to your test environment before rolling out into your production systems.

Rod “Hotrod” Hansen