Interested to Buy Any Domain ? << Click Here >> for more details...
What are the authentication modes in SQL Server?
- 4 Answers
- 9566 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 what are the basic functions for master, msdb, model, tempdb databases?
What is log in sql server?
How can we check the sql server version?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How to declare a cursor with "declare ... Cursor" in ms sql server?
What do you think of this implementation? Can this be implemented better?
What are the differences between char and nchar in ms sql server?
What are the different authentication modes in sql server? How can it be changed?
Do you know what are the properties of the relational tables?
Which language is supported by sql server?
How to test subquery results with the exists operator?
Why I am getting this error when renaming a database in ms sql server?
Can we perform backup restore operation on tempdb? : sql server database administration
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What is the difference in accessing db between sql server vs sql azure?
