Showing posts with label sp4. Show all posts
Showing posts with label sp4. Show all posts

Friday, March 30, 2012

Known Issues for SQL Server 2000 SP4

Hi All,
I am looking for known issues for SQL Server Service Pack 4 before I apply
Service pack 4.
If anybody has URL or list of problems, please let me know.
Thanks,
MunirThe only issue that was found, that I'm aware of, was a bug where only
half of the physical memory in the box could be used by SQL Server when
using AWE on a 32-bit instance.
There is a hotfix for this now:
http://support.microsoft.com/defaul...kb;en-us;899761
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Munir wrote:

>Hi All,
>I am looking for known issues for SQL Server Service Pack 4 before I apply
>Service pack 4.
>If anybody has URL or list of problems, please let me know.
>Thanks,
>Munir
>

Known Issues for SQL Server 2000 SP4

Hi All,
I am looking for known issues for SQL Server Service Pack 4 before I apply
Service pack 4.
If anybody has URL or list of problems, please let me know.
Thanks,
Munir
The only issue that was found, that I'm aware of, was a bug where only
half of the physical memory in the box could be used by SQL Server when
using AWE on a 32-bit instance.
There is a hotfix for this now:
http://support.microsoft.com/default...b;en-us;899761
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Munir wrote:

>Hi All,
>I am looking for known issues for SQL Server Service Pack 4 before I apply
>Service pack 4.
>If anybody has URL or list of problems, please let me know.
>Thanks,
>Munir
>

Known Issues for SQL Server 2000 SP4

Hi All,
I am looking for known issues for SQL Server Service Pack 4 before I apply
Service pack 4.
If anybody has URL or list of problems, please let me know.
Thanks,
MunirThis is a multi-part message in MIME format.
--050601080709030205010702
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
The only issue that was found, that I'm aware of, was a bug where only
half of the physical memory in the box could be used by SQL Server when
using AWE on a 32-bit instance.
There is a hotfix for this now:
http://support.microsoft.com/default.aspx?scid=kb;en-us;899761
--
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Munir wrote:
>Hi All,
>I am looking for known issues for SQL Server Service Pack 4 before I apply
>Service pack 4.
>If anybody has URL or list of problems, please let me know.
>Thanks,
>Munir
>
--050601080709030205010702
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>The only issue that was found, that I'm aware of, was a bug where
only half of the physical memory in the box could be used by SQL Server
when using AWE on a 32-bit instance.<br>
<br>
There is a hotfix for this now:<br>
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://support.microsoft.com/default.aspx?scid=kb;en-us;899761</a></tt><br>">http://support.microsoft.com/default.aspx?scid=kb;en-us;899761">http://support.microsoft.com/default.aspx?scid=kb;en-us;899761</a></tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2">blog:</font><font face="Tahoma" size="2"> <a
href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Munir wrote:
<blockquote cite="midCB8919B9-0FFF-4C42-80EC-984815FCE563@.microsoft.com"
type="cite">
<pre wrap="">Hi All,
I am looking for known issues for SQL Server Service Pack 4 before I apply
Service pack 4.
If anybody has URL or list of problems, please let me know.
Thanks,
Munir
</pre>
</blockquote>
</body>
</html>
--050601080709030205010702--|||You should also read the readme files and the addendum to the readme
files:
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en#filelist
http://support.microsoft.com/kb/884525/
Razvan

Monday, February 20, 2012

KDC - 11

