Here are the 2 accounts that keep showing up in the event logs........
Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 7/29/2009
Time: 5:46:20 AM
User: N/A
Computer: ROSSLYN-DC1
Description:
There are multiple accounts with name MSSQLSvc/opssqldb.xxxx.xxx:1433 of type DS_SERVICE_PRINCIPAL_NAME.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 7/29/2009
Time: 5:47:13 AM
User: N/A
Computer: ROSSLYN-DC1
Description:
There are multiple accounts with name MSSQLSvc/opssqlent.xxxx.xxx:1433 of type DS_SERVICE_PRINCIPAL_NAME.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf Of Ken Schaefer
Sent: Wednesday, July 29, 2009 3:02 AM
To: msmom@lists.myitforum.com
Subject: [msmom] RE: Kerberos
What is the actual error you are getting?
Those SPNs look normal (assuming that the machine is called "labopssql.lab.local" with a NetBIOS name "labopssql" and it's running SQL Server on port 1433 (though I'm not sure that SQL Server creates SPNs with no port number)
Cheers
Ken
From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf Of Shemory, Chris
Sent: Wednesday, 29 July 2009 3:24 AM
To: 'msmom@lists.myitforum.com'
Subject: [msmom] Kerberos
Question???? My DC's are spitting out Kerberos errors from 2 of my Ops machines. I know which servers are causing the error but not sure which SPN's to get rid of. Here is what is listed under the one.....or am I off base here and another machine is causing this??
Computer DNS: labopssql.lab.local
-- MSSQLSvc/labopssql.lab.local:1433
-- MSSQLSvc/labopssql.lab.local
-- HOST/LABOPSSQL
-- HOST/labopssql.lab.local
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/