KDC error

[Adam]

Hi,

I have recently been getting the following error on a
regular basis:

Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 23/01/2004
Time: 2:08:27:AM
User: N/A
Computer: Server
Description:
There are multiple accounts with name
MSSQLSvc/Server.Domain.com:1433 of type 10.

does anybody have any ideas how to resolve this or what is
causing this to occur.


Regards

Adam

 

[Richard McCall [MSFT]]

You have recently changed the account that the SQL service starts up as.
When
you do this SQL registers the SPN on the user account. The SQL server you
configured with a second account was <computername> in the event log. You
can use ADSIedit to remove the SPN from the First account. If you are unsure
which account the you can use this ldifde and search the output for the SPN
string.

ldifde -f ldif.txt - t 3268 -d "dc=domain,dc=com" -l serviceprincipalname -r
"(serviceprincipalname=MSSQL*)" -p subtree

 

[Adam]

I have run the ldifde command and got the following back:

dn: CN=Administrator,CN=Users,DC=domain,DC=com
changetype: add
servicePrincipalName: MSSQLSvc/server.domain.com:1433

dn: CN=domain SQL Server,CN=Users,DC=marcrist,DC=com
changetype: add
servicePrincipalName: MSSQLSvc/server.domain.com:1433

I am unsure where to go from here the MSSQL service logs
on using:

domain\sqlservice

any ideas help will be appreciated.

-----Original Message-----
You have recently changed the account that the SQL service starts up as.
When
you do this SQL registers the SPN on the user account. The SQL server you
configured with a second account was <computername> in the event log. You
can use ADSIedit to remove the SPN from the First account. If you are unsure
which account the you can use this ldifde and search the output for the SPN
string.

ldifde -f ldif.txt - t 3268 -d "dc=domain,dc=com" -l serviceprincipalname -r
"(serviceprincipalname=MSSQL*)" -p subtree



--
Richard McCall [MSFT]

"This posting is provided "AS IS" with no warranties, and confers no
rights."

Hi,

I have recently been getting the following error on a
regular basis:

Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 23/01/2004
Time: 2:08:27:AM
User: N/A
Computer: Server
Description:
There are multiple accounts with name
MSSQLSvc/Server.Domain.com:1433 of type 10.

does anybody have any ideas how to resolve this or what is
causing this to occur.


Regards

Adam

.