Microsoft Sql Server 2008 Native Client Error Arcgis 10
Contents |
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start Chat Back to results Print Share Is This Content Helpful? Search on GeoNet Submit to sql server client communication software ArcGIS Ideas How To: Ensure that the Microsoft SQL Server Native Client is
Sql Server Native Client Software
installed with the ArcGIS Desktop products Summary Instructions provided describe how to ensure that Microsoft SQL Server Native Client (SNaC)
Microsoft Odbc Driver 11 For Sql Server And The Sql Server Native Client
is installed on ArcGIS Desktop products. Even when ArcGIS Desktop software has been successfully installed, there can be issues establishing a direct connection to an ArcSDE database or upon opening existing .mxd files
Microsoft Sql Server Native Client
or .pmf files where the data sources are broken.One possibility for this behavior could be that the Microsoft SQL Server Native Client is not installed on the client machine(s) attempting to connect to an ArcSDE database, or open an existing .mxd or .pmf file using an ArcSDE direct connection.Beginning with ArcGIS 10, the SQL Server Native Client 2008, a prerequisite to making direct connections to SQL Server, arcgis sql server express is installed with ArcGIS Desktop, ArcGIS Server, and ArcReader. This can optionally be installed with ArcGIS Engine. What's new for geodatabases in ArcGIS 10 Depending on the options chosen during installation, the Microsoft SQL Server Native Client (SNaC) may not have been installed. Procedure Please verify that the following steps have been completed.On the Windows client machine, in Add / Remove Programs, verify that 'Turn Windows features on or off' has been selected.Check to see if the Microsoft SQL Server 2008 Native Client has been installed. If the SQL Server 2008 Native Client has already been installed, then do not proceed to step 3 as this may not be the cause of the specific connection issues. If however, the SQL Server 2008 Native Client has not been installed, then proceed to step 3.Execute the ArcGIS Desktop setup.exe - Application. By deploying the setup.exe, the Microsoft SQL Server Native Client setup is included in the installation.Note:Do not execute the setup.msi as this does not install any prerequisite checks.For additional information please review the following link:ArcGIS 10 Enterprise DeploymentOnce the SQL Server Native Client has been installed, proceed with establishing an ArcSDE direct connection or open an existing
for Developers Tools to build location-aware apps ArcGIS Solutions Free template maps and apps for your industry ArcGIS Marketplace Get apps and data for your organization sql server native client 2012 Documentation Pricing Support Esri Sign In user My Profile Sign Out Go create enterprise geodatabase Help HomeGet StartedMapAnalyzeManage DataToolsMore... Troubleshoot database servers Error: Cannot connect to this Data Server...SQL Server does not exist sql server native client 2014 or access denied.Error: Cannot Generate SSPI ContextError: Failed to connect to database Underlying DBMS error (Microsoft OLE DB Provider for SQL Server. Login failed for user '
Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings http://gis.stackexchange.com/questions/3271/error-accessing-spatial-database-connection-with-arcgis-10 and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Geographic Information Systems Questions Tags Users Badges Unanswered Ask Question _ Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute: Sign up Here's sql server how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Error accessing spatial database connection with ArcGIS 10 up vote 4 down vote favorite I set up a new SDE database with ArcGIS 10 and everything appeared to go correctly. The service is running and I'm able to view the database sql server native in SQL Server. However, when I try to access the spatial database connection in ArcCatalog 10, I get the following error: Failed to connection to the specified server. This release of the GeoDatabase is either invalid or out of date. DBMS table not found [Microsoft SQL Server Native Client 10.0: Invalid object name 'sde_mymap.dbo.GDB_Release'.] [sde_mymap.dbo.GDB_Release] Both ArcSDE and ArcCatalog are version 10. I checked the sde_setup.log file and I can find no record of that table being created, or any other errors. Please advise. Thanks, Seth arcgis-10.0 arcsde share|improve this question asked Nov 6 '10 at 21:07 Seth P. 2,16632650 what process did you use to create the db? It sounds like you have sql server with spatial (do you view the data table or the map in sql server?). perhaps you could create a new db in catalog and verify that is working correctly. Have you checked the webhelp for this step? help.arcgis.com/en/geodatabase/10.0/admin_cmds/Support_files/… –Brad Nesom Nov 8 '10 at 15:24 I used the ArcSDE for Microsoft SQL Server Post Installation to create the GeoDatabase. I was not able to create the Database Ser