Friday, June 18, 2010

SQL Error:Alter failed for Login 'sa'.

Error: Alter failed for Login 'sa'.

When you want to change your sa login property in sql server, it could not allow you to change with this messge "Alter failed for Login 'sa'".

Solution: If you change anything in 'sa' Login property then you should mark 'Map to Credential' field in General tab before you click OK.