Wednesday, June 5, 2013

Error Alter failed for Login sa

Alter failed for Login sa. Cannot set a credential for principal 'sa'. - Error encountered in SQL Server

Recently when i worked with SQL Server security, i encountered with one error while trying to modify 'SA' account properties. The exception details looks following,
Alter failed for Login sa. Cannot set a credential for principal 'sa'.
Also you can see the image below for the same.


The fix for the error is the option "Map to Credential" is checked in the "General" tab of the Login Properties Page as mentioned below,