Stop ArcGIS 'Geodatabase Adminstration' Reporting Connection as 'DBO' Instead of My Username?

Question

We are running ArcGIS 10.5.1 and MS SQL Server, and using an SDE connection file which is configured to use 'Operating System' credentials.

When most users connect, the 'Geodatabase Administration' dialogue shows their Active Directory account correctly. But when I connect using the same connection file, the same dialogue shows the connection username as 'DBO' (the MSSQL database owner user).

Now, I am a privileged user, including a member of the MS SQL 'sysadmin' role, so I'm sure it must be related to this. But shouldn't it show the Windows/AD username that I am connected as?

Why does it show my connection as 'DBO' and not as the account with which I connected?

Here is what the connection properties looks like:

Below is the Geodatabase Administration Dialogue. In this case, the smudged-out username is of the format '"Domain\User.Name"' and this user connected using the same connection file as myself, which it shows as 'DBO'. (The 'GISADMIN' and 'SDE' connections used different connection files.)

Answer 1

It appears to be a 'feature' (or anomaly?) that MS SQL reports the SESSION_USER as 'dbo' for any login that is a member of the 'sysadmin' role.

I found this information on the 'DBA stack exchange' here. To quote:

Each Database has a single User, dbo, that is mapped to a Login. A Login that is mapped to the dbo User will show up as dbo for SESSION_USER when the "current" Database is the DB in question.

AND, Logins in the sysadmin fixed server role ... will show up as dbo in SESSION_USER..

The ArcGIS Geodatabase Administration dialogue must be using SESSION_USER rather than ORIGINAL_LOGIN.

This is annoying for my use case, but at least I now know a bit more about the how and why.