Post reply

Check status of SPN?

  • August 21, 2012 at 10:00 pm

    #263203

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

    Best,
    Naseer Ahmad
    SQL Server DBA

  • August 21, 2012 at 10:02 pm

    #1528435

    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]

  • August 22, 2012 at 12:32 am

    #1528460

    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! 🙂

  • August 22, 2012 at 2:42 am

    #1528506

    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.

  • August 22, 2012 at 3:01 am

    This was removed by the editor as SPAM

  • August 22, 2012 at 4:17 am

    #1528543

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

  • August 22, 2012 at 5:41 am

    #1528564

    (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

  • August 22, 2012 at 7:18 am

    #1528614

    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!

  • August 22, 2012 at 7:49 am

    #1528639

    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]

  • August 22, 2012 at 9:51 am

    #1528752

    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]

  • August 22, 2012 at 10:01 am

    #1528761

    Learned something new today. Thanks for the question!

  • August 22, 2012 at 11:00 am

    #1528790

    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

  • August 22, 2012 at 11:53 am

    #1528816

    SPN. Isn't that a sports network? 😛

  • August 23, 2012 at 2:21 am

    #1529093

    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.

  • August 23, 2012 at 2:50 am

    #1529116

    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