AnsweredAssumed Answered

Should the ArcGIS Server Account be in the sysadmin SQL Server Role?

Question asked by dcortwilsonpud on Aug 4, 2016
Latest reply on Aug 10, 2016 by dcortwilsonpud

ArcGIS Server 10.2.2

SQL Server 2008 R2

DBO owned schema

 

I noticed that our ArcGIS Server account is in the sysadmin server role in our SQL Server 2008.  Does ArcGIS Server place the server account in that role by default?  Seems like too high level of permissions for the server account....

 

I think a problem I am having is stemming from this.  When I block connections to the database from ArcCatalog, the ArcGIS Server account is still able to connect while I'm doing database management tasks and it causes them to fail.

Outcomes