How to create logins using windows Authentication mode?

Answers were Sorted based on User's Feedback



How to create logins using windows Authentication mode?..

Answer / ram suresh.l

While u create a user login in enterprise manager,u will be
given an option of creating the user with windows
authentication/SQL server authhentication mode.
You can choose the appropriate one

Is This Answer Correct ?    5 Yes 2 No

How to create logins using windows Authentication mode?..

Answer / madan

sp_grantlogin'Domainname\loginname'

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  


what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,


What is the difference between local and global temporary tables?

0 Answers  


Difference between 2NF &3NF ?

0 Answers   Cap Gemini,


What is isnull() operator?

0 Answers  






According to you what goes into making the best database administrator? : sql server database administration

0 Answers  


Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,


Tell me what is the order in which the sql query is executed?

0 Answers  


What is sql server english query?

0 Answers  


Does sql server use t sql?

0 Answers  


what are the advanced features in sql 2008?

2 Answers   Wipro,


What is Data model and how to prepare a data model.?

1 Answers   TCS,


Categories