What are the Authentication Modes in SQL Server? How can it be Changed?
Written by Agetinfence Monday, 09 January 2012 17:33
There are two authentication modes in SQL Server.
- Windows Mode
- Mixed Mode – SQL and Windows
To change authentication mode in SQL Server, go to 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.
| < Prev | Next > |
|---|