topic Re: Unable to connect to database list...... in ArcGIS Desktop Installation Support Questions

Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 18:25:28 GMT

ArcGIS 10.1, SP1, Build 3143

ArcGIS Server 10.1

I installed ArcGIS on several new computers in a training lab for our county, I also installed all the SP's, patches and SQL Native Client files. This is the same installation as my desktop. When I log in to this computer with my existing username and password, go to ArcCatalog and try to set up a connection to SDE, I get the following error.

Does anyone have any suggestions?

Thanks,

Chad

Re: Unable to connect to database list......

AsrujitSengupta — Mon, 28 Jul 2014 18:36:05 GMT

Can you provide us a screenshot of the Connection properties?

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 18:46:40 GMT

I have also tried using the Database Authentication but get the same error.

Re: Unable to connect to database list......

AsrujitSengupta — Mon, 28 Jul 2014 19:03:38 GMT

Can you login using that user in SQL Server management Studio?

The Windows Authenticated login being used to make that connection-- does it have a default database assigned within SQL Server?

Also check the Direct_connect log on the problematic machine, it may provide some more information.

Usual location of that log: C:\Users\user_name\AppData\Local\Temp\sdedc_SQL Server.log

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 19:12:28 GMT

Yes I can.

No it doesn't

Here is the latest log entry in that file:

IDBInitialize::Initialize Failed

DB_instance_open() db_connect error: 4064

CAN'T OPEN INSTANCE: sde:sqlserver.

Spatial Engine Connection Failed (-51).

Cannot Get Access to Instance sde:sqlserver

Re: Unable to connect to database list......

AsrujitSengupta — Mon, 28 Jul 2014 19:16:41 GMT

Can you assign that login a Default database and then try again.

SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user | Journey to SQL…‌

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 19:38:27 GMT

I cannot assign the user a default database due to permissions. Although the user I am using with Database Authentication does have a default database associated with that account.

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 19:42:49 GMT

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 19:44:40 GMT

IDBInitialize::Initialize Failed

DB_instance_open() db_connect error: 4064

CAN'T OPEN INSTANCE: sde:sqlserver.

Spatial Engine Connection Failed (-51).

Cannot Get Access to Instance sde:sqlserver

Error log report

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 19:46:27 GMT

You do realize that on my existing desktop computer, I have already connected to SDE multiple times. This issue is with a new computer in a training lab on the same network with the same login.

Re: Unable to connect to database list......

AsrujitSengupta — Mon, 28 Jul 2014 19:47:14 GMT

So, the problem is occurring from only one machine? The connections work fine from your personal desktop machine?

Try to copy the sde connection file from that working machine to this problematic machine and then try connecting.

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 20:26:40 GMT

The problem is occurring from 4 machines located in one of our training centers. The connections work fine from my desktop and the desktops of my other 4 coworkers.

Re: Unable to connect to database list......

AsrujitSengupta — Mon, 28 Jul 2014 20:32:56 GMT

If you have SQL Server management Studio installed on any of those 4 problematic machines.....are you able to connect from there to this instance?

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 20:40:11 GMT

I don't have SQL Server Management installed on any of these machines, nor do I have SQL Server Management installed on my normal desktop.

Re: Unable to connect to database list......

JacobBoyle — Mon, 28 Jul 2014 20:53:53 GMT

have you tryed to just ping the host server from command line on the pc and see if they can even contact the SQL server?

in CMD.exe type ping <servername>

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 21:01:03 GMT

yes I can ping the server.

Re: Unable to connect to database list......

JacobBoyle — Mon, 28 Jul 2014 21:17:44 GMT

OK, that's a good start!

are you running the most current version of SQL Server Native Client on all the machines? Is it the right version for the OS?

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 21:21:59 GMT

Yes and yes, it the same instillation process as my desktop, same operating system, same SQL Server Native client.

Re: Unable to connect to database list......

JacobBoyle — Mon, 28 Jul 2014 21:28:57 GMT

On a machine with good connections to SDE browse to: C:\Users\<your user>\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog. You may have to unhide the folder: Show hidden files - Windows Help‌

Copy anything with a .sde and paste it to the same folder on the new machine.

Re: Unable to connect to database list......

ChadFoster — Mon, 28 Jul 2014 21:52:31 GMT

Jacob,

That worked! I guess now I have to copy those files to the other three computers under the folders for those users.

Do you think I will have to do that for every user that logs onto one of these machines?