SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1966 Page Views: 

What authentication mechanisms does Microsoft SQL Server support?



Posted By: Avi Date: 15 October 2009 04:43:44 AM
 Answer:

SQL Server supports following two type of authentication mechanisms:

1) Windows Authentication (via Active Directory)

2) SQL Server authentication (via Microsoft SQL Server username and password)


Posted By: eTechPlanet

Date: 15 October 2009 04:43:44 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image tZqRDS
Related Questions
SQL Server : Are "" , 0, NULL one and the same thing in SQL Server?

Are "" , 0, NULL one and the same thing in SQL Server?

No, all the three are treated diffrently. "":- means empty string 0:- represents 0 value N....
Category: SQL Server Date: 10/1/2010 12:20:08 PM
SQL Server : Write a query to select first 20 rows from a table having 100 rows?

Write a query to select first 20 rows from a table having 100 rows?

Select top 20 from table_name or Select * from table_name where count(*) <=20
Category: SQL Server Date: 10/1/2010 12:19:08 PM
SQL Server : What does the DROP Table command do?

What does the DROP Table command do?

DROP command will delete the data as well as destroy the structure of the table. Once applied the ta....
Category: SQL Server Date: 10/1/2010 12:18:08 PM
SQL Server : What is the purpose of INSTEAD OF Trigger in SQL SERVER?

What is the purpose of INSTEAD OF Trigger in SQL SERVER?

INTEAD OF Triggers are the procedures whih are executed in place of a specific DML command which is ....
Category: SQL Server Date: 10/1/2010 12:17:08 PM
SQL Server : Where in SQL server the User names and passwords stored?

Where in SQL server the User names and passwords stored?

In System catalog views.
Category: SQL Server Date: 10/1/2010 12:16:08 PM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories