topic Support for SQL Server 2012 at ArcSDE 10.0? in Data Management Questions

Support for SQL Server 2012 at ArcSDE 10.0?

RandyKreuziger — Thu, 22 Mar 2012 15:04:18 GMT

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.

Re: Support for SQL Server 2012 at ArcSDE 10.0?

JonDeRose — Thu, 22 Mar 2012 15:59:32 GMT

SQL Server 2012 will be supported in 10.1 Final release.

Re: Support for SQL Server 2012 at ArcSDE 10.0?

RandyKreuziger — Thu, 22 Mar 2012 16:01:48 GMT

Jon,
But will SQL 2012 support be added to version 10.0?

Re: Support for SQL Server 2012 at ArcSDE 10.0?

VinceAngelo — Thu, 22 Mar 2012 18:24:34 GMT

It's not generally practical to do certification testing on a new database with old
application software. It's not at all possible to certify old application software with
an unreleased database application.

With release imminent, you might want to try 10.0 SP4 with the final shipped former-
Denali, but even if it were to be certified, it probably wouldn't be until 10.0 SP5.

A Tech Support incident might be a better way to obtain this information, since
the the set of folks who post here frequently doesn't intersect the set of folks
who are empowered to make future-looking commitments.

- V

Re: Support for SQL Server 2012 at ArcSDE 10.0?

ChadRiland — Thu, 05 Apr 2012 17:32:36 GMT

SQL Server 2012 will be supported in 10.1 Final release.

Can you clarify/explain the ArcGIS support of SQL Server 2012 feature "Always On" in ArcGIS 10.1 Final?

(Described here: http://www.microsoft.com/sqlserver/en/us/solutions-technologies/mission-critical-operations/SQL-Server-2012-high-availability.aspx)

Re: Support for SQL Server 2012 at ArcSDE 10.0?

JeremyBixby — Mon, 10 Sep 2012 17:43:59 GMT

So does ArcSDE 10.0 SPx support SQL Server 2012?

Re: Support for SQL Server 2012 at ArcSDE 10.0?

ShannonShields — Mon, 10 Sep 2012 20:27:32 GMT

No, ArcGIS 10.0 SPx will not support SQL Server 2012. SQL Server 2012 is only supported in 10.1 and later releases.

-Shannon

Re: Support for SQL Server 2012 at ArcSDE 10.0?

JeremyBixby — Tue, 11 Sep 2012 17:23:28 GMT

No, ArcGIS 10.0 SPx will not support SQL Server 2012. SQL Server 2012 is only supported in 10.1 and later releases.

-Shannon

Thanks for the info. It is appreciated!

Re: Support for SQL Server 2012 at ArcSDE 10.0?

AlonsoOrtiz_Amador — Fri, 14 Dec 2012 16:24:57 GMT

I know there's not support of ESRI for ArcGIS Desktop, ArcSDE 10 or ArcGIS Server 10 into Windows Server 2012 and SQL Server 2012, but i install this and it Works just fine, installation steps are the same as in Windows Server 2008 R2 and SQL Server 2008.

The only one exception is it mark some kind of error when you try to run web manager for some controls from .NET 3.5, i read that it's due some inhered of main config of the site at IIS Level, anyway y skip this by deleting some lines from the file config.web and the web manager functions with some errors for services, Works well for managing sites. So i avoid this errors for services managing them thought ArcCatalog Directly.

Anything else Works just fine (y), hope that info provide help for you.

Re: Support for SQL Server 2012 at ArcSDE 10.0?

MichaelThompson — Wed, 28 Aug 2013 14:51:10 GMT

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. We have yet to fully regression test our code on this environment though.

Michael Thompson
Motorola Solutions

Re: Support for SQL Server 2012 at ArcSDE 10.0?

ShannonShields — Thu, 29 Aug 2013 19:49:18 GMT

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.

-Shannon