How to create logins using windows Authentication mode?

Question Posted / hari

2 Answers
4793 Views
I also Faced
E-Mail Answers

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

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers

what is difference between primary key and Unique

8 Answers

Explain system views?

0 Answers

Find columns used in stored procedure?

0 Answers

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers MCN Solutions,

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers

How to store pdf file in sql server?

1 Answers CarrizalSoft Technologies, College School Exams Tests, TATA,

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers

What is the datatype returned by count(*)

22 Answers 247Customer, Asian CERC,

What is bcp? When does it used?

0 Answers

What is tempdb database? : SQL Server Architecture

0 Answers

Explain active/passive and active/active cluster configurations?

0 Answers

For more SQL Server Interview Questions Click Here