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 2nf example?
How do triggers work?
What is command parameter in ssrs?
How to check table values in sql server?
Do you know what guidelines should be followed to help minimize deadlocks?
What is scrollable cursor?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What do you mean by 'normalization'?
What program is used to store the data source file?
When is update_statistics command used?
What are the different subsets of sql?
How many triggers are possible per table?
What is normalization? Explain its different types?
What is the difference between left and right outer join?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.