Explain what are the authentication modes in sql server?
- 1 Answers
- 1125 Views
- I also Faced
- E-Mail Answers
Answer Posted / Bhupendra
SQL Server supports two main authentication modes: SQL Server Authentication and Windows Authentication.
1. SQL Server Authentication: This mode uses SQL Server login accounts for authentication. The usernames and passwords are stored encrypted in the SQL Server database.
2. Windows Authentication: This mode relies on Active Directory or a standalone Windows account for authentication. With this method, the user is authenticated against the local machine or domain.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert character strings into numeric values?
How can we solve concurrency problems?
What are the kinds of subquery?
What is self contained sub query?
How do I start sql server 2017?
How to remove duplicate rows from table except one?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is acid mean in sql server?
Where can you add custom error messages to sql server?
What is temporary table in sql server? Why we use temp table?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Why use identity in sql server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are the properties of the transaction?
Can one drop a column from a table?
