What are the authentication modes in SQL Server?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the types of indexes.
Explain the difference between cross join and full outer join?
What is the default schema of your login session in ms sql server?
What is the query and subquery?
What is pessimistic concurrency?
What is @@error in sql?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is subquery? Explain the properties of a subquery?
What is difference between order by and group by?
What is an indexed view?
Define union, union all, minus, intersect?
Which tcp/ip port does the sql server run on? How can it be changed?
Will the writetext statement activate a trigger?
What command would you use to create an index?
What is page in sql server?