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,


  1. Hi would you mind sharing which blog platform you're working with? I'm looking to start my own blog in the
    near future but I'm having a difficult time choosing between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I'm looking
    for something unique. P.S My apologies for
    getting off-topic but
    I had to ask!

    My web-site ... accredited paralegal programs ()

  2. Greetings from California!

    I'm bored at work so I decided to browse your site on my iphone during lunch break. I really like the info you provide here and can't wait to
    take a look when I get home. I'm shocked at how fast your blog loaded on my cell phone .. I'm not even
    using WIFI, just 3G .. Anyhow, amazing site!

    Also visit my web blog - home sale records ()

  3. eхcellent ρоintѕ altogetheг, you juѕt ωοn a
    logo nеw rеader. What might уou suggest in regarԁs to your put uр that you made ѕome dауѕ agо?
    Any posіtiѵe?

    Μy web blog - Frederіckcomputeг.com (

  4. Intriguing ideas you've displayed in this article. Great writing and impressive post.

    Feel free to visit my homepage :: technology ()