topic Re: Problems connecting sql database in ArcGIS Desktop Installation Support Questions

Problems connecting sql database

EvelynHernandez — Tue, 09 Aug 2016 19:21:42 GMT

Hello,

I am trying to connect to a SQL database and I have the following error:

What is happening? my credentials for the sql server i tried it in another program and they work...

Thanks in advice!

Re: Problems connecting sql database

JoeBorgione — Tue, 09 Aug 2016 19:48:23 GMT

What is the flavor of your SQL databse? Is it an enterprise (sde) geodatabase? Is it a personal sde geodatabse (sql server express) or a non-spatial SQL server database?

The SDEHome reference is an indication that you are connecting to an enterprise or sde geodatabase: if that is the case, you do not want to use a database server connection, but rather a direct connect database connection: fill in the instance with the name of the machine or IP address, username/password and database name.

Re: Problems connecting sql database

EvelynHernandez — Tue, 09 Aug 2016 19:51:37 GMT

I did that already using the ip and instance, but when i do that gives me that error.

Re: Problems connecting sql database

JoeBorgione — Tue, 09 Aug 2016 20:03:35 GMT

Is this a remote database, that is on the other side of a fire wall?

Re: Problems connecting sql database

EvelynHernandez — Tue, 09 Aug 2016 21:36:49 GMT

Im not sure about it.

But for example, i just tried with my local administrator account from my computer to connect to that DB with arcmap and it worked.

If i tried with my domain acc i get the error that i showed u...

Re: Problems connecting sql database

JoeBorgione — Wed, 10 Aug 2016 01:07:00 GMT

Sounds like your domain account login isn't a valid login in the SQL database. You need to find out if it is using windows authentication or database authentication and take the appropriate steps to get a correct login account.

Re: Problems connecting sql database

EvelynHernandez — Wed, 10 Aug 2016 14:39:44 GMT

Im not trying to log in with my domain account, i have special credentials to do it.

I said, when i log in in windows with a local account and try the credentials i have i can connect to the DB.

After that, if i log in in my pc with my domain acc and try the credentials i cannot connect to the db.

Idk whats happening.

Re: Problems connecting sql database

JoeBorgione — Wed, 10 Aug 2016 14:51:50 GMT

Idk whats happening.

Me either.....

Re: Problems connecting sql database

EvelynHernandez — Thu, 11 Aug 2016 13:54:45 GMT

I solved my problem accessing the arcmap in admin mode.