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 is bit datatype and what's the information that can be stored inside a bit column?
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
Explain about builtinadministrator?
How many levels of sp nesting are possible?
How to count rows with the count(*) function in ms sql server?
What are Spatial data types in SQL Server 2008
Is null vs coalesce?
How do I view views in sql server?
How to find the second highest salary of an employee?
how to find 6th highest salary
Why I am getting this error when dropping a database in ms sql server?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
0 Answers HPCL, Hughes Systique Corporation,
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)