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..
Connection to [databasename] failed(0) Error creating ArcSDE direct connection (-493).
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.
I just encountered the same error on a new VM server? Was there any solution found?
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
Connection to [databasename] failed(0) Error creating ArcSDE direct connection (-493).
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
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