Unable to create new database connection file.

1689
5
Jump to solution
05-11-2018 12:19 AM
Highlighted
Occasional Contributor II

"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

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
MVP Regular Contributor

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

Try these:

View solution in original post

5 Replies
Highlighted
MVP Regular Contributor

You need to provide more details, such as..

  • What is the version of ArcGIS Desktop being used?
  • Database version (example: SQL Server 2014 SP2 or PostgreSQL 9.5.x ?)
  • Issues happening on one machine only?
  • Issues happening while connecting with particular login or any login?
  • Error screenshot
  • Have you successfully created database connections on this machine before?
Reply
0 Kudos
Highlighted
Occasional Contributor II
  • 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
Reply
0 Kudos
Highlighted
MVP Regular Contributor

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

Try these:

View solution in original post

Highlighted
Occasional Contributor II

Hi,

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

Thanks for the help.

Reply
0 Kudos
Highlighted
Occasional Contributor

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.
Reply
0 Kudos