Is MS SQL Server 2008/2012 Native Client provided in ArcGIS Desktop 10.1 / 0.2 or does it need to installed separately on the client machine ?

Question

When creating a geodatabase by connecting to a MS SQL Server database, does a native client need to exist on the client machine if SSMS and/or SQL Server itself does not reside there?

James Fox

DBA - BIA Division of Water and Power

Golden, CO

wendell.fox@bia.gov

RussellBrennan · Answer

James,

Yes, you need to ensure that SQL Server native client is available on the client machine. We use this to connect to the database instance to create your geodatabase.

Russell