How to enable mixed mode login for sa account and Windows account login in SQL Server?

andy - 10 Jan, 2014 2657 Views 0 Comment

You may forgot to enable the Mixed Mode and SQL Server and Windows Authentication Mode Authentication in SQL Server when installing SQL Management Studio. To enable it is pretty easy, you just need to follow up our quick tips.

Firstly, login to your sql server, using the built in local login. Once login, right click the server icon and choose properties.

sql server properties

Select the Security section and choose the Mixed Mode / SQL Server and Windows Authentication Mode option and click OK.

sql server windows authentication mode

Then go to Security > Logins, right click the SA account.

sa login properties

Set the new password and click OK.

Note: the SA account is probably disabled, in order to use it, you have to enable it. You can run the following scripts.


There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.

Related Articles

How to restore database using SQL query in TSQL?

If you have a database backup bak file extension and want to restore it using SQL query You can use the built in RESTORE DATABASE function Remember in order to be able to restore a database successfully You need to ...

How to get all table sizes in TSQL?

To get the information about how much space or size used by tables You can retrieve the size information by linking multiple tables in sys tables There are two tables that hold this information The first one is the sys ...