I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
server is domain controller also.
I frequently receiving next message in the Event Log:
Source: KDC
ID: 11
There are multiple accounts with name MSSQLSvc/comp.dom.ru:1433 of type 10.
I'm finding the 321044 article of the Microsoft Knowledge Base.
I'm using the LDP utility and type next filter:
servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
I received next reply:
***Searching...
ldap_search_s(ld, "DC=dom,DC=ru", 2,
"servicePrincipalName=MSSQLSvc/comp.dom.ru:1433", attrList, 0, &msg)
Result <0>: (null)
Matched DNs:
Getting 2 entries:[vbcol=seagreen]
1> canonicalName: dom.ru/Domain Controllers/comp;
1> cn: comp;
1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
5> objectClass: top; person; organizationalPerson; user; computer;
1> name: comp;[vbcol=seagreen]
1> canonicalName: <ldp: Binary blob>;
1> cn: <ldp: Binary blob>;
1> description: <ldp: Binary blob>;
1> distinguishedName: <ldp: Binary blob>;
4> objectClass: top; person; organizationalPerson; user;
1> name: <ldp: Binary blob>;
And what? Must I delete comp account? But comp is domain controller.
What can I do?
Michael S. Androsov
That's one of the reason why it's better not to install SQL on a domain
server.
In mine opinion the trouble comes from LDAP but I'rm not a specialist.
Try a post on the forum concerned.
P.RUELLO
DBA
"Michael S. Androsov" wrote:

> I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
> server is domain controller also.
> I frequently receiving next message in the Event Log:
> Source: KDC
> ID: 11
> There are multiple accounts with name MSSQLSvc/comp.dom.ru:1433 of type 10.
> I'm finding the 321044 article of the Microsoft Knowledge Base.
> I'm using the LDP utility and type next filter:
> servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
> I received next reply:
> ***Searching...
> ldap_search_s(ld, "DC=dom,DC=ru", 2,
> "servicePrincipalName=MSSQLSvc/comp.dom.ru:1433", attrList, 0, &msg)
> Result <0>: (null)
> Matched DNs:
> Getting 2 entries:
> 1> canonicalName: dom.ru/Domain Controllers/comp;
> 1> cn: comp;
> 1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
> 5> objectClass: top; person; organizationalPerson; user; computer;
> 1> name: comp;
> 1> canonicalName: <ldp: Binary blob>;
> 1> cn: <ldp: Binary blob>;
> 1> description: <ldp: Binary blob>;
> 1> distinguishedName: <ldp: Binary blob>;
> 4> objectClass: top; person; organizationalPerson; user;
> 1> name: <ldp: Binary blob>;
> And what? Must I delete comp account? But comp is domain controller.
> What can I do?
> Michael S. Androsov
>
|||What is the forum?
Michael S. Androsov
"P.Ruello" пишет:
[vbcol=seagreen]
> That's one of the reason why it's better not to install SQL on a domain
> server.
> In mine opinion the trouble comes from LDAP but I'rm not a specialist.
> Try a post on the forum concerned.
> --
> P.RUELLO
> DBA
>
> "Michael S. Androsov" wrote:

KDC - 11

I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
server is domain controller also.
I frequently receiving next message in the Event Log of the Windows Server
2000 & 2003 computers:
Source: KDC
ID: 11
There are multiple accounts with name MSSQLSvc/comp.dom.ru:1118 of type 10.
I'm finding the 321044 article of the Microsoft Knowledge Base.
I'm using the LDP utility and type next filter:
servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
I received next reply:
***Searching...
ldap_search_s(ld, "DC=dom,DC=ru", 2,
"servicePrincipalName=MSSQLSvc/comp.dom.ru:1118", attrList, 0, &msg)
Result <0>: (null)
Matched DNs:
Getting 2 entries:[vbcol=seagreen]
1> canonicalName: dom.ru/Domain Controllers/comp;
1> cn: comp;
1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
5> objectClass: top; person; organizationalPerson; user; computer;
1> name: comp;[vbcol=seagreen]
1> canonicalName: <ldp: Binary blob>;
1> cn: <ldp: Binary blob>;
1> description: <ldp: Binary blob>;
1> distinguishedName: <ldp: Binary blob>;
4> objectClass: top; person; organizationalPerson; user;
1> name: <ldp: Binary blob>;
And what? Must I delete comp account? But comp is domain controller.
What can I do?
Michael S. Androsov
Hi
Check out the part in the KB that talks about using ADIEdit. You need to
change the incorrect SPN.
John
"Michael S. Androsov" wrote:

> I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
> server is domain controller also.
> I frequently receiving next message in the Event Log of the Windows Server
> 2000 & 2003 computers:
> Source: KDC
> ID: 11
> There are multiple accounts with name MSSQLSvc/comp.dom.ru:1118 of type 10.
> I'm finding the 321044 article of the Microsoft Knowledge Base.
> I'm using the LDP utility and type next filter:
> servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
> I received next reply:
> ***Searching...
> ldap_search_s(ld, "DC=dom,DC=ru", 2,
> "servicePrincipalName=MSSQLSvc/comp.dom.ru:1118", attrList, 0, &msg)
> Result <0>: (null)
> Matched DNs:
> Getting 2 entries:
> 1> canonicalName: dom.ru/Domain Controllers/comp;
> 1> cn: comp;
> 1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
> 5> objectClass: top; person; organizationalPerson; user; computer;
> 1> name: comp;
> 1> canonicalName: <ldp: Binary blob>;
> 1> cn: <ldp: Binary blob>;
> 1> description: <ldp: Binary blob>;
> 1> distinguishedName: <ldp: Binary blob>;
> 4> objectClass: top; person; organizationalPerson; user;
> 1> name: <ldp: Binary blob>;
> And what? Must I delete comp account? But comp is domain controller.
> What can I do?
> Michael S. Androsov
>
|||Hi! Thank you very much for answer.
Excuse me. I'm not master in to the ADSIEdit and AD tools.
Can you help me? What I must doing after ADSIEDit loaded? What I search and
what is the part? I see the partition: Domain NC; Configuration Container and
Schema.
I don't know where I must seeking dublicate SPN.
Thanks,
Michael S. Androsov
"John Bell" пишет:
[vbcol=seagreen]
> Hi
> Check out the part in the KB that talks about using ADIEdit. You need to
> change the incorrect SPN.
> John
> "Michael S. Androsov" wrote:
|||Hi
Your duplicate spn is probably MSSQLSvc/comp.dom.ru. I am not an AD expert
but the following tells you how to search using ADSI Edit
http://support.microsoft.com/default...b;en-us;312299
You may want to post in
http://www.microsoft.com/technet/com...tive_directory
or
http://www.microsoft.com/technet/com...ve_di rectory
John
"Michael S. Androsov" wrote:
[vbcol=seagreen]
> Hi! Thank you very much for answer.
> Excuse me. I'm not master in to the ADSIEdit and AD tools.
> Can you help me? What I must doing after ADSIEDit loaded? What I search and
> what is the part? I see the partition: Domain NC; Configuration Container and
> Schema.
> I don't know where I must seeking dublicate SPN.
> Thanks,
> Michael S. Androsov
> "John Bell" пишет:

KDC - 11

