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 the different components in replication and what is their use?
What is local temp table?
What are the components of sql server service broker?
How to delete duplicate rows?
role of sql sever 2005 in database rather than any other database
What guidelines should be followed to help minimize deadlocks?
What is log cache in sql server?
Can you explain what are commit and rollback in sql?
What command would you use to create an index?
What is the difference between the application object and session object?
What is the purpose of the tempdb database?
Define model database?