what are the authentication modes in sql server? : Sql dba



what are the authentication modes in sql server? : Sql dba..

Answer / Shyamu Kumar

In SQL Server, there are several authentication modes available for connecting to a database. Here are some common ones:n
1. Windows Authentication:nThis mode uses Active Directory or domain accounts to authenticate users.n
2. Mixed Mode:nMixed Mode combines both Windows Authentication and SQL Server Authentication (SQL Auth) for backward compatibility.n
3. SQL Server Authentication:nSQL Auth requires creating individual login credentials for each user within the database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are different types of joins ?

5 Answers   BirlaSoft,


How packaged procedures and functions are called from the following?

2 Answers  


what are the drivers in mysql? : Sql dba

1 Answers  


What is schema in sql example?

1 Answers  


What is a Procedure ?

3 Answers  


How to find the count of letter "L" in HELLO

7 Answers   HP,


What operating systems are supported by oracle sql developer?

1 Answers  


What are instead of triggers?

1 Answers  


How can the performance of a trigger be improved?

1 Answers  


What is Materialized View? In What Scenario we Use Materialized View?

3 Answers   Dinesh, Marlabs,


What is the purpose of a secondary key?

1 Answers  


What is the default isolation level in sql server? : Transact sql

1 Answers  


Categories