I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
server is domain controller also.
I frequently receiving next message in the Event Log:
Source: KDC
ID: 11
There are multiple accounts with name MSSQLSvc/comp.dom.ru:1433 of type 10.
I'm finding the 321044 article of the Microsoft Knowledge Base.
I'm using the LDP utility and type next filter:
servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
I received next reply:
***Searching...
ldap_search_s(ld, "DC=dom,DC=ru", 2,
"servicePrincipalName=MSSQLSvc/comp.dom.ru:1433", attrList, 0, &msg)
Result <0>: (null)
Matched DNs:
Getting 2 entries:
>> Dn: CN=comp,OU=Domain Controllers,DC=dom,DC=ru
1> canonicalName: dom.ru/Domain Controllers/comp;
1> cn: comp;
1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
5> objectClass: top; person; organizationalPerson; user; computer;
1> name: comp;
>> Dn: CN=Administrator,CN=Users,DC=dom,DC=ru
1> canonicalName: <ldp: Binary blob>;
1> cn: <ldp: Binary blob>;
1> description: <ldp: Binary blob>;
1> distinguishedName: <ldp: Binary blob>;
4> objectClass: top; person; organizationalPerson; user;
1> name: <ldp: Binary blob>;
And what? Must I delete comp account? But comp is domain controller.
What can I do?
Michael S. AndrosovThat's one of the reason why it's better not to install SQL on a domain
server.
In mine opinion the trouble comes from LDAP but I'rm not a specialist.
Try a post on the forum concerned.
--
P.RUELLO
DBA
"Michael S. Androsov" wrote:
> I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
> server is domain controller also.
> I frequently receiving next message in the Event Log:
> Source: KDC
> ID: 11
> There are multiple accounts with name MSSQLSvc/comp.dom.ru:1433 of type 10.
> I'm finding the 321044 article of the Microsoft Knowledge Base.
> I'm using the LDP utility and type next filter:
> servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
> I received next reply:
> ***Searching...
> ldap_search_s(ld, "DC=dom,DC=ru", 2,
> "servicePrincipalName=MSSQLSvc/comp.dom.ru:1433", attrList, 0, &msg)
> Result <0>: (null)
> Matched DNs:
> Getting 2 entries:
> >> Dn: CN=comp,OU=Domain Controllers,DC=dom,DC=ru
> 1> canonicalName: dom.ru/Domain Controllers/comp;
> 1> cn: comp;
> 1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
> 5> objectClass: top; person; organizationalPerson; user; computer;
> 1> name: comp;
> >> Dn: CN=Administrator,CN=Users,DC=dom,DC=ru
> 1> canonicalName: <ldp: Binary blob>;
> 1> cn: <ldp: Binary blob>;
> 1> description: <ldp: Binary blob>;
> 1> distinguishedName: <ldp: Binary blob>;
> 4> objectClass: top; person; organizationalPerson; user;
> 1> name: <ldp: Binary blob>;
> And what? Must I delete comp account? But comp is domain controller.
> What can I do?
> Michael S. Androsov
>|||What is the forum?
Michael S. Androsov
"P.Ruello" пиÑ?еÑ?:
> That's one of the reason why it's better not to install SQL on a domain
> server.
> In mine opinion the trouble comes from LDAP but I'rm not a specialist.
> Try a post on the forum concerned.
> --
> P.RUELLO
> DBA
>
> "Michael S. Androsov" wrote:
> > I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
> > server is domain controller also.
> > I frequently receiving next message in the Event Log:
> > Source: KDC
> > ID: 11
> > There are multiple accounts with name MSSQLSvc/comp.dom.ru:1433 of type 10.
> >
> > I'm finding the 321044 article of the Microsoft Knowledge Base.
> > I'm using the LDP utility and type next filter:
> > servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
> > I received next reply:
> > ***Searching...
> > ldap_search_s(ld, "DC=dom,DC=ru", 2,
> > "servicePrincipalName=MSSQLSvc/comp.dom.ru:1433", attrList, 0, &msg)
> > Result <0>: (null)
> > Matched DNs:
> > Getting 2 entries:
> > >> Dn: CN=comp,OU=Domain Controllers,DC=dom,DC=ru
> > 1> canonicalName: dom.ru/Domain Controllers/comp;
> > 1> cn: comp;
> > 1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
> > 5> objectClass: top; person; organizationalPerson; user; computer;
> > 1> name: comp;
> > >> Dn: CN=Administrator,CN=Users,DC=dom,DC=ru
> > 1> canonicalName: <ldp: Binary blob>;
> > 1> cn: <ldp: Binary blob>;
> > 1> description: <ldp: Binary blob>;
> > 1> distinguishedName: <ldp: Binary blob>;
> > 4> objectClass: top; person; organizationalPerson; user;
> > 1> name: <ldp: Binary blob>;
> >
> > And what? Must I delete comp account? But comp is domain controller.
> >
> > What can I do?
> >
> > Michael S. Androsov
> >

