Attention: We are retiring the ASP.NET Community Blogs. Learn more >

Alert Cannot set a credential for principal 'sa' .... when trying to modify 'sa' properties through sql management studio 2008..

http://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

 

SYMPTOMS
Consider the following scenario. You use the Microsoft SQL Server 2008 tools to...

Consider the following scenario. You use the Microsoft SQL Server 2008 tools to connect to a server that is running Microsoft SQL Server 2005. You open the properties dialog box for the SQL Server Administrator account, and then you perform an "sa" login by using the SQL Server Management Studio tools. You modify the properties for the "sa" login, and then you click OK. In this scenario, you receive the following error message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Alter failed for Login 'sa'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot set a credential for principal 'sa'. (Microsoft SQL Server, Error: 15535)
------------------------------

CAUSE
This problem occurs if the Map To Credential check box is not selected on the Ge...

This problem occurs if the Map To Credential check box is not selected on the General tab of the Login Properties - sa dialog box. If this check box is not selected, SQL Server 2008 will try to drop any credential that is mapped to your login credentials. Because your credentials cannot be set to the "sa" login, you receive the exception error message that is mentioned in the "Symptoms" section when you click OK to close the dialog box.

RESOLUTION
To resolve this issue, make sure that you select the Map To Credential check box...

To resolve this issue, make sure that you select the Map To Credential check box on the General tab of the Login Properties - sa dialog box before you change the "sa" login properties and then click OK to close the dialog box.

83 Comments

  • Thanks for the tip. Worked liked a charm.

  • I am using Sql Server 2008 R2. This solution did not work for me. After i change password and check Map credentials, disconnect and re-login as sa under Sql Authentication, I still got the error "The user is not associated with a trusted sql server connection. Error 18452"

  • Thanks, I had the same problem...

  • ZjO0CL Fantastic article.Really looking forward to read more. Really Cool.

  • This is really interesting, You are a very skilled blogger.
    I have joined your feed and look forward to seeking more of your wonderful post.
    Also, I have shared your web site in my social networks!

  • What's up, after reading this awesome article i am too happy to share my know-how here with friends.

  • It's great that you are getting thoughts from this post as well as from our discussion made here.

  • Appreciate this post. Let me try it out.

  • This post presents clear idea in support of the new visitors of blogging, that actually how to do
    running a blog.

  • whoah this blog is magnificent i like reading
    your articles. Stay up the good work! You already know, a lot
    of individuals are hunting round for this info, you could
    help them greatly.

  • We are a group of volunteers and starting a new scheme
    in our community. Your site provided us with valuable info to work on.
    You have done an impressive job and our entire community
    will be grateful to you.

  • Howdy just wanted to give you a quick heads up.
    The text in your article seem to be running off the screen in Internet explorer.

    I'm not sure if this is a format issue or something to do with browser compatibility but I figured I'd post to let you know.
    The layout look great though! Hope you get the issue
    solved soon. Cheers

  • Hi there it's me, I am also visiting this site on a regular basis, this site is genuinely pleasant and the users are in fact sharing nice thoughts.

  • What's up to every one, the contents existing at this website are truly remarkable for people knowledge, well, keep up the nice work fellows.

  • I absolutely love your website.. Pleasant
    colors & theme. Did you create this site yourself? Please reply back as
    I'm planning to create my own personal site and want to learn where you got this from or just what the theme is named. Kudos!

  • Great post. I used to be checking constantly this weblog and
    I'm impressed! Extremely useful information specifically the final part :) I care for such information a lot. I was looking for this particular info for a very long time. Thanks and best of luck.

  • I enjoy what you guys are usually up too. Such clever work and exposure!

    Keep up the good works guys I've included you guys to my blogroll.

  • I leave a response whenever I appreciate a post on a website or I have something to contribute to
    the discussion. Usually it is a result of the fire displayed in the article I browsed.
    And on this article Alert Cannot set a credential for principal
    'sa' .... when trying to modify 'sa' properties through sql management studio 2008.
    . - zc0000. I was actually excited enough to post a commenta response :-) I actually do have a few questions for you if it's okay. Could it be only me or do some of these remarks appear as if they are written by brain dead people? :-P And, if you are writing at other places, I'd like to follow everything fresh you have to
    post. Could you list every one of your public pages like your twitter feed, Facebook
    page or linkedin profile?

  • Thanks for sharing such a fastidious opinion, paragraph is nice, thats why i
    have read it completely

  • I visited many sites except the audio feature for audio songs current at this website is truly fabulous.

  • Very nice article, exactly what I needed.

  • Yes, your car which you got depolluted and then recycled may
    end up in the form of processed sheet metal for a new car
    in another part of the planet altogether. , including passenger vehicles, commercial vehicles, utility vehicles,
    two wheelers and auto components. 2008 Shelby Mustang (SVT)One of the newest
    cars for sale at Carlisle was an authentic 2008 Shelby Mustang,
    dressed out in Grabber Orange, with white stripes.

  • Quality posts is the secret to interest the viewers to pay a visit the web page, that's what this site is providing.

  • Hi to all, since I am genuinely keen of reading
    this webpage's post to be updated daily. It carries good stuff.

  • I prefer this chair later hunt so it the Topper office chair for your endorse.
    In March, my mom will be taking an a slide fastener settlement and 5" handles.

  • Here you can prize specific case log of man and wife
    sooner than blasting fuse of your quarrels. Karmak i mekanizmalar package keylogger used for remote computers.
    Now via interpretation the logs Written report complicated ones that record book absolutely everything that your reckoner does from bang up to exclude down.
    What you need is something that is outturn subject
    area, from which you can copy, or it can go instantly to the participating
    covering.

  • The Kobler Cato, Kobler Ciello, Herman Moth miller Mirra and Steelcase
    Think office chairs are examples so it will do the conversion of pounds to dollars
    for you.

  • It's fantastic that you are getting thoughts from this article as well as from our argument made at this time.

  • When I initially commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get several e-mails with the same comment.
    Is there any way you can remove me from
    that service? Thanks a lot!

  • It's going to be finish of mine day, however before ending I am reading this impressive post to improve my knowledge.

  • This post is worth everyone's attention. Where can I find out more?

  • Pretty great post. I simply stumbled upon your blog and wanted
    to mention that I have truly enjoyed surfing around your weblog posts.
    In any case I will be subscribing for your feed and I hope you write once more soon!

  • Keep up the fantastic piece of work, I read few blog
    posts on this web site and I believe that your website is really interesting and has
    plenty of excellent information.

  • I'm gone to say to my little brother, that he should also go to see this website on regular basis to obtain updated from most recent news update.

  • you're truly a excellent webmaster. The website loading speed is incredible. It sort of feels that you're doing any unique trick.
    Also, The contents are masterwork. you have performed a magnificent process in this subject!

  • Loving the information on this website, you have done excellent job on
    the posts.

  • There has been no solid research behind this, but did
    not receive in instruction in the DASH weightloss in African Americans.
    Her unique method of cheerleading support, underpinned with the threat
    of osteoporosis. I don't really understand it either.

  • Great work on behalf of the owner of this web site, superb
    post.

  • Great article, totally what I was looking for.

  • Your method of describing all in this paragraph is actually good, all be capable of
    effortlessly know it, Thanks a lot.

  • This paragraph presents clear idea in favor of the new visitors of blogging, that truly how to do running a blog.

  • Hi, your website is really good. I truly do appreciate you sharing
    informative posts.

  • Wonderful article! That is the kind of information that are meant
    to be shared across the net. Shame on the search engines for no longer positioning this put up upper!
    Come on over and consult with my website . Thanks =)

  • Hi i am kavin, its my first occasion to commenting anywhere,
    when i read this post i thought i could also make comment due to this brilliant paragraph.

  • Thanks a lot for sharing this brilliant info! I am looking forward to see more posts!

  • I love what you guys are up to. Such smart work and exposure!
    Continue the very good works guys I’ve incorporated you guys to my
    own blogroll.

  • After I initially commented I appear to have clicked the -Notify me when new comments are added- checkbox and from now on each time a comment is added I recieve four emails with the exact same comment.
    Is there a means you are able to remove me from that
    service? Kudos!

  • Hi there it's me, I am also visiting this website daily, this web page is truly good and the people are genuinely sharing fastidious thoughts.

  • I love your blog.. very nice colors & theme. Did you create this website yourself or did you
    hire someone to do it for you? Plz respond as I'm looking to construct my own blog and would like to find out where u got this from. thank you

  • Hello! Great stuff here, please keep us posted.

  • Hi i am kavin, its my first time to commenting anywhere, when
    i read this article i thought i could also create comment due
    to this brilliant article.

  • Hey there, You have done an admirable job.
    I’ll definitely digg it and for my part recommend to my friends.
    I am confident they will be benefiting from this site.

  • Woah I enjoy your posts, saved! My wife and i adored your posts.

  • Undeniably consider that which you said. Your favorite reason appeared to
    be at the internet the simplest factor to understand of.

    I say to you, I certainly get annoyed whilst other
    folks consider issues that they just do
    not recognise about. You controlled to hit the nail upon the highest and
    defined out the entire thing without having side effect , folks can take a signal.
    Will probably be back to get more. Thank you

  • Thanks for the write up. I surely agree with what you are saying.
    I have been talking about this subject a lot lately with my
    brother so ideally this will get him to see my viewpoint.

    Fingers crossed!

  • An additional issue is that video gaming became one of the all-time most significant forms of fun for people of all ages.
    Kids play video games, and also adults do, too. The actual XBox 360 has become the favorite games systems for people who love
    to have hundreds of games available to them, as
    well as who like to experiment with live with other individuals all over the world.
    Thanks for sharing your opinions.

  • Wow! After all I got a blog from where I know how to really get useful
    facts regarding my study and knowledge.

  • magnificent issues altogether, you just won a emblem new reader.
    What might you suggest about your publish that you made some days in the past?
    Any positive?

  • Hi there, yeah this post is actually fastidious and I have learned lot of things from it on the topic of blogging.
    thanks.

  • k0uZD0 I truly appreciate this post.Really thank you!

  • always i used to read smaller content whih also clear their
    motive, and that is allso happening with this article which I am reading aat this time.

  • Hey there! Quick question that's totally off
    topic. Do you know how to make your site mobile friendly?
    My website looks weird when browsing from my iphone 4. I'm trying to find a template or plugin
    that might be able to resolve this issue. If
    you have any recommendations, please share. Thank you!

  • Thank you for the auspicious writeup. It in fact was a amusement account it.

    Look advanced to far added agreeable from you! However, how
    could we communicate?

  • Moreover, satellite broadband internet will enable you to rely more on online bill
    pay. They have personal lives like anyone else, some good, some not so good.
    Regardless of the lack of findings, the search for Bigfoot always seems to persist and is very popular.

  • When the arrow collides with an enemy champion, they will take magic damage and also
    be stunned for a maximum of 3. He is meant to be a high
    output damage caster than can survive the fight longer than most other Ability Power casters.
    In case you have frost shot enabled, your 7-arrow volley will
    probably be frosted.

  • If you are a minority with disabilities that may not be the best place to find a company that is looking to excel in a sales environment but in other spheres as well.
    These pioneers began teaching in the days whenmeant nothing to the average
    person changes careers 5-7 times in their professional years.

    You will also learn the importance of continuing to stay active as adults.

  • Every job has its highs and lows and these jobs are no
    different. Here are some different ways of wrapping our minds around the power of
    Uranus:. While a job in this industry can test your patience and endurance, it is worth the effort.

  • Well, since both of these molds are very flexible.
    While many types of insulations aren't likely to grow in cold temperatures
    and if the conditions for the disease are favorable,
    mature fruits can become completely rotted mold a rama as little as
    48 hours after being picked. In the absence of
    fans, open windows for a short time, but in an offshore establishment the problem is being taken care
    of efficiently and quickly.

  • Thwnkѕ for ѕharing your thoughts on foundation crack repair.
    Regards

  • When someone writes an article he/she maintains the idea of a user in his/her
    brain that how a user can understand it. Thus that's why this
    article is amazing. Thanks!

  • zeFC0N Thanks for the article.Really looking forward to read more. Great.

  • Thank you for another wonderful article. The place else may anybody get that type of info in such an ideal means of
    writing? I've a presentation next week, and I'm on the look for such
    information.

  • The California schools, music industry executives,
    and the monthly bonus material is of the highest quality. They are" Can't Buy daily financial news Me Pair,"" Captain America" and" And I think that that yellow pancake-eating excrement can get a little flashy at times with his technique. To that end, the California Arts Council spearheaded the California Music Project daily financial news CMP, a 401c3 nonprofit, long-term initiative. I love, when I write of the extra-vocal side of the 45 was Strange Brew.

  • Hi there everyone, it's my first visit at this web page, and article is in fact fruitful for me, keep up posting
    these posts.

  • Released by her publicist, the statement is tthe first funeral home in British Columbia in thee last yearr that she needed noo Rooyal title to continue to north dallas funeral homke
    generate her particular brand oof magic. You know,
    he's in a better place. Analysts, who had predicted that Service Corporation would makoe good on its
    threats, said the preference was too wait for out-of-towners to arrive.
    On Friday, a gunman allegedly killed his mother att their home on Friday evening from 5-7 pm to visit with relatives & friends.

  • I can’t recall the last time I enjoyed a piece
    of writing just as much as this one. You have went beyond
    my expectations on this subject and I agree with your points.
    You have done well with this.

  • XKTMT1 I really liked your blog. Will read on...

  • Very insightful post. Your current site style is
    great as well!

  • ローソンのそうめんってこれが入るぐらいデカいのかスゲエ 寒すぎて食欲が出ない(´・ω・`) [ ::━◎]ノ DQNどうし潰し合えば良いよ.
    そうとう演技勉強しないとささきき扱いになるぞw タチの悪い消費者は守らないでいいから罰してくれよ
    そうすれば、人に優しくなれる。 このスレは宮本ヲタに黙殺されるだろう
    早く叶姉妹に追いついてくれw

  • Incredible! This can be one of the most effective blogs I have ever
    arrive across on this subject. In fact this is great. I’m also an experienced
    in this topic so I can understand your hard work.

  • Could half the world really be that interested in car covers.
    Most state statues list a category of deceptive treade practices (Check your state statute to see if the dealer or the
    creditor violated any of these practices). The Accord is larger than the
    other sub-$5,000 fuel misers on this list, so it might be the only viable option here for families with older children.

  • I think you did an awesome job explaining it in your article.
    Sure beats having to research it on my own. Thanks.

  • Tip 4: As cliche as it could be, practice delivering the news inside the mirror.
    From here, you then get yourself a number of shots of locations
    which can be related for the story and objects that may help
    convey the content.
    i - Movie themes are one with the defining ways in which makes i - Movie the
    very best option around the market for novice home video editing.
    Google Commerce Blog Everything you desire to know and more from the Internet search giant's official commerce blog.

Comments have been disabled for this content.