Unable to add feature class to enterprise geodatabase

902
4
06-10-2019 10:59 AM
PaulMcCord
Occasional Contributor

I'm trying to add a shapefile to a feature dataset within an enterprise geodatabase. The file I'm adding has an identical spatial reference as the other feature classes in the feature dataset. When I run the Feature Class to Feature Class tool, however, I get the same error:

ERROR 000210: Cannot create output Database Connections\Connection to ...

Must be the owner to perform this operation

Failed to execute (FeatureClassToFeatureClass)

Below is a screen shot of the Feature Class to Feature Class tool: 

Feature Class to Feature Class window

I've talked with our SQL Server database administrator who informed me that I am part of the AD user group with DB Owner permissions. 

I'd appreciate any input why I'm not able to import data to my enterprise GDB.

0 Kudos
4 Replies
AfreenVirani
Esri Contributor

Hello Paul,

When trying to copy/paste or import data into a feature dataset inside an enterprise geodatabase the copier/importer must be the user that owns the feature dataset.

Naming convention in SQL Server: <database_name>.<data_owner>.<feature_class_name>

It looks like you are trying to import the shapefile into a feature dataset that is owned by the user "WAYNECOUNTY". Since you are part of a group that has the "DB_owner" privilege, you are being recognized as "dbo"

Ex: <database_name>.DBO.<feature_class_name>.

Therefore, when you are trying to create the data in that specific feature class it is recognizing you as "dbo" hence an error is thrown.

You  could do the following:

1 - Connect to the geodatabase as the "WAYNECOUNTY" user, and then import the shapefile into the feature dataset. If the "WAYNECOUNTY" user has the db_owner role, then remove the db_owner role from this user.

or

2 - Create a new feature dataset as the existing user - which will be created as "gisdata.dbo.administrativeareas" and then you would be able to import as a feature class into this feature dataset.

Best,

Afreen

PaulMcCord
Occasional Contributor

Thank you Afreen,

Your response is helpful, but I'd appreciate just a little more information on option #1. How would I connect to the geodatabase as the WAYNECOUNTY user in ArcCatalog? Enterprise GDBs are not my strong suit.

0 Kudos
AfreenVirani
Esri Contributor

No problem!

In ArcCatalog, if you right-click on your geodatabase connection > 'Connection Properties' you should see the user that you are connected as by 'User name'. To connect as the WAYNECOUNTY user you would type in "WAYNECOUNTY" as the username, and a corresponding password for that user.

(If you do notice that you are in fact connected with the user name "WAYNECOUNTY", then you would need to ask the SQL Server database administrator to remove the db_owner privilege from this user.)

0 Kudos
PaulMcCord
Occasional Contributor

Unfortunately I was not the person who set up this enterprise geodatabase and he is no longer with our group. The Authentication Type, however, is an Operating System Authentication, so I'm not able to specify a different user name. Is there another way I would do this using OS authentication?

0 Kudos