i have installed a windows 2008 r2 server with sql 2008 on it...
the security settigns are: mixed mode (windows authentication + sql server authentication)
on a remote server/client i can start management studio and can logon with windows authentication. (eg. domain admin user)
with the same domain admin user logged on on the SQL server itself, i cannot connect with the sql management studio (windows authentication) ??
if i change to SQL user authentication and enter the SA user everything works fine...
so why cannot i connect with mgmt-studio on the SQL server itself with a windows user?