Unable to add feature class to enterprise geodatabase

PaulMcCord

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: 

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.

AfreenVirani

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