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 |
Define outer join?
How do I port a number to sql server?
Is a primary key unique?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Explain try...catch with sql server?
Which command is used for user defined error messages?
How can you insert null values in a column while inserting the data?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is factless fact table? : sql server analysis services, ssas
What is a Lock and let me know Different types of locks?
How can I know what locks are running on which resource?
What is the difference between migration and upgradation 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)