KDC - 11

I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
server is domain controller also.
I frequently receiving next message in the Event Log of the Windows Server
2000 & 2003 computers:
Source: KDC
ID: 11
There are multiple accounts with name MSSQLSvc/comp.dom.ru:1118 of type 10.
I'm finding the 321044 article of the Microsoft Knowledge Base.
I'm using the LDP utility and type next filter:
servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
I received next reply:
***Searching...
ldap_search_s(ld, "DC=dom,DC=ru", 2,
"servicePrincipalName=MSSQLSvc/comp.dom.ru:1118", attrList, 0, &msg)
Result <0>: (null)
Matched DNs:
Getting 2 entries:
>> Dn: CN=comp,OU=Domain Controllers,DC=dom,DC=ru
1> canonicalName: dom.ru/Domain Controllers/comp;
1> cn: comp;
1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
5> objectClass: top; person; organizationalPerson; user; computer;
1> name: comp;
>> Dn: CN=Administrator,CN=Users,DC=dom,DC=ru
1> canonicalName: <ldp: Binary blob>;
1> cn: <ldp: Binary blob>;
1> description: <ldp: Binary blob>;
1> distinguishedName: <ldp: Binary blob>;
4> objectClass: top; person; organizationalPerson; user;
1> name: <ldp: Binary blob>;
And what? Must I delete comp account? But comp is domain controller.
What can I do?
Michael S. AndrosovHi
Check out the part in the KB that talks about using ADIEdit. You need to
change the incorrect SPN.
John
"Michael S. Androsov" wrote:
> I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
> server is domain controller also.
> I frequently receiving next message in the Event Log of the Windows Server
> 2000 & 2003 computers:
> Source: KDC
> ID: 11
> There are multiple accounts with name MSSQLSvc/comp.dom.ru:1118 of type 10.
> I'm finding the 321044 article of the Microsoft Knowledge Base.
> I'm using the LDP utility and type next filter:
> servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
> I received next reply:
> ***Searching...
> ldap_search_s(ld, "DC=dom,DC=ru", 2,
> "servicePrincipalName=MSSQLSvc/comp.dom.ru:1118", attrList, 0, &msg)
> Result <0>: (null)
> Matched DNs:
> Getting 2 entries:
> >> Dn: CN=comp,OU=Domain Controllers,DC=dom,DC=ru
> 1> canonicalName: dom.ru/Domain Controllers/comp;
> 1> cn: comp;
> 1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
> 5> objectClass: top; person; organizationalPerson; user; computer;
> 1> name: comp;
> >> Dn: CN=Administrator,CN=Users,DC=dom,DC=ru
> 1> canonicalName: <ldp: Binary blob>;
> 1> cn: <ldp: Binary blob>;
> 1> description: <ldp: Binary blob>;
> 1> distinguishedName: <ldp: Binary blob>;
> 4> objectClass: top; person; organizationalPerson; user;
> 1> name: <ldp: Binary blob>;
> And what? Must I delete comp account? But comp is domain controller.
> What can I do?
> Michael S. Androsov
>|||Hi! Thank you very much for answer.
Excuse me. I'm not master in to the ADSIEdit and AD tools.
Can you help me? What I must doing after ADSIEDit loaded? What I search and
what is the part? I see the partition: Domain NC; Configuration Container and
Schema.
I don't know where I must seeking dublicate SPN.
Thanks,
Michael S. Androsov
"John Bell" пиÑ?еÑ?:
> Hi
> Check out the part in the KB that talks about using ADIEdit. You need to
> change the incorrect SPN.
> John
> "Michael S. Androsov" wrote:
> > I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
> > server is domain controller also.
> > I frequently receiving next message in the Event Log of the Windows Server
> > 2000 & 2003 computers:
> > Source: KDC
> > ID: 11
> > There are multiple accounts with name MSSQLSvc/comp.dom.ru:1118 of type 10.
> >
> > I'm finding the 321044 article of the Microsoft Knowledge Base.
> > I'm using the LDP utility and type next filter:
> > servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
> > I received next reply:
> > ***Searching...
> > ldap_search_s(ld, "DC=dom,DC=ru", 2,
> > "servicePrincipalName=MSSQLSvc/comp.dom.ru:1118", attrList, 0, &msg)
> > Result <0>: (null)
> > Matched DNs:
> > Getting 2 entries:
> > >> Dn: CN=comp,OU=Domain Controllers,DC=dom,DC=ru
> > 1> canonicalName: dom.ru/Domain Controllers/comp;
> > 1> cn: comp;
> > 1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
> > 5> objectClass: top; person; organizationalPerson; user; computer;
> > 1> name: comp;
> > >> Dn: CN=Administrator,CN=Users,DC=dom,DC=ru
> > 1> canonicalName: <ldp: Binary blob>;
> > 1> cn: <ldp: Binary blob>;
> > 1> description: <ldp: Binary blob>;
> > 1> distinguishedName: <ldp: Binary blob>;
> > 4> objectClass: top; person; organizationalPerson; user;
> > 1> name: <ldp: Binary blob>;
> >
> > And what? Must I delete comp account? But comp is domain controller.
> >
> > What can I do?
> >
> > Michael S. Androsov
> >
> >|||Hi
Your duplicate spn is probably MSSQLSvc/comp.dom.ru. I am not an AD expert
but the following tells you how to search using ADSI Edit
http://support.microsoft.com/default.aspx?scid=kb;en-us;312299
You may want to post in
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.windows.server.active_directory
or
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.win2000.active_directory
John
"Michael S. Androsov" wrote:
> Hi! Thank you very much for answer.
> Excuse me. I'm not master in to the ADSIEdit and AD tools.
> Can you help me? What I must doing after ADSIEDit loaded? What I search and
> what is the part? I see the partition: Domain NC; Configuration Container and
> Schema.
> I don't know where I must seeking dublicate SPN.
> Thanks,
> Michael S. Androsov
> "John Bell" пиÑ?еÑ?:
> > Hi
> >
> > Check out the part in the KB that talks about using ADIEdit. You need to
> > change the incorrect SPN.
> >
> > John
> >
> > "Michael S. Androsov" wrote:
> >
> > > I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
> > > server is domain controller also.
> > > I frequently receiving next message in the Event Log of the Windows Server
> > > 2000 & 2003 computers:
> > > Source: KDC
> > > ID: 11
> > > There are multiple accounts with name MSSQLSvc/comp.dom.ru:1118 of type 10.
> > >
> > > I'm finding the 321044 article of the Microsoft Knowledge Base.
> > > I'm using the LDP utility and type next filter:
> > > servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
> > > I received next reply:
> > > ***Searching...
> > > ldap_search_s(ld, "DC=dom,DC=ru", 2,
> > > "servicePrincipalName=MSSQLSvc/comp.dom.ru:1118", attrList, 0, &msg)
> > > Result <0>: (null)
> > > Matched DNs:
> > > Getting 2 entries:
> > > >> Dn: CN=comp,OU=Domain Controllers,DC=dom,DC=ru
> > > 1> canonicalName: dom.ru/Domain Controllers/comp;
> > > 1> cn: comp;
> > > 1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
> > > 5> objectClass: top; person; organizationalPerson; user; computer;
> > > 1> name: comp;
> > > >> Dn: CN=Administrator,CN=Users,DC=dom,DC=ru
> > > 1> canonicalName: <ldp: Binary blob>;
> > > 1> cn: <ldp: Binary blob>;
> > > 1> description: <ldp: Binary blob>;
> > > 1> distinguishedName: <ldp: Binary blob>;
> > > 4> objectClass: top; person; organizationalPerson; user;
> > > 1> name: <ldp: Binary blob>;
> > >
> > > And what? Must I delete comp account? But comp is domain controller.
> > >
> > > What can I do?
> > >
> > > Michael S. Androsov
> > >
> > >

