Your Ad Here

May 15, 2008

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

Windows mode and mixed mode (SQL & 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.

1 comment:

masterofthe said...

I'm glad I cam across your blog while looking for some information on SQL backup.

Sometimes short details lead to more bigger answers and I thank you for this one.