Cannot set a credential for principal 'sa'

Posted by hailey on Geeks with Blogs See other posts from Geeks with Blogs or by hailey
Published on Mon, 07 Mar 2011 19:19:21 GMT Indexed on 2011/03/08 0:11 UTC
Read the original article Hit count: 487

Filed under:

I was trying to change the SA password on my development server this morning and got an error.

Msg 15535, Level 16, State 1, Line 1

Cannot set a credential for principal 'sa'.

It was a little frustrating to get an error for a seemingly simple task but then agian maybe I screwed something up.  After doing a couple of searches i found a Microsoft KB (support.microsoft.com/kb/956177) "You receive an exception in SQL Server 2008 when you try to modify the properties of the SQL Server Administrator account by using SQL Server Management Studio".  It was for SQL 2008 but it worked for my SQL 2005 sp3 server just fine.  You have to click the Map to Credential check box but you don't have to add any credetials just click the OK button to complete and that's it.

 

© Geeks with Blogs or respective owner