Hello, folks
I run SQL Management Studio 2012 locally on a server with Windows server 2012 R2 and then connect to sql instance.
1. If I start SQL Management Studio 2012 without "run as administrator" option - I am connecting in a 'guest' context with limited rights
SELECT CURRENT_USER;
returns: guest
query "SELECT SYSTEM_USER" returns my domain account which granted sysadmin permissions
2. If I start SQL Management Studio with "run as administrator" option everything is OK
SELECT CURRENT_USER;
returns: dbo
query "SELECT SYSTEM_USER" returns my domain account which granted sysadmin permissions
And when I connect to sql instance remotely through Management Studio installed on remote server - everything is OK. I still connect in dbo context.
Please let me know why it happens so