| Different authentication modes in SQL Server and how can we changed it?
There are basically 2 modes of authentication in SQL Server
(1)Windows mode
(2)Mixed Mode
Below are the 3 different steps to change authentication mode in SQL Server:
(1)(i)Click Start
(ii) Then select Programs
(iii)After that select Microsoft SQL Server
(iv)Click SQL Enterprise Manager to run SQL Enterprise Manager from the Microsoft SQL Server program group.
(2)Then select the server from the Tools menu.
(3)Select SQL Server Configuration Properties, and choose the Security page. | | |