how to remove SPN

• asif mustak bhura

  Right there with Babe

  Points: 761

  More actions

  October 18, 2005 at 1:57 am

  #110226

  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

   

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  October 19, 2005 at 4:34 pm

  #598523

  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."