Windows authentication

Question

Hi 

I need to connect the SQL server with windows authentication (Domain)..When i am adding users to SQl the following error occurred..

The error is:

         1.an exception occurred while executing a transact-sql statement or batch

 2.windows nt user or group 'domain user' not found. check the name again

Please help on this  

---

T.Ram

Answer 1

server on which you are working is in Domain or work group

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

What does it mean "adding users to SQL"? Are you issuing CREATE USER....?

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 3

Yes, When im going to create windows authentication user this error occurred .

---

T.Ram

Answer 4

Does the login have the below permissions?

http://technet.microsoft.com/en-us/library/ms173463.aspx

Permissions

Requires ALTER ANY USER permission on the database.

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 5

Yes, When im going to create windows authentication user this error occurred .

---

T.Ram

Hi T.Ram,

Please try to use the following script to create a login from windows domain accout:

CREATE LOGIN [DomainName\UserAccount] FROM WINDOWS;
GO

Please ensure "[DomainName\UserAccount]" is a vaild domain account. Furthermore, please also take a look at the article below:
How to troubleshoot error 15401: http://support.microsoft.com/kb/324321/en-us

Regards,

---

Elvis Long
TechNet Community Support