|
Home > Archive > MS SQL Server Connectivity > February 2006 > There are multiple accounts with name MSSQLsvc/ad.domain of type DS_SERVICE_PRINCIPAL_NAME
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
There are multiple accounts with name MSSQLsvc/ad.domain of type DS_SERVICE_PRINCIPAL_NAME
|
|
| KayZer Soze 2006-02-13, 9:23 am |
| Win2003 SP1 + SQL 2000 SP3
Sometimes, i have to restart SQL Server, because new users (on their regular
PCs) cannont connecto to SQL. I have 100 SQL CAL licences, and 45-65 users.
Sometimes a user disconnects, change to another's one PC and can connect.
Maybe there is a relation with recent Event IDs on the Logs
On the Log:
Event ID 11 Source KDC There are multiple accounts with name
MSSQLsvc/ad.domain of type DS_SERVICE_PRINCIPAL
_NAME.
setspn -L %computername%
Registered ServicePrincipalName
s for CN=corp,OU=Domain
Controllers,DC=corpc
,DC=com,DC=br
MSSQLSvc/corp.corpc.com.br:1433
NtFrs-88f5d2bd-b646-11d2-a6d3-00c04fc9b232/corp.corpc.com.br
DNS/corp.corpc.com.br
HOST/corp.corpc.com.br/corpc.com.br
HOST/corp.corpc.com.br/corpC
GC/corp.corpc.com.br/corpc.com.br
ldap/corp.corpc.com.br/corpC
ldap/corp.corpc.com.br
ldap/corp.corpc.com.br/ForestDnsZones.corpc.com.br
ldap/corp.corpc.com.br/DomainDnsZones.corpc.com.br
ldap/corp.corpc.com.br/corpc.com.br
HOST/corp.corpc.com.br
HOST/corp
ldap/corp
E3514235-4B06-11D1-AB04-00C04FC2DCD2/c23c951a-7855-490d-8781-4c9c5c5a43eb/co
rpc.com.br
ldap/c23c951a-7855-490d-8781-4c9c5c5a43eb._msdcs.corpc.com.br
| |
| Sue Hoegemeier 2006-02-14, 3:23 am |
| It depends on what error the users get when they can't
connect and details around that. For the spn issue, check
the following link at EventID.net:
http://www.eventid.net/display.asp?...rce=KDC&phase=1
-Sue
On Mon, 13 Feb 2006 12:54:47 -0200, "KayZer Soze"
< thesuspects@thesuspe
cts.net> wrote:
>Win2003 SP1 + SQL 2000 SP3
>
>Sometimes, i have to restart SQL Server, because new users (on their regular
>PCs) cannont connecto to SQL. I have 100 SQL CAL licences, and 45-65 users.
>Sometimes a user disconnects, change to another's one PC and can connect.
>
>Maybe there is a relation with recent Event IDs on the Logs
>
>On the Log:
>Event ID 11 Source KDC There are multiple accounts with name
>MSSQLsvc/ad.domain of type DS_SERVICE_PRINCIPAL
_NAME.
>
>
>
>setspn -L %computername%
>
>Registered ServicePrincipalName
s for CN=corp,OU=Domain
> Controllers,DC=corpc
,DC=com,DC=br
> MSSQLSvc/corp.corpc.com.br:1433
> NtFrs-88f5d2bd-b646-11d2-a6d3-00c04fc9b232/corp.corpc.com.br
> DNS/corp.corpc.com.br
> HOST/corp.corpc.com.br/corpc.com.br
> HOST/corp.corpc.com.br/corpC
> GC/corp.corpc.com.br/corpc.com.br
> ldap/corp.corpc.com.br/corpC
> ldap/corp.corpc.com.br
> ldap/corp.corpc.com.br/ForestDnsZones.corpc.com.br
> ldap/corp.corpc.com.br/DomainDnsZones.corpc.com.br
> ldap/corp.corpc.com.br/corpc.com.br
> HOST/corp.corpc.com.br
> HOST/corp
> ldap/corp
>
>E3514235-4B06-11D1-AB04-00C04FC2DCD2/c23c951a-7855-490d-8781-4c9c5c5a43eb/co
>rpc.com.br
> ldap/c23c951a-7855-490d-8781-4c9c5c5a43eb._msdcs.corpc.com.br
>
>
>
>
>
>
|
|
|
|
|