KDC - 11

I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
server is domain controller also.
I frequently receiving next message in the Event Log of the Windows Server
2000 & 2003 computers:
Source: KDC
ID: 11
There are multiple accounts with name MSSQLSvc/comp.dom.ru:1118 of type 10.
I'm finding the 321044 article of the Microsoft Knowledge Base.
I'm using the LDP utility and type next filter:
servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
I received next reply:
***Searching...
ldap_search_s(ld, "DC=dom,DC=ru", 2,
"servicePrincipalName=MSSQLSvc/comp.dom.ru:1118", attrList, 0, &msg)
Result <0>: (null)
Matched DNs:
Getting 2 entries:[vbcol=seagreen]
1> canonicalName: dom.ru/Domain Controllers/comp;
1> cn: comp;
1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
5> objectClass: top; person; organizationalPerson; user; computer;
1> name: comp;[vbcol=seagreen]
1> canonicalName: <ldp: Binary blob>;
1> cn: <ldp: Binary blob>;
1> description: <ldp: Binary blob>;
1> distinguishedName: <ldp: Binary blob>;
4> objectClass: top; person; organizationalPerson; user;
1> name: <ldp: Binary blob>;
And what? Must I delete comp account? But comp is domain controller.
What can I do?
Michael S. AndrosovHi
Check out the part in the KB that talks about using ADIEdit. You need to
change the incorrect SPN.
John
"Michael S. Androsov" wrote:

