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

Posted on 2010-01-04
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

    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

    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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now