Check status of SPN?

  • Comments posted to this topic are about the item Check status of SPN?

    Best,
    Naseer Ahmad
    SQL Server DBA

  • Oh my .. had to shake the cobwebs out of my brain cells to remember this one.

    But a very good question - never hurts to refresh the basics.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Having gone through lots of painful conversations about kerberos authentication, how it works and how to set it up there are some things that get cemented in your brain.

    This being one of them! 🙂

  • I couldn't even remember what an SPN was, but I figured -R should be RESET, and -D should be DELETE. That left -L for LIST. Good thing the tool writers are a bit logical at times...


    Just because you're right doesn't mean everybody else is wrong.

  • This was removed by the editor as SPAM

  • Not familiar with SPN but the question got me to look it up. Thanks.

  • (Bob Brown) (8/22/2012)


    Not familiar with SPN but the question got me to look it up. Thanks.

    That's probably the best benefit of QotD. You get people posting questions about their pet peeves and the gotchas they have encountered. A smart person figures out how to solve their own problems. A wise person learns from the experience of others, so as to avoid the problems they have encountered.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Thomas Abraham (8/22/2012)


    (Bob Brown) (8/22/2012)


    Not familiar with SPN but the question got me to look it up. Thanks.

    That's probably the best benefit of QotD. You get people posting questions about their pet peeves and the gotchas they have encountered. A smart person figures out how to solve their own problems. A wise person learns from the experience of others, so as to avoid the problems they have encountered.

    Wow Thomas, you got deep this morning. It's a little too early for me to be coming up with things like that. :hehe:

    Great question. It really made me dig into my brain matter and sit back and think. Good news I guess is now I have something I can brush back up on.



    Everything is awesome!

  • I haven't worked with Kerberos authentication, so I had to look it up. Interesting to learn.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • I've done too much with Kerberos....I was glad that I remembered this.

    Kerberos authentication is my preference because once it works, SQL authentication stops being a "why the hell can't it log in?" type of thing when using Windows Auth....



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • Learned something new today. Thanks for the question!

  • Rune Bivrin (8/22/2012)


    I couldn't even remember what an SPN was, but I figured -R should be RESET, and -D should be DELETE. That left -L for LIST. Good thing the tool writers are a bit logical at times...

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SPN. Isn't that a sports network? 😛

  • If you are doing this on Windows Server 2003 then setspn isn't installed by default. You need to download Windows Server 2003 Support Tools.

  • Needed to do some research for got the question right.

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply