What are the authentication modes in SQL Server?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what is xpath?

559


What is the usage of the sign function?

532


How to list all user defined functions in the current database?

518


How to verify the port number of the sql server?

561


What is partition index in sql server?

610






What is the difference between a "where" clause and a "having" clause?

623


What are the new features of sql server 2012 reporting service?

84


how can you check the level of fragmentation on a table? : Sql server administration

542


What is user-defined inline table-valued function?

519


What are data driven subscriptions?

79


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

674


what is datawarehouse?

651


What are the types of database schema? : sql server analysis services, ssas

601


You want to implement the many-to-many relationship while designing tables. How would you do it?

566


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1516