> I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
> server is domain controller also.
> I frequently receiving next message in the Event Log of the Windows Server
> 2000 & 2003 computers:
> Source: KDC
> ID: 11
> There are multiple accounts with name MSSQLSvc/comp.dom.ru:1118 of type 10
.
> I'm finding the 321044 article of the Microsoft Knowledge Base.
> I'm using the LDP utility and type next filter:
> servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
> I received next reply:
> ***Searching...
> ldap_search_s(ld, "DC=dom,DC=ru", 2,
> "servicePrincipalName=MSSQLSvc/comp.dom.ru:1118", attrList, 0, &msg)
> Result <0>: (null)
> Matched DNs:
> Getting 2 entries:
> 1> canonicalName: dom.ru/Domain Controllers/comp;
> 1> cn: comp;
> 1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
> 5> objectClass: top; person; organizationalPerson; user; computer;
> 1> name: comp;
> 1> canonicalName: <ldp: Binary blob>;
> 1> cn: <ldp: Binary blob>;
> 1> description: <ldp: Binary blob>;
> 1> distinguishedName: <ldp: Binary blob>;
> 4> objectClass: top; person; organizationalPerson; user;
> 1> name: <ldp: Binary blob>;
> And what? Must I delete comp account? But comp is domain controller.
> What can I do?
> Michael S. Androsov
>|||Hi! Thank you very much for answer.
Excuse me. I'm not master in to the ADSIEdit and AD tools.
Can you help me? What I must doing after ADSIEDit loaded? What I search and
what is the part? I see the partition: Domain NC; Configuration Container an
d
Schema.
I don't know where I must seeking dublicate SPN.
Thanks,
Michael S. Androsov
"John Bell" пишет:
[vbcol=seagreen]
> Hi
> Check out the part in the KB that talks about using ADIEdit. You need to
> change the incorrect SPN.
> John
> "Michael S. Androsov" wrote:
>|||Hi
Your duplicate spn is probably MSSQLSvc/comp.dom.ru. I am not an AD expert
but the following tells you how to search using ADSI Edit
http://support.microsoft.com/defaul...kb;en-us;312299
You may want to post in
http://www.microsoft.com/technet/co...ctive_directory
or
http://www.microsoft.com/technet/co...ctive_directory
John
"Michael S. Androsov" wrote:
[vbcol=seagreen]
> Hi! Thank you very much for answer.
> Excuse me. I'm not master in to the ADSIEdit and AD tools.
> Can you help me? What I must doing after ADSIEDit loaded? What I search an
d
> what is the part? I see the partition: Domain NC; Configuration Container
and
> Schema.
> I don't know where I must seeking dublicate SPN.
> Thanks,
> Michael S. Androsov
> "John Bell" пишет:
>

