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

Selet all the data from table where last name is n of employee

2 Answers  


Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  


What is Dependency Injection and provide example?

0 Answers  


What is replace and stuff function in sql server?

0 Answers  


1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,






What are various aggregate functions that are available?

0 Answers  


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

0 Answers  


What are views used for?

0 Answers  


How to use values from other tables in update statements in ms sql server?

0 Answers  


What are the advantages of using third-party tools?

0 Answers  


Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,


what are user defined datatypes and when you should go for them? : Sql server database administration

0 Answers  


Categories