SQL Server 2008 x64 SSMS Local Instance.. Failed Trusted Login
Posted on 2010-01-04
I have an odd issue. We recently built out a new database server on Windows 2008 R2 x64 and installed SQL Server 2008 x64 as well. We added domain admins to the sysadmin group on the SQL Server (appropriate for our enviornment) and I am able to connect to the instance using SQL Server Management Studio from my workstation, however, we are unable to connect to the instances from the local server itself.
It's very odd and I can't put my finger on why this would be happening.
The error I get is "Login failed for user 'MyDomain\MyUserName' (Microsoft SQL Server, Error: 18456)"... and it only happens when I try to make a trusted connection to the instance from the local server console. We are able to connect remotely from other workstations just fine.
Has anyone else seen this?