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.
The screenshot below shows that the database is not accepting connections but the arcgis server account (GIS client machine) is still able to connect.