RSS

Cannot set a credential for principal ‘sa’. (Microsoft SQL Server, Error:15535)

11 Dec

In this Quick and dirty post, let’s see a simple fix for one of the annoying error messages you’ll see in SQL Server 2005. Basically, You’ll see below mentioned error in few cases when you try to change the sa password using SSMS.

The Simple trick is to check the box “Map to credential” as shown below after providing a new password and click Okay.

This should work…Hope this helps!

APPLIES TO
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
Advertisements
 
4 Comments

Posted by on December 11, 2012 in MSSQL, Tips

 

Tags: , , ,

4 responses to “Cannot set a credential for principal ‘sa’. (Microsoft SQL Server, Error:15535)

  1. Manjeet

    December 18, 2012 at 3:57 pm

    Nice Explanation , It’s Working Fine

     
  2. top hardrives

    April 26, 2013 at 11:24 pm

    Good day! Would you mind if I share your blog with my myspace group?
    There’s a lot of folks that I think would really appreciate your content. Please let me know. Thanks

     
  3. Josue Castillo

    January 15, 2014 at 8:04 pm

    I try disabling and deny access and showed me this message. Probe what you exhibit here and it works perfectly. But … that’s what makes this box “Map to credential”?

     
  4. Sofia Phillips

    April 11, 2014 at 11:45 pm

    Fantastic Piece

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: