Search

Showing posts with label Alter failed for Login sa. Cannot set a credential for principal 'sa'.. Show all posts
Showing posts with label Alter failed for Login sa. Cannot set a credential for principal 'sa'.. Show all posts

Monday, June 4, 2012

Alter failed for Login sa. Cannot set a credential for principal 'sa'.

Some days ago when i was working with SQL Server security, I got an 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'.

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