Will ESRI be providing support for SQL Server 2012 in ArcSDE 10 or will it only be supported at 10.1? We need to keep an ArcIMS application running another year so our plan is to leave one of the SDE databases at 10.0 when we upgrade to ArcSDE 10.1. But if ESRI doesn't support SQL 2012 at ArcSDE 10.0 then we'll have to rethink that.
We had issues opening SDE Geodatabases running ArcObjects 10 code on a Windows 2012 Server with Microsoft SQL Server 2012. Installing Microsoft SQL Server 2008 R2 Native Client solved the problem.
This is not a supported configuration. The Native Client is backward compatible, in that the 2012 version supports connections to SQL Server 2008R2, 2008 & 2005, but not the other way around. If you are connecting to SQL Server 2012, you must use the latest SQL Server Native Client.
A number of issues related to SQL Server 2012 support were addressed in ArcGIS 10.1, SP1 & in a SQL Server 2012 support patch. These fixes are not available for ArcGIS 10.0. Despite the fact that you may be able to connect and work with a 10.0 geodatabase, it is not supported, and any issues you encounter related to this configuration are not something we'll be able to fix.
