What are the authentication modes in SQL Server? How can it be changed?

What are the authentication modes in SQL Server? How can it be changed?

Mainly Two modes are the Authentication Modes in SQL Server they are following as : 
Windows mode and Mixed Mode : SQL And Windows.
Process of change the Authentication Mode in SQL Server :  To change authentication mode in SQL Server click Start > Programs >  Microsoft SQL Server >  click SQL Enterprise Manager .
        When the open the Window of SWL Enterprise Manager it means it start to run from the Microsoft SQL Server program group. Now Select the server then going to Tools menu > select SQL Server Configuration Properties, and choose the Security page.

By:UMANG
Date:2010-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher