• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

How to change SQL Server Authentication Mode?

January 13, 2017

SQL Server use two Authentication mode:


 • Windows Authentication mode

         - currently logged user in Operation System is used to connect to Server - if the user has permissions to do so.


 • SQL Server and Windows Authentication mode

         - we can use login that is defined in SQL Server.


We can change the a authentication mode via T-SQL and Managemement Studio .


1) T-SQL


Go to Properties of Instance and click on Security on the left panel. And now you can choose two types of Server Authentication.



2) Managemement Studio



- to change the Windows Authentication mode use this query below:


- to change the SQL Server and Windows Authentication mode use this:


 After the change you have to restart SQL Server and SQL Server Agent!



Please reload

Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon