What are the authentication modes in SQL Server?
- 4 Answers
- 8516 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
What is the difference between migration and upgradation in sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is report rendering ?
What is the name of reporting services config file and what’s it’s used for?
What is the function of inner join?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
How to apply cascading referential integrity in place of triggers?
Explain the truncate command?
Explain aggregate functions?
How to create a ddl trigger using "create trigger" statements?
How many levels of sp nesting are possible?
What does it mean to normalize a database and why would you do it?
What can be used instead of trigger?
How to define the name and server for a new dsn?
