Why we cannot add one domain account login into the Logins of an SQL server?

Posted on 2006-04-04
Last Modified: 2012-06-27

We're trying to add one new user into an SQL Server by doing the following steps:

-- Access the SQL server --> Start the SQL Enterprise Manager --> Microsoft SQL Servers
-- SQL Server Groups --> (local) (Windows NT) --> Security --> Right click on “Logins” --> Select “New Login”
-- Under Authentication --> Check “Windows Authentication”, Select the domain, enter the domain login userID for name
-- Click OK --> ERROR: “Windows NT user or group “<domain>\<user domain login id>” not found” appears

The problem is that the adding only failed for one person (domain login account); we can easily add other people into the "Logins" group of the SQL Serve. It is strange that if we click on "Browse" to manually browse the domain account loginid of this person, we can find the login ID in the list of the domain login account that the system can see.

If you have some idea about what can casue this problem, please help.

Thanks a lot,

Question by:somits
    LVL 142

    Accepted Solution

    This process only works if you are logged on to the local NT machine with domain account. if you are logged on locally to the computer, you will see that error (also)

    Now, as you seem to be able to browse to the login, you are connected to the domain, hence the above is not the problem.
    is there anything special about the name (special characters, length...) or it's permissions?
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    Also check whether that login is associated with a trusted connection.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    746 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