Sql-server – Cannot log in using SA with SQL Authentication

authenticationloginsSecuritysql serversql-server-2008-r2

I can not log in to SQL Server 2008 using SQL Server authentication.

I can only log in using Windows Authentication Mode.

I chose only defaults while installing SQL Server 2008 R2.

Best Answer

Did you look anywhere? Right-click the server and choose Properties, then select the Security screen.

enter image description here

Then, log in using your Windows auth admin account, and set the password for the sa SQL auth account.

ALTER LOGIN sa WITH PASSWORD = 'strong password here';