Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Error 15401

Author  Topic 

Hinduson
Yak Posting Veteran

69 Posts

Posted - 2014-11-02 : 02:18:33
Please I need help on how to solve this problem . Below is the syntax and I get this error message when i execute.

CREATE LOGIN [computer_name\Mary]
FROM WINDOWS
WITH DEFAULT_DATABASE = [TestData];
GO

Msg 15401, Level 16, State 1, Line 2
Windows NT user or group 'computer_name\mbabe' not found. Check the name again.

Best Regards.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-03 : 12:26:38
This isn't a syntax error. This is a problem with the database server not being able to find that Windows account.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -