When I installed SQL Server 2017 Standard I installed it under my domain account and added it to the sysadmin role. I have then added the Domain Admins AD group to SQL and have deleted my domain account from SQL Server.
Now when I try to login my login fails with error 18456. All other accounts of the Domain Admins group are able to login.
I ran the following query and it says my domain account is type= user
, privilege= admin
, mapped login name=domain account
and permissions path=DOMAIN\Domain Admins
Exec xp_logininfo 'DOMAIN\USERACCOUNT', 'all'
Looking at the server logs it says:
Reason: Token-based server access validation failed with an infrastructure error. Login lacks Connect SQL permission. [CLIENT: <local machine>]