What are the authentication modes in SQL Server?

Question Posted / guest

4 Answers
7948 Views
IBM, iSmart, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the authentication modes in SQL Server?..

Answer / guest

Windows mode and mixed mode (SQL & Windows).

Is This Answer Correct ?

7 Yes

1 No

What are the authentication modes in SQL Server?..

Answer / guest

there are two authentics in sql server.
1- windows authentics
2- sql authentic

Is This Answer Correct ?

6 Yes

1 No

What are the authentication modes in SQL Server?..

Answer / rajkumar v

1.Windows authentication
2.Mixed authentication(SQL Server and Windows
authentication mode)

Is This Answer Correct ?

1 Yes

0 No

What are the authentication modes in SQL Server?..

Answer / dupinder singh

SQL Server 2008 offers two authentication mode options:

Windows authentication mode requires users to provide a
valid Windows username and password to access the database
server. In enterprise environments, these credentials are
normally Active Directory domain credentials.

Mixed authentication mode allows the use of Windows
credentials but supplements them with local SQL Server user
accounts that the administrator may create and maintain
within SQL Server.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer