What are the authentication modes in SQL Server?
Answers were Sorted based on User's Feedback
Answer / guest
there are two authentics in sql server.
1- windows authentics
2- sql authentic
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / rajkumar v
1.Windows authentication
2.Mixed authentication(SQL Server and Windows
authentication mode)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is the need for indexing?
What is a rownum?
what are different types of backups available in sql server? : Sql server database administration
What are different types of database indexes?
What are the different acid properties?
Tell me when is the update_statistics command used?
what kind of lan types do you know? : Sql server database administration
Explain the creation and execution of a user-defined function in the sql server?
What does sql server mean?
How would you add a section to a table?
Explain steps of normalization?
what is the main difference between constraints(like primary key etc..)& joins?