[Last Call] Learn how to a build a cloud-first strategyRegister Now


SQL Server 2008 x64 SSMS Local Instance.. Failed Trusted Login

Posted on 2010-01-04
Medium Priority
Last Modified: 2012-05-08

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?
Question by:Lweighall
LVL 14

Accepted Solution

Emes earned 1000 total points
ID: 26172940
can you log on as the SA account?

It seem that the current user on the server is not set up with the SQL Server.

Author Comment

ID: 26173133
Hrm. So I was able to log in with the SA account. Our user accounts were setup in the form of a nested group ACL (The Domain Admins group was added to the SQL Server).

Once I specifically added my own user account in AD it started to work. Very odd that it would allow me to connect remotely from another workstation, but not locally.

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question