KDC - 11

I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
server is domain controller also.
I frequently receiving next message in the Event Log:
Source: KDC
ID: 11
There are multiple accounts with name MSSQLSvc/comp.dom.ru:1433 of type 10.
I'm finding the 321044 article of the Microsoft Knowledge Base.
I'm using the LDP utility and type next filter:
servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
I received next reply:
***Searching...
ldap_search_s(ld, "DC=dom,DC=ru", 2,
"servicePrincipalName=MSSQLSvc/comp.dom.ru:1433", attrList, 0, &msg)
Result <0>: (null)
Matched DNs:
Getting 2 entries:[vbcol=seagreen]
1> canonicalName: dom.ru/Domain Controllers/comp;
1> cn: comp;
1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
5> objectClass: top; person; organizationalPerson; user; computer;
1> name: comp;[vbcol=seagreen]
1> canonicalName: <ldp: Binary blob>;
1> cn: <ldp: Binary blob>;
1> description: <ldp: Binary blob>;
1> distinguishedName: <ldp: Binary blob>;
4> objectClass: top; person; organizationalPerson; user;
1> name: <ldp: Binary blob>;
And what? Must I delete comp account? But comp is domain controller.
What can I do?
Michael S. AndrosovThat's one of the reason why it's better not to install SQL on a domain
server.
In mine opinion the trouble comes from LDAP but I'rm not a specialist.
Try a post on the forum concerned.
P.RUELLO
DBA
"Michael S. Androsov" wrote:

> I have a Windows Server 2000 (SP4) with SQL Server 2000 (2 instances). My
> server is domain controller also.
> I frequently receiving next message in the Event Log:
> Source: KDC
> ID: 11
> There are multiple accounts with name MSSQLSvc/comp.dom.ru:1433 of type 10
.
> I'm finding the 321044 article of the Microsoft Knowledge Base.
> I'm using the LDP utility and type next filter:
> servicePrincipalName=MSSQLSvc/comp.dom.ru:1433
> I received next reply:
> ***Searching...
> ldap_search_s(ld, "DC=dom,DC=ru", 2,
> "servicePrincipalName=MSSQLSvc/comp.dom.ru:1433", attrList, 0, &msg)
> Result <0>: (null)
> Matched DNs:
> Getting 2 entries:
> 1> canonicalName: dom.ru/Domain Controllers/comp;
> 1> cn: comp;
> 1> distinguishedName: CN=comp,OU=Domain Controllers,DC=dom,DC=ru;
> 5> objectClass: top; person; organizationalPerson; user; computer;
> 1> name: comp;
> 1> canonicalName: <ldp: Binary blob>;
> 1> cn: <ldp: Binary blob>;
> 1> description: <ldp: Binary blob>;
> 1> distinguishedName: <ldp: Binary blob>;
> 4> objectClass: top; person; organizationalPerson; user;
> 1> name: <ldp: Binary blob>;
> And what? Must I delete comp account? But comp is domain controller.
> What can I do?
> Michael S. Androsov
>|||What is the forum?
Michael S. Androsov
"P.Ruello" пишет:
[vbcol=seagreen]
> That's one of the reason why it's better not to install SQL on a domain
> server.
> In mine opinion the trouble comes from LDAP but I'rm not a specialist.
> Try a post on the forum concerned.
> --
> P.RUELLO
> DBA
>
> "Michael S. Androsov" wrote:
>