How do I correctly set up SQL permissions for ArcGIS Pro?

Question

I am having a problem setting the correct permissions in SQL to be considered a data owner in ArcGIS Pro. Any assistance would be greatly appreciated. I am using SQL Server Express 2019 and ArcGIS Pro 2.5.1

I am connecting to the SQL instance using the Windows Authentication method.

I am using the dbo schema.
If I right-click on the database and select "properties", my username is listed as the owner. 
Under Security - Logins - Server Roles - my username has the sysadmin role.

I feel like I have read everything ESRI has put out about this, but I am missing something. Any thoughts?

George_Thompson · Answer

Is the database that you are connected to a Geodatabase (i.e. you ran the create or enable Enterprise Geodatabase tools)?

How was the data added to the SQL DB?

I am also curious as to why SQL Server Express?

AnnaGSanchez_0-1716949670051.png

StevenMaberry · Answer

I do not get an error. But when I right-click on the table in ArcGIS Pro and click permissions, it says I am not the data owner. I am signed in through windows authentication using the one user I have set up on this localhost SQL database. So as the dbo, I should have all of the required permissions, right? I am not sure what else I need to do.

George_Thompson · Answer

DBO is a data owner. Are you getting an error with something?

Are you trying to have data owned by another user other than DBO?

Here are the permissions needed to be a data owner in SQL Server; Privileges for geodatabases in SQL Server—Manage geodatabases in SQL Server | Documentation

Data creator

* CREATE TABLE
* CREATE PROCEDURE
* CREATE VIEW

Users who create data must have a default schema with the same name as their database user name. For example, for the user name simon, the default schema name must be simon. If it isn't, the user cannot create objects such as feature classes.