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
What do you mean by subquery?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is the difference between functions and scalar functions?
What do you think of this implementation? Can this be implemented better?
What do you mean by cardinality?
What is page-level compression?
What is the purpose of update statistics and scope_identity() function?
What is replace and stuff function in sql server?
What are secondary xml indexes?
what data regions are and what are the different data regions?
What are dml triggers and types of dml triggers?
What are the differences between stored procedure and the dynamic sql?
what is raid and what are different types of raid configurations? : Sql server database administration
What is store procedure? How do they work?