how to remove SPN

  • hi everyone

    I am facing error again  & agin as cannot generate SSPI context .

    Regarding that, I have got some tricks to solve.

    how to remove SPN. it has given command like SETSPN -D  <SPN> <SERVERNAME>.

    Where this command i have to type.

    using command prompt i tried but it is not working.

    Please help me out.

    Waiting for reply.

    regards,

    ASIF

     

  • I took the extract below from thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=202884

    Here's how:

    I've had this problen quite frequently lately (ughh...)

    First thing you need to do is download the setspn utility (link below):

    http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/setspn-o.asp

    Install it on your computer (or server). Next you'll need a Domain Admin account to use (unless you are a Domain Admin you cannot use setspn for this type of AD updates). Open up a DOS command window change directory to C:\Program Files\Resource Kit (the setspn installation default directory).

    Then enter the following comand:

     setspn -L servername

    Your results may look something like this:

         MSSQLSvc/servername.xxx.organization.org:1433

         HOST/servername

         HOST/servername.xxx.organization.org

    Next enter the following commands:

     setspn -D MSSQLSvc/servername.xxx.organization.org servername

     setspn -D HOST/servername servername

     setspn -D HOST/servername.xxx.organization.org servername

    Now things shoud be OK.

     

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 2 posts - 1 through 1 (of 1 total)

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