setspn

• ps.

  One Orange Chip

  Points: 29423

  More actions

  July 16, 2009 at 9:18 am

  #132971

  Am getting this error.

  Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed.

  My sql server is running under network services account.

  how do i register the spn>?

  C:\>setspn -A MSSQLSvc/asccsq10\tordev01:1151 \NetworkService

  FindDomainForAccount: DsGetDcNameWithAccountW failed!

  Unable to locate account NetworkService

  can someone give me correct syntax for this pls?

  ---

  
  Pradeep Singh

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736602

  More actions

  July 16, 2009 at 9:42 am

  #1025740

  Here's a ref from the SQL team

  http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx