Error Create Database User SQL Server

2033
1
Jump to solution
03-08-2018 04:44 AM
MichelyTavares
New Contributor
I have enterprise database connected SQL Server 2012 R2 to the user sde and default version.

I want to create another user and I can not because he says: Must be connected to database admin / superuser
How to create another user?
How to give sde user permission to create another user?

0 Kudos
1 Solution

Accepted Solutions
George_Thompson
Esri Frequent Contributor

This is in the help documentation: Add logins and users to SQL Server—Help | ArcGIS Desktop 

You must be connected to the database with a login that has sysadmin privileges to the SQL Server instance to run the Create Database User tool

https://community.esri.com/groups/geodatabase?sr=search&searchId=75a376dc-9534-47be-9169-f145cdbadaa...

--- George T.

View solution in original post

1 Reply
George_Thompson
Esri Frequent Contributor

This is in the help documentation: Add logins and users to SQL Server—Help | ArcGIS Desktop 

You must be connected to the database with a login that has sysadmin privileges to the SQL Server instance to run the Create Database User tool

https://community.esri.com/groups/geodatabase?sr=search&searchId=75a376dc-9534-47be-9169-f145cdbadaa...

--- George T.