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 different types of replication in sql server?
Call by value and call by reference in procedure and function, with NOCOPY.
DIFFERENCE BETWEEN SQL SERVER 2005 and 2008
query processing
What is the Main Difference between ACCESS and SQL SERVER?
How to change the password of a login name in ms sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is the main purpose of having conversation group?
What do you know about system database? : SQL Server Architecture
Explain what are page splits? : SQL Server Architecture
What is blocking?
How to call stored procedure using http soap?
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)