What are the Authentication Modes in SQL Server ?
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 Server Management Studio and under Object Explorer, right-click the server, and then click Properties. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.