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 are primary keys and foreign keys?
Do you know what are the ways available in sql server to execute sql statements?
Describe and explain about SQL native client?
How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005
How do I view views in sql server?
How you can change a cross join into an inner join?
What is normalization and its forms?
4 Answers Challenger Financial,
When columns are added to existing tables, what do they initially contain?
How to handle error or exception in sql?
How to Get the last identity value used
what is sql injection?
Explain syntax for dropping triggers?