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 |
How to create logins using windows Authentication mode?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
How can sql server instances be hidden?
What is a domain constraint give an example?
How important do you consider cursors or while loops for a transactional database?
What is xml datatype?
What is user-defined function?
What is the sql case statement used for? Explain with an example?
Detail about query optimizer?
 Explain what is sql override for a source taLle in a mapping?
Can you type more than one query in the query editor screen at the same time?
How do I view a procedure in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)