Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can the sde user be dbo or a member of the sysadmin fixed server role on MS SQL Server?

April 26, 2017dbo fixed MS sde server SQL Server sysadmin user

0

Posted

Can the sde user be dbo or a member of the sysadmin fixed server role on MS SQL Server?

1 Answer

0

Posted

ArcSDE 8.0.2 supports the sde user as dbo (database owner). This means that the SDE user can be added to the sysadmin fixed server role, the dbcreator fixed server role (and create the sde database), or any other role that remaps permissions to dbo. NOTE: ArcInfo 8.0.2 does not support the sde user as dbo.