What are the authentication modes in SQL Server?
- 4 Answers
- 8004 Views
- IBM, iSmart, I also Faced
- E-Mail Answers
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
Explain about temporary stored procedure?
Explain about thread and memory management process of SQL?
What is the use of nvl work?
How to set database to be read_only in ms sql server?
Can we call future method from trigger?
List out the differences between the clustered index and non-clustered index in sql server?
Explain syntax for dropping triggers?
Write a SQL query to delete a table?
Explain the cursor lock types?
Can we perform backup restore operation on tempdb? : sql server database administration
What is primary key and example?
Explain what are magic tables in sql server?
What is efficiency data?
How to insert stored procedure result into temporary table?
What is a functions and types in sql server?
