Error Creating Arcsde Direct Connection
without it enabled. Please turn JavaScript back on and reload this page.All Places > GIS > Managing Data > DiscussionsLog in to create and rate content, and to follow, bookmark, and share content with other members.Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9).Discussion created by selcan__ on Sep 23, 2010Latest reply on Jul 5, 2012 by ChrisWrightAvolve Like • Show 0 Likes0 Comment • 12I try to install ArcSDE (10) for SQLServer 2008. When I do post install I get an error during repository setup process which says "The ArcSDE repository unsuccessfully completed".In the txt file details are:Connection to MyDatabase failed(0)ESRI ArcSDE Server Setup Utility ....... Sep ............----------------------------------------------------------------Error creating ArcSDE direct connection (-9)It does not move on post install .. Do you have any idea what is the problem and the solution for it.. Thank you for spending time on my problem..OutcomesVisibility: Managing Data2653 ViewsLast modified on Sep 23, 2010 6:09 AMTags:managing_dataContent tagged with managing_datagdbContent tagged with gdb_geodatabaseContent tagged with _geodatabaseThis content has been marked as final. Show 12 comments12 RepliesNameEmail AddressWebsite AddressName(Required)Email Address(Required, will not be published)Website AddressNZ_DOC Sep 27, 2010 7:32 PMI try to install ArcSDE (10) for SQLServer 2008. When I do post install I get an error during repository setup process which says "The ArcSDE repository unsuccessfully completed".In the txt file details are:Connection to MyDatabase failed(0)ESRI ArcSDE Server Setup Utility ....... Sep ............----------------------------------------------------------------Error creating ArcSDE direct connection (-9)It does not move on post install .. Do you have any idea what is the problem and the solution for it.. Thank you for spending time on my problem.. Same happened to us. Never had the time to properly pinpoint the problem (might be connected to leftovers from uninstalling 9.3.1). Anyway, reinstalling SQL Server 2008 solved the problem.Like • Show 0 Likes0 Actions makbari Oct 5, 2010 3:03 PMSame here. Installing ArcSDE 10 on AIX 6.1 with oracle 11gR2. running the sdesetup utilitygive us the error. sdesetup -o install -d ORACLE11G -s orsotest -u sde -l $SDEHOME/etc/ecp.dat 0509-136 Symbol fc_softc (number 94) is not exported from dependent module /usr2/oracle/11201/lib/libclntsh.so. Connection to sde failed(0) Error creating ArcSDE direc
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 error https://geonet.esri.com/thread/13139 in arcsde service up vote 1 down vote favorite I am getting an error message when atempting to Create a connection in Arc Catalog. The message is : Failed to Connect to database SDE not Running on Server Then I Check the Service esri_sde it has not started, so when I try to start it I get the message : The ArcSde Service(esri_sde)service on Local Computer started and them stopped. i found sde_esri_sde.log file http://gis.stackexchange.com/questions/11998/error-in-arcsde-service . the error messages are : IDBInitialize::Initialize Failed DB_open_instance() PCC_connect error: 2 init_DB DB_instance_open_as_dba: -51 DBMS error code: 2 Microsoft SQL Server Native Client 10.0: Login timeout expired i dont know what's wrong ... ?! please help me arcsde share|improve this question asked Jul 9 '11 at 14:13 wetland 2,2382658 add a comment| 4 Answers 4 active oldest votes up vote 3 down vote accepted I suggest you check you connection properties. You were able to run sde post install cleanly? DId you used command line or GUI installation? Can you connect to SQL Server via other tools? VIsual Studio or SQL Management? share|improve this answer answered Jul 9 '11 at 14:35 George 4,71912761 i can connect to sql server via sql management . i used command line to start service but it didnt work(sdemon -o start -i esri-sde -s majid-PC) –wetland Jul 9 '11 at 15:10 @GISlove That just indicates that SQL Server is running, not that SDE is working. You need to resolve the SDE issue (perhaps a username/password problem?) before you can use ArcCatalog to connect to SDE. –Michael Todd Jul 9 '11 at 16:01 add a comment| up vote 3 down vote I only ever used ArcSDE with Oracle but I guess its probably the same. When you say you can connect in s
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 http://gis.stackexchange.com/questions/166080/arcsde-post-installation-error 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 https://esriaustraliatechblog.wordpress.com/2012/09/27/creating-an-arcsde-service-on-windows-using-arcgis-10-1/ 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 error creating are voted up and rise to the top ArcSDE post installation error? up vote 1 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) arcsde sql-server installation share|improve this question edited error creating arcsde Oct 10 '15 at 9:48 PolyGeo♦ 39.1k1357143 asked Oct 10 '15 at 9:18 Ahmad Shoaib 62 1 This is the same as gis.stackexchange.com/questions/102179/… That has no answer but comments suggest some additional information that you should edit into your question.. –PolyGeo♦ Oct 10 '15 at 9:55 3 What's your version of ArcGIS? in new version of arcgis you can use create enterprise geodatabase tool to create sde geodatabase –wetland Oct 10 '15 at 10:06 In just three months the last version of ArcGIS which had an ArcSDE postinstaller will be Retired; it seems a bit late to be creating new geodatabases with that software. That error is associated with an incorrect or invalid password (newer databases enforce a password complexity requirement). –Vince Oct 10 '15 at 12:12 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. B
There is no ArcSDE Post Installation wizard, and the “Create ArcSDE service” operation (as part of the wizard) is no longer supported. And more significantly, the default means of connecting to the geodatabase is via Direct Connections. However, if there is still a need for an ArcSDE service (application server connection) at the 10.1 release, one can be manually created and registered (depending on DBMS) using the following workflow: Edit the service files on windows Steps: 1. Open the services.sde file in a text editor. This file is in the ArcSDE\sdehome\etc folder. 2. Define the service name and TCP/IP port number on which the ArcSDE service will accept connection requests by doing one of the following: • Remove the comment mark (#) from the default entry esri_sde 5151/tcp. • Add a unique service name and TCP/IP port number, for example, arcsde 4000/tcp. 3. Open the Windows services file which is generally located in C:\Windows\System32\drivers\etc. 4. Copy the service entry you defined in the services.sde file and paste it into the Windows service file. 5. Save and close both services files. Once the service information is defined, you can create the service. Create the ArcSDE service using the sdeservice command You must first execute the sdeservice command with the create operation. On all databases except Oracle, execute the sdeservice command again with the register operation to specify with which database this new service will be used. Syntax to execute this against a geodatabase in SQL Server is as follows: sdeservice -o create -d SQLSERVER,SQLSERVERINSTANCE -i