topic Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9 in Data Management Questions

Connection to database 'xyzxy' failed Error creating ArcSDE direct connection (-9).

SelcanGuner — Fri, 28 Jun 2024 16:48:53 GMT

I 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..

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

DOCGIS_Support — Tue, 28 Sep 2010 02:32:00 GMT

I 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.

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

MitraAkbari — Tue, 05 Oct 2010 22:03:50 GMT

Same here. Installing ArcSDE 10 on AIX 6.1 with oracle 11gR2. running the sdesetup utility
give 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 direct connection (-1)

Anybody has installed SDE10 successfully on AIX 6.1?

thank you for any idea or solution..

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

JacksonTrappett — Sun, 12 Dec 2021 03:27:22 GMT

Anybody figure this one out? We are getting this too and I haven't been able to find an answer.

My details:
-Setting up a new ArcSDE 10.0 database on ArcSDE Server 64-bit (win 2008 server 64-bit)
-SQL Server 2008 64 bit
-Fails at repository setup with error:

     Connection to [databasename] failed(0)
     Error creating ArcSDE direct connection (-493).

I checked and the database has been created on the db server, and has the correct permissions, etc.

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

NAOMIPAUL — Sun, 12 Dec 2021 03:27:25 GMT

I just encountered the same error on a new VM server? Was there any solution found?

Anybody figure this one out? We are getting this too and I haven't been able to find an answer.

My details:
-Setting up a new ArcSDE 10.0 database on ArcSDE Server 64-bit (win 2008 server 64-bit)
-SQL Server 2008 64 bit
-Fails at repository setup with error:
     Connection to [databasename] failed(0)
     Error creating ArcSDE direct connection (-493).
I checked and the database has been created on the db server, and has the correct permissions, etc.

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

NAOMIPAUL — Tue, 30 Nov 2010 19:58:22 GMT

Error -493 During Post Install
I was setting up ArcSDE 10 on a VM server for testing, with SDE & SQL on different servers.

I just encountered the same error on a new VM server? Was there any solution found?

According to the Help:
http://help.arcgis.com/EN/ArcGISDesktop/10.0/help/index.html#//00050000000s000000.htm

Beginning with ArcGIS 10, the SQL Native Client 2008 is installed with ArcGIS Desktop, ArcGIS Server, and ArcReader, and can optionally be installed with ArcGIS Engine. If you need a different version of the SQL Native Client, download it from the Microsoft Download Center.

Solution
�?� Download the Feature Pack from Microsoft Support
�?� (SQL Server 2008 Native Client is inside)
�?� Install the x64 version on the VM server with ArcSDE 10

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

JasonCamerano — Wed, 15 Dec 2010 17:31:28 GMT

I had similar issues as well. I contacted Systems here at the ESRI offices and these were the steps taken to resolve the issue:

1. Set SQL Server Authentication mode to mixed mode (Windows and SQL Server authentication) 2. Enable tcp/ip and named pipe protocols for SQL Server 3. Add the sde SQL Server authentication account to the db_owner database role in the sde database 4. Restart SQL Server service 5. Verify you can connect to the SQL Server instance using the sde SQL Server authentication account 6. Re-attempt the post install

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

SusanJones — Sun, 29 May 2011 02:07:16 GMT

Hey Jase - You are sooooo cool. It works for bit. Thanks for that (I was beginning to do my head in).

I had similar issues as well. I contacted Systems here at the ESRI offices and these were the steps taken to resolve the issue:

1. Set SQL Server Authentication mode to mixed mode (Windows and SQL Server authentication) 2. Enable tcp/ip and named pipe protocols for SQL Server 3. Add the sde SQL Server authentication account to the db_owner database role in the sde database 4. Restart SQL Server service 5. Verify you can connect to the SQL Server instance using the sde SQL Server authentication account 6. Re-attempt the post install

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

JeremyBixby — Sun, 12 Dec 2021 03:27:28 GMT

I am having this exact same issue. I have 4 servers, 2 for test and 2 for production. Each pair is an "apps" server and the other is the "data" server. Running out install on SQL Server 2008 R2, on VMWare virtualized machines. I have the exact same issue as the others noted here, specifically,

 Connection to [databasename] failed(0)
     Error creating ArcSDE direct connection (-493).

When I run the post-install (with the DBO schema), it allows me to create the database, but it dies before the repository can be configured (with the noted error message). When I try it with the SDE schema, it gives me a SQL State native error: 3809496, which I can't find too much about.

So I first followed Jason's solution:

1. Set SQL Server Authentication mode to mixed mode (Windows and SQL Server authentication) 2. Enable tcp/ip and named pipe protocols for SQL Server 3. Add the sde SQL Server authentication account to the db_owner database role in the sde database 4. Restart SQL Server service 5. Verify you can connect to the SQL Server instance using the sde SQL Server authentication account 6. Re-attempt the post install

and it's still broken. So then I noted Naomi Paul's solution:

Solution
�?� Download the Feature Pack from Microsoft Support
�?� (SQL Server 2008 Native Client is inside)
�?� Install the x64 version on the VM server with ArcSDE 10

but I do not want to install ArcSDE 10 with the SQL Server software.

So what am I missing here? Any thoughts or ideas?

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

JeremyBixby — Fri, 27 Apr 2012 15:18:10 GMT

FYI - I dialed up tech support for help with this. If somebody else comes across the same issue: the sql native client has to be installed on BOTH the app server AND the data server (where data and app separation is used).

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

VishApte — Wed, 16 May 2012 06:53:50 GMT

I had exact same error and took a while to determine the cause.

I was doing the ArcSDE 10 64 bit post-install as SDE user and was specifying the SDE password that did not meet SQL Server 2008 R2 login password policy. Would be nice if SDE Post-install gives native SQL error code.

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

DeminHu — Wed, 16 May 2012 11:43:43 GMT

During postinstallation, did you use Sysadmin user?

Re: Connection to database 'xxxxx' failed Error creating ArcSDE direct connection (-9

ChrisWright — Thu, 05 Jul 2012 16:34:27 GMT

No kidding. Why does the ArcSDE post installer let you create a password that can't be used? this installer has not changed much in 10 years and the Oracle post installer is even worse.