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
Raffye Memon's Blog 
Manjeet
December 18, 2012 at 3:57 pm
Nice Explanation , It’s Working Fine
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
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”?
Sofia Phillips
April 11, 2014 at 11:45 pm
Fantastic Piece