topic Re: Unable to create new database connection file. in Geodatabase Questions

Unable to create new database connection file.

AjitkumarBabar — Fri, 11 May 2018 07:19:03 GMT

"Unable to create new database connection file, permission is denied" error is coming while trying to add database connection in ArcCatalog.

sql 2014 & pg 9.5

Asrujit_SenGupta — Fri, 11 May 2018 07:27:04 GMT

You need to provide more details, such as..

AjitkumarBabar — Fri, 11 May 2018 07:55:04 GMT

What is the version of ArcGIS Desktop being used? - 10.6
Database version (example: SQL Server 2014 SP2 or PostgreSQL 9.5.x ?) - SQL Server 2014 - SP1 & postgresql-9.5.10-2
Issues happening on one machine only? - Yes
Issues happening while connecting with particular login or any login? - With all the logins
Error screenshot - Attached
Have you successfully created database connections on this machine before? - This is the first time

Asrujit_SenGupta — Fri, 11 May 2018 08:03:01 GMT

It sounds like somehow, you don't have write permissions to the directory where the connection files are created.

Try these:

Run ArcCatalog as an Administrator and check...
Use the tool Create Database Connection—Help | ArcGIS Desktop , to create the connection file in a different folder and check if that works...

AjitkumarBabar — Fri, 11 May 2018 08:45:47 GMT

Hi,

Running ArcCatalog as an Administrator didn't help but Create Database connection partially resolved the issue.

Thanks for the help.

YungKaiChin — Thu, 28 Jun 2018 23:16:43 GMT

One workaround is to create a database connection file (*.sde) on a different computer and transfer the connection file.

In my case, ...

The user can create the database connection file and connect to the database on a different computer.
The user can create the database connection file and connect to a different database on the same SQL Server.
The user has rebooted the computer without resolving the issue.