Cannot set a credential for principal 'sa'. (SQL Server 2005/2008)
- by Scott Whigham on March 23, 2009 6:42 AMSo today I was using SQL Server Management Studio (SSMS) to change my SQL Server’s sa account password (a good routine to do every so often BTW) and I got an unexpected error message:
Msg 15535, Level 16, State 1, Line 1
Cannot set a credential for principal 'sa'.
Whoa! I wasn’t expecting that… So I googled and googled and I couldn’t find anything about SQL Server 2005. I did find a KB article for SQL Server 2008 that mentioned the “fix” - 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. Thankfully I was just on my local development server and, since I don’t even use the “sa” account, I could afford to try this and, if it didn’t work, so what… (Yes, it should be disabled but it isn’t)
When I followed the instructions in the article, it worked perfectly. What’s weird is that I’m on SQL Server 2005, not SQL Server 2008. I am only up to SQL Server 2005 SP3. So I’m wondering if this is a new bug/feature in SQL Server 2005 SP3…
Anyway, for anyone on SQL Server 2005 who gets this Cannot set a credential for principal ‘sa’ error, the fix is easy. Here’s what you see:
Notice the arrow points to the “Map to Credential” checkbox that is unchecked. That’s the problem – it should be checked. I made my changes, clicked “Ok” and that’s when I received the error. Being the industrious little beaver that I am, I then clicked the Script button and tried to run the code:
USE [master]
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[LIFTest], DEFAULT_LANGUAGE=[us_english]
, CHECK_EXPIRATION=OFF, CHECK_POLICY=ON, NO CREDENTIAL
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'JH@46O!IH#NFi349gh'
GO
Same error…………………………..
The fix looks like this:
It’s weird how “Map to Credential” is checked yet there is no credential specified. But that’s what you have to do.
Scott,
Thank you. This thing made my day. Thanks again.
R. Torrone
Thanks mate. This was great help!!!
Thanks... It is a great help
Haha! That's the dumbest thing ever! I wonder why it works like that. Wouldn't have found that answer in a billion years.
Thanks,
-Ben
http://blog.benday.com
Outstanding :), thank's for years saving tip!
Thanks very much, worked like a charm!
Good...thanks to the help rendered
THANKSS MAN! IT HELPED!!!
Thanks very much, it is still helping!
Thanks for sharing! It helps everyone a lot!!
Thanks a lot, it also helps me to solve this headached issue.
I hit that error today after upgrading a server from 2000 to 2005 SP3.
Great catch, Scott, and THANK YOU for a very clear, concise write-up. I hadn't heard of the techurbia site before. This was an excellent introduction to it.
Thank you
Thank you, thank you, thank you. I have been trying to find a fix for this problem for hours and my frustration level was through the roof.
finally found something relevant from bing lol
Even so
I love Microsoft. Thank you.
Someone please email me how to get free xbox live, iv been googleing for secrets for sooo long now please could someone send me truth 6charles3pokemon@hotmail.com !
hmm in some strange way this article reminded me of the good old days when we all used to leave school to play online xbox together hehehe. Thanks for the great memories!!
if u liked dis post, paste this roflcopter to show you care!!!
.......................__ ............
......-ROFL ROFL ROFL ROFL-.
........................| |...........
................... __\||/____......
.\\...............|'-|--| .\\....\.....
..\ \_...........|--|---|..\\ ....\....
../ L \____,/-------\___\___\
.|LOL|-------------O----- ----,\..
..\ L /______,---''-----------, /...
../ /.............\_________ ,/....
.//.............____//___ __\\__/.
Nice Post!!
I am so very pleased to see that there is actually some fantastic content left online. I have gotten so sick of google giving me junk.
I looked forever and FINALLY found a working one at http://www.a9mm.net !!
Hi, good day. Wonderful post. You have gained a new subscriber. Pleasee continue this great work and I look forward to more of your great blog posts.
Your RSS feed doesn't work in my browser (google chrome) how can I fix it?
I dont usually comment, but after reading through so much info I had to say thanks!
Hello. I just needed to tell you that some elements of your web site are tricky to comprehend for me, as I'm color blind. I have problems with protanopia, but there are more sorts of color blindness that will also get difficulties. I can read most of the site Okay, and the areas I have problems with I am able to understand by using a custom browser. In any case, it would be cool if you can bear in mind us color-blind people whilst carrying out the next website re-working. Thanks.
Intimately, the article is actually the best on this valuable topic. I concur with your conclusions and will eagerly look forward to your upcoming updates. Just saying thanks will not just be enough, for the phenomenal lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates. Admirable work and much success in your business dealings!
Intimately, the article is in reality the best on this worthy topic. I agree with your conclusions and will eagerly look forward to your future updates. Just saying thanks will not just be adequate, for the wonderful lucidity in your writing. I will instantly grab your rss feed to stay abreast of any updates. Pleasant work and much success in your business enterprize!
Substantially, the article is actually the greatest on this laudable topic. I fit in with your conclusions and will eagerly look forward to your coming updates. Saying thanks will not just be adequate, for the fantasti c clarity in your writing. I will at once grab your rss feed to stay privy of any updates. Pleasant work and much success in your business dealings!
Intimately, the article is really the greatest on this notable topic. I fit in with your conclusions and will eagerly look forward to your upcoming updates. Just saying thanks will not just be enough, for the wonderful clarity in your writing. I will instantly grab your rss feed to stay informed of any updates. Admirable work and much success in your business efforts!
Considerably, the article is actually the greatest on this precious topic. I concur with your conclusions and will eagerly look forward to your future updates. Just saying thanks will not just be sufficient, for the tremendous lucidity in your writing. I will right away grab your rss feed to stay abreast of any updates. Solid work and much success in your business efforts!
Substantially, the article is really the greatest on this deserving topic. I fit in with your conclusions and will thirstily look forward to your upcoming updates. Saying thanks will not just be adequate, for the fantasti c clarity in your writing. I will instantly grab your rss feed to stay abreast of any updates. Admirable work and much success in your business dealings!
Comfortabl y, the post is actually the best on this valuable topic. I agree with your conclusions and will eagerly look forward to your future updates. Saying thanks will not just be enough, for the fantasti c lucidity in your writing. I will immediately grab your rss feed to stay informed of any updates. Gratifying work and much success in your business dealings!
Well, the article is actually the best on this laudable topic. I concur with your conclusions and will eagerly look forward to your future updates. Saying thanks will not just be enough, for the phenomenal clarity in your writing. I will instantly grab your rss feed to stay abreast of any updates. Admirable work and much success in your business endeavors!
Considerably, the article is actually the sweetest on this noteworthy topic. I harmonise with your conclusions and will thirstily look forward to your upcoming updates. Just saying thanks will not just be enough, for the wonderful lucidity in your writing. I will right away grab your rss feed to stay privy of any updates. Solid work and much success in your business enterprize!
Intimately, the post is in reality the best on this laudable topic. I harmonise with your conclusions and will thirstily look forward to your upcoming updates. Just saying thanks will not just be adequate, for the phenomenal clarity in your writing. I will at once grab your rss feed to stay abreast of any updates. Authentic work and much success in your business enterprize!
Considerably, the post is really the freshest on this worthy topic. I agree with your conclusions and will thirstily look forward to your incoming updates. Just saying thanks will not just be enough, for the fantasti c lucidity in your writing. I will right away grab your rss feed to stay abreast of any updates. Solid work and much success in your business enterprize!
Easily, the article is really the greatest on this valuable topic. I harmonise with your conclusions and will eagerly look forward to your upcoming updates. Just saying thanks will not just be enough, for the great clarity in your writing. I will instantly grab your rss feed to stay informed of any updates. Fabulous work and much success in your business enterprize!
Comfortabl y, the post is really the freshest on this worthw hile topic. I concur with your conclusions and will thirstily look forward to your upcoming updates. Saying thanks will not just be enough, for the exceptional lucidity in your writing. I will instantly grab your rss feed to stay abreast of any updates. Good work and much success in your business efforts!
Comfortabl y, the article is actually the greatest on this notable topic. I agree with your conclusions and will thirstily look forward to your future updates. Saying thanks will not just be adequate, for the great lucidity in your writing. I will instantly grab your rss feed to stay privy of any updates. Good work and much success in your business dealings!
Substantially, the post is in reality the best on this notable topic. I concur with your conclusions and will eagerly look forward to your approaching updates. Saying thanks will not just be enough, for the extraordinary lucidity in your writing. I will right away grab your rss feed to stay abreast of any updates. Genuine work and much success in your business dealings!
Well, the post is really the greatest on this worthw hile topic. I concur with your conclusions and will thirstily look forward to your coming updates. Saying thanks will not just be adequate, for the great lucidity in your writing. I will right away grab your rss feed to stay privy of any updates. Solid work and much success in your business dealings!
Easily, the article is in reality the sweetest on this valuable topic. I agree with your conclusions and will eagerly look forward to your approaching updates. Saying thanks will not just be enough, for the wonderful clarity in your writing. I will directly grab your rss feed to stay abreast of any updates. Authentic work and much success in your business dealings!
Comfortabl y, the post is in reality the greatest on this worthw hile topic. I fit in with your conclusions and will eagerly look forward to your next updates. Just saying thanks will not just be adequate, for the exceptional clarity in your writing. I will instantly grab your rss feed to stay informed of any updates. Admirable work and much success in your business dealings!
Easily, the article is actually the best on this deserving topic. I agree with your conclusions and will thirstily look forward to your incoming updates. Just saying thanks will not just be enough, for the tremendous lucidity in your writing. I will right away grab your rss feed to stay informed of any updates. Fabulous work and much success in your business enterprize!
Considerably, the article is in reality the greatest on this noteworthy topic. I agree with your conclusions and will eagerly look forward to your coming updates. Just saying thanks will not just be enough, for the fantasti c clarity in your writing. I will at once grab your rss feed to stay privy of any updates. Pleasant work and much success in your business dealings!
I really enjoyed reading your post and I have changed the way I think because of it.
Easily, the article is really the greatest on this noteworthy topic. I concur with your conclusions and will eagerly look forward to your upcoming updates. Just saying thanks will not just be enough, for the extraordinary clarity in your writing. I will at once grab your rss feed to stay abreast of any updates. Solid work and much success in your business endeavors!
Well, the post is actually the sweetest on this worthy topic. I harmonise with your conclusions and will thirstily look forward to your forthcoming updates. Saying thanks will not just be adequate, for the extraordinary lucidity in your writing. I will immediately grab your rss feed to stay privy of any updates. Gratifying work and much success in your business dealings!
Well, the post is actually the best on this worthy topic. I harmonise with your conclusions and will eagerly look forward to your approaching updates. Just saying thanks will not just be adequate, for the wonderful lucidity in your writing. I will directly grab your rss feed to stay abreast of any updates. Pleasant work and much success in your business endeavors!
Considerably, the post is in reality the greatest on this deserving topic. I harmonise with your conclusions and will thirstily look forward to your approaching updates. Saying thanks will not just be sufficient, for the extraordinary clarity in your writing. I will directly grab your rss feed to stay privy of any updates. Admirable work and much success in your business dealings!
Considerably, the article is actually the freshest on this deserving topic. I concur with your conclusions and will eagerly look forward to your next updates. Saying thanks will not just be sufficient, for the exceptional lucidity in your writing. I will directly grab your rss feed to stay abreast of any updates. Solid work and much success in your business enterprize!
Comfortabl y, the post is actually the sweetest on this deserving topic. I harmonise with your conclusions and will thirstily look forward to your forthcoming updates. Saying thanks will not just be sufficient, for the exceptional lucidity in your writing. I will at once grab your rss feed to stay abreast of any updates. Admirable work and much success in your business efforts!
Easily, the post is in reality the best on this noteworthy topic. I fit in with your conclusions and will eagerly look forward to your incoming updates. Saying thanks will not just be adequate, for the phenomenal lucidity in your writing. I will at once grab your rss feed to stay abreast of any updates. Solid work and much success in your business endeavors!
Considerably, the article is really the greatest on this valuable topic. I agree with your conclusions and will thirstily look forward to your forthcoming updates. Saying thanks will not just be enough, for the fantasti c clarity in your writing. I will directly grab your rss feed to stay informed of any updates. De lightful work and much success in your business endeavors!
Substantially, the post is really the best on this worthy topic. I harmonise with your conclusions and will thirstily look forward to your next updates. Just saying thanks will not just be adequate, for the phenomenal clarity in your writing. I will immediately grab your rss feed to stay informed of any updates. Genuine work and much success in your business efforts!
Intimately, the post is in reality the freshest on this valuable topic. I concur with your conclusions and will eagerly look forward to your approaching updates. Just saying thanks will not just be adequate, for the phenomenal lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates. Fabulous work and much success in your business dealings!
Comfortabl y, the post is really the best on this deserving topic. I harmonise with your conclusions and will thirstily look forward to your next updates. Just saying thanks will not just be adequate, for the great clarity in your writing. I will at once grab your rss feed to stay informed of any updates. Admirable work and much success in your business endeavors!
Considerably, the article is really the freshest on this noteworthy topic. I harmonise with your conclusions and will eagerly look forward to your approaching updates. Saying thanks will not just be adequate, for the wonderful clarity in your writing. I will directly grab your rss feed to stay privy of any updates. Solid work and much success in your business enterprize!
Considerably, the post is actually the sweetest on this notable topic. I harmonise with your conclusions and will eagerly look forward to your incoming updates. Saying thanks will not just be adequate, for the exceptional lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates. De lightful work and much success in your business dealings!
Comfortabl y, the post is actually the sweetest on this worthy topic. I agree with your conclusions and will eagerly look forward to your coming updates. Saying thanks will not just be enough, for the fantasti c lucidity in your writing. I will immediately grab your rss feed to stay informed of any updates. Fabulous work and much success in your business endeavors!
Easily, the post is really the freshest on this worthy topic. I concur with your conclusions and will eagerly look forward to your forthcoming updates. Saying thanks will not just be sufficient, for the extraordinary lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates. Pleasant work and much success in your business efforts!
Well, the article is in reality the greatest on this deserving topic. I concur with your conclusions and will eagerly look forward to your future updates. Saying thanks will not just be enough, for the extraordinary lucidity in your writing. I will immediately grab your rss feed to stay privy of any updates. Good work and much success in your business efforts!
Considerably, the post is really the sweetest on this worthw hile topic. I agree with your conclusions and will thirstily look forward to your forthcoming updates. Just saying thanks will not just be adequate, for the fantasti c lucidity in your writing. I will right away grab your rss feed to stay abreast of any updates. Fabulous work and much success in your business dealings!
Considerably, the post is actually the best on this laudable topic. I fit in with your conclusions and will thirstily look forward to your incoming updates. Just saying thanks will not just be enough, for the great lucidity in your writing. I will directly grab your rss feed to stay informed of any updates. Admirable work and much success in your business efforts!
Intimately, the post is in reality the greatest on this valuable topic. I harmonise with your conclusions and will eagerly look forward to your coming updates. Saying thanks will not just be adequate, for the wonderful lucidity in your writing. I will immediately grab your rss feed to stay informed of any updates. Pleasant work and much success in your business endeavors!
Comfortabl y, the article is really the freshest on this deserving topic. I harmonise with your conclusions and will eagerly look forward to your incoming updates. Just saying thanks will not just be enough, for the fantasti c lucidity in your writing. I will instantly grab your rss feed to stay abreast of any updates. Pleasant work and much success in your business enterprize!
Comfortabl y, the post is really the greatest on this precious topic. I harmonise with your conclusions and will eagerly look forward to your coming updates. Saying thanks will not just be enough, for the tremendous lucidity in your writing. I will instantly grab your rss feed to stay privy of any updates. Admirable work and much success in your business endeavors!
Intimately, the post is actually the sweetest on this precious topic. I harmonise with your conclusions and will eagerly look forward to your forthcoming updates. Saying thanks will not just be sufficient, for the exceptional clarity in your writing. I will right away grab your rss feed to stay informed of any updates. Good work and much success in your business efforts!
I must say your site is really interesting I truely think the content, its amazing!. I’m strapped for time right now to completely browse your blog but I have saved the location of it and also subscribed for your RSS feeds. I will be back in a day or two. Thank you for a excellent site.
Thank a lot scott. I try to fix for a long time.
You're good man.
After reading this article, I feel that I need more info. Could you suggest some resources please?