1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to create logins using windows Authentication mode?

Question Posted / hari

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

What is named query? : sql server analysis services, ssas

0 Answers  

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

Explain the dirty pages?

0 Answers  

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

What is data block and how to define data block size?

0 Answers  




What is the maximum size of sql server database?

0 Answers  

Describe how to use linked server?

0 Answers  

What is the difference between an index and a unique index?

0 Answers  

what is checksum in sql server.........???

0 Answers   TCS,

How to insert multiple rows with one insert statement in ms sql server?

0 Answers  

How do I create a stored procedure in sql server?

0 Answers  

What do you understand by a stored procedure?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories