Geeks With Blogs
Jason Hailey
| Home |

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.

 

Posted on Monday, March 7, 2011 7:19 AM | Back to top


Comments on this post: Cannot set a credential for principal 'sa'

# re: Cannot set a credential for principal 'sa'
Requesting Gravatar...
This is truly one of the posts that really helps you with your issues. I have a hard time copying config files because of the time it takes to complete the job. Hopefully, this will answer all my queries and take the monkey off my back. - Dr. Paul Perito
Left by Dr. Paul perito on Feb 20, 2012 12:05 PM

Your comment:
 (will show your gravatar)


Copyright © hailey | Powered by: GeeksWithBlogs.net