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 is msdb database? : SQL Server Architecture
Why use “in” clause in sql server?
We need to perform what steps in the following order to work with a cursor?
Mention what are the different types of ssrs reports?
How can you find out how many rows returned in a cursor?
Explain different forms of normalization?
What are different types of replication in sql server?
What is subquery explain with example?
Can you explain different types of joins?
What is in place upgrade in sql server?
What are the disadvantages of using the stored procedures?
How to assign null values to variables or columns?
When we should use and scope of @@identity?
Explain what is the use of custom fields in report?
Explain differences between web edition and business edition?