Arcgis 10 Sql Server 2008 Error
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 arcgis 10.3 sql server Content Helpful? Search on GeoNet Submit to ArcGIS Ideas How To: Ensure arcgis 10.3 sql server 2012 that the Microsoft SQL Server Native Client is installed with the ArcGIS Desktop products Summary Instructions provided describe
Arcgis Sql Server Express
how to ensure that Microsoft SQL Server Native Client (SNaC) is installed on ArcGIS Desktop products. Even when ArcGIS Desktop software has been successfully installed, there can be issues
Arcgis Sql Server Native Client
establishing a direct connection to an ArcSDE database or upon opening existing .mxd files 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 arcgis sql server 2014 ArcSDE direct connection.Beginning with ArcGIS 10, the SQL Server Native Client 2008, a prerequisite to making direct connections to SQL Server, 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 install
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
Arcgis Sql Server Spatial
Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error: Connection arcgis sql server permissions was attempted with an older version of SQL Server client communications software that is not compatible with the arcgis connect to sql server SQL Server database server Error Message Connecting from ArcGIS Desktop or another ArcGIS client to an enterprise geodatabase hosted on SQL Server returns the following error message:"Connection was attempted http://support.esri.com/technical-article/000011340 with an older version of SQL Server client communications software that is not compatible with the SQL Server database server." Cause ArcGIS enforces the rule that the database client software that manages communication between the application and SQL Server is at least as new as the SQL Server instance to which it is connecting. This eliminates a group of http://support.esri.com/technical-article/000010759 problems that arise when the database client software does not understand new data types introduced in the newer databases. This also supports Microsoft’s recommendation in this regard. The following rules now apply: • SQL Server Native Client software is required to connect to SQL Server 2012 or earlier geodatabases. • The SQL Server Native Client must be the same version, or a newer version than the version of SQL Server you are connecting to.• A connection to a Windows Azure SQL Database requires the Microsoft ODBC Driver 11 for SQL Server. This driver can also be used to connect to any 10.2.x geodatabase on SQL Server 2008, 2008R2 or 2012.• The SQL Server Native Client software must be installed on any Windows machine from which a connection is made. This includes on ArcSDE servers to support an application server connection. Solution or Workaround Install the appropriate SQL Server client communication software.Both the Microsoft ODBC Driver 11 for SQL Server and the SQL Server Native Client are available for download from Microsoft. Created: 5/5/2016 Las
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 and policies of this site About Us Learn more about Stack Overflow the company http://gis.stackexchange.com/questions/102179/error-post-installation-arcsde-for-sql-server-2008 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. http://gis.stackexchange.com/questions/68265/arcgis-for-server-10-1-including-arcsde-and-sql-server-2012-problem-with-creat Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Error post installation ArcSDE for SQL sql server server 2008 up vote 0 down vote favorite I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then when I click on OK, what appears is: Connection to sde failed(0) please can somebody help me ? I am using ArcGIS 10,ArcSDE 10,SQL Server 2008 and for service pack I use SP2 arcgis-10.0 arcgis-server arcsde arcgis sql server sql-server installation share|improve this question edited Jun 16 '14 at 21:50 PolyGeo♦ 38.8k1357141 asked Jun 16 '14 at 14:30 user24541 162 Please update your question to include the exact version (with service pack) of ArcGIS you are using. –Vince Jun 16 '14 at 14:46 Make sure you can successfully connect to SQL Server using your account and that SQL server is running OK on it's own. –Dowlers Jun 16 '14 at 17:00 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Browse other questions tagged arcgis-10.0 arcgis-server arcsde sql-server installation or ask your own question. asked 2 years ago viewed 124 times Linked 1 ArcSDE post installation error? Related 4Creating a multiversioned view with ArcSDE and SQL Server 2008 R22Creating ArcSDE Geodatabase without post installation?1ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services9SQL Server Relationships in ArcSDE?6Installing ArcSDE 10 on SQL Server 2008 R2 Cluster 64bit or 32bit?0Enabling SQL Server 2008 database to access it
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 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 how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ArcGIS for Server 10.1 (including ArcSDE) and SQL Server 2012 problem with Create Enterprise-Geodatabase up vote 1 down vote favorite i have the following server system: -Windows Server 2008R2 -SQL Server 2008 (SDE10 Enterprise Geodatabaees) and SQL Server 2012 on the the same machine -ArcSDE Application Server 10 First - Is that right, that i do not need to install the ArcSDE 10.1 for Microsoft SQL Server because we use direct connect on the client ? Now i want to create with ArcGIS 10.1 a new ArcSDE 10.1 Enterprise Geodatabase on SQL Server 2012 with the "create enterprise geodatabase" tool. But i get an error messagge: Unknown errorNo extended error. I look at the sdedc_SQL Server.log: DB_instance_open() db_connect error: -1 CAN'T OPEN INSTANCE: sde:sqlserver. Spatial Engine Connection Failed (-51). Cannot Get Access to Instance sde:sqlserver arcgis-server arcgis-10.1 arcsde sql-server share|improve this question edited Aug 9 '13 at 8:04 PolyGeo♦ 38.8k1357141 asked Aug 9 '13 at 6:24 Sebastian 62 Do you have the Database permissions to create Enterprise Geodatabase on SQL Server 2012 ? –Sunil Aug 9 '13 at 8:13 +1 may be useful for you forums.esri.com/Thread.asp?c=158&f=2290&t=297754 and resources.arcgis.com/en/help/main/10.1/index.html#//… –Sunil Aug 9 '13 at 8:16 Yes i have the permisson to create the database. –Sebastian Aug 9 '13 at 8:17 When using the create enterprise geodatabase tool, are you specifying the server name, or are you using the 10.0 direct connect syntax (sde:sqlserver:servername)? You should only be specifying the server name. –travis Aug 10 '13 at 8:09 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote SQL-Server 2012 support was introduced at ArcGIS 10.1 SP1. You must also have the required SQL-Server 2012 client library install (and its dependent .Net Framework 4.x components) on the ArcGIS 10.1 SP1 client. Discussion on the "need to instal