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

Posted by

To view Verified answers click on the button below.

Windows mode and Mixed Mode – SQL and Windows.

To change authentication mode in
SQL Server click Start, Programs, Microsoft SQL Server and click SQL Enterprise Manager to
run SQL Enterprise Manager from the Microsoft SQL Server program group. Select the
server then from the Tools menu select SQL Server Configuration Properties, and choose
the Security page.