AnsweredAssumed Answered

Remap DBO Username to a Different Login in SQL Server

Question asked by Lcaraway34_1 on Mar 29, 2018
Latest reply on Mar 29, 2018 by rastrauch

Hello,

It is important to note that we need to use windows authentication to manage security for our sql servers. I created the enterprise geodatabase and thus it mapped me to the database user dbo. However, I have a GIS Admin group that i need to be mapped as dbo rather than me. I have made them db_owners however this does not function as it should when creating, editing, and versioning data from inside ArcMap. Has something to do with users names must be the same as the scheme for certain things. 

 

I have tried everything i can think of but the system will not let me alter the user dbo nor delete my user and resign because of dependencies. Without starting over, is their a way I can change the mapping to the group server login. 

Outcomes