I have 'control server' permission in SQL Server 2012,
Currently I am trying to assign 'sa' a password in order to log in as 'sa' when there is a need.
Using SQL Server Management Studio I click on security > log in and right click sa > properties,
select the general tab and set the password and confirm it after unchecking the 'enforce password policy' box.
I then click OK and everything seem to be in working fine (no error messages) but when I try to log in with the newly assigned password the log in fails.
Can you help? Thank you