We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

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

somits
somits asked
on
Medium Priority
169 Views
Last Modified: 2012-06-27
Hi:

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,

Somits
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
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?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
Also check whether that login is associated with a trusted connection.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.