How to Change Windows authentication to Mixed mode in MSSQL

The easiest method is using SQL Server Management Studio Express.

The supported method is to use SQL Server Management Studio Express.
Download it from the web at

1. Then connect to your server.
2. In Object Explorer, right-click the server, and then click Properties.
3. On the Security page, select SQL Server and Windows Authentication mode.
4. Restart the SQL Server service.

Please follow and like us:
About shk

shk is a DevOps engineer with more than 12 years of experience in different organizations. He enthusiastic about learning new technologies and shares his knowledge through his blogs.


  1. thanks a lot man

    have a Great day

Comment Policy:

Your words are your own, so be nice and helpful if you can. Please, only use your real name, not your business name or keywords. Using business name or keywords instead of your real name will lead to the comment being deleted. Anonymous commenting is not allowed either. Limit the amount of links submitted in your comment. We accept clean XHTML in comments, but don't overdo it please.

Tell us what you're thinking...

All comments are moderated.

* Denotes required field.



Previous Post:
Next Post: