Kill process is not working

Trying to kill a process which is causing the following
error in the log every 10 minutes.
Time out occurred while waiting for buffer latch type 2,
bp 0x144e5000, page (5120:811953513), stat 0x405, object
ID 10:1:0, waittime 3500. Continuing to wait.
How can I kill this process?Hi,
Look into the below link:-
Q310834 PRB: Common Causes of Error Message 844 or Error Message 845
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q310834
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:294bc01c465c7$a5ac5b50$a601280a@.phx.gbl...
> Trying to kill a process which is causing the following
> error in the log every 10 minutes.
> Time out occurred while waiting for buffer latch type 2,
> bp 0x144e5000, page (5120:811953513), stat 0x405, object
> ID 10:1:0, waittime 3500. Continuing to wait.
> How can I kill this process?

Kill process is not working

Trying to kill a process which is causing the following
error in the log every 10 minutes.
Time out occurred while waiting for buffer latch type 2,
bp 0x144e5000, page (5120:811953513), stat 0x405, object
ID 10:1:0, waittime 3500. Continuing to wait.
How can I kill this process?
Hi,
Look into the below link:-
Q310834 PRB: Common Causes of Error Message 844 or Error Message 845
http://support.microsoft.com/default...;EN-US;Q310834
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:294bc01c465c7$a5ac5b50$a601280a@.phx.gbl...
> Trying to kill a process which is causing the following
> error in the log every 10 minutes.
> Time out occurred while waiting for buffer latch type 2,
> bp 0x144e5000, page (5120:811953513), stat 0x405, object
> ID 10:1:0, waittime 3500. Continuing to wait.
> How can I kill this process?

key to db error code meaning?

tbh
Open an ERROR.LOG to see what is going on? Deadlocks?
"tbh" <femdev@.newsgroups.nospam> wrote in message
news:OypijxhbIHA.1208@.TK2MSFTNGP03.phx.gbl...
> on a server running SQL Server 2000 we occasionally get errors. the most
> frequent ones in a recent profiler trace, for example, are 208 and 1205.
> i've been searching in vain for an explanation of what these mean. i found
> a key to severity, but not to the meaning of the errors themselves. can
> someone please point me to a guide on the subject?
> cheers,
> Tim Hanson
>
The generic error messages are in master.dbo.sysmessages. E.G.,
Select * From master.dbo.sysmessages Where error = 208
But when you actually get the errors, SQL Server will pass back a string as
well as the error message. This string will have the parameters replaced
with actual values. For example, error 208 is invalid object name, but when
you actually get the message, it will tell you which object name was
invalid. But if whatever connection method you are using is swallowing the
error text and only returning the error number, you can look it up in
sysmessages. You can also search on it in BOL. BOL doesn't have every
error, but it gives additional info about some of them.
Tom
"tbh" <femdev@.newsgroups.nospam> wrote in message
news:%23g3a4iibIHA.4144@.TK2MSFTNGP05.phx.gbl...
> thanks. i was thinking more in terms of a table of definitions. i can find
> hints, e.g., for error 208:
>
> http://www.novicksoftware.com/TipsAndTricks/tip-sql-server-replication-208.htm
> thought maybe there is a summary of error message meanings (or range
> categories) along the lines of what I found for "severity".
> the ones we get appear to be routine. there isn't much in the ERROR.LOGs.
> thanks again,
> tbh
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eAQscEibIHA.536@.TK2MSFTNGP06.phx.gbl...
>

Keeping the transaction log small during initialization

How do I keep the transaction log small during initialization of a
subscription. The size of the transaction gets to be at least four
times the size of the data and fills up the hard drive.
Is there a way to initialize the database without keeping the
transaction logs?
I can't seem to truncate and shrink during initialization either.
Any help is greatly appreciated.
Michael Swart
There is no real way to do this, other than a no sync subscription, or to
kick everyone off your publication database while you generate the snapshot.
You might also want to run DBCC Opentran to see if there are any open
transactions which are causing your tlog to balloon.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Michael Swart" <mjswart@.yahoo.com> wrote in message
news:22f04e15.0408040512.115202ca@.posting.google.c om...
> How do I keep the transaction log small during initialization of a
> subscription. The size of the transaction gets to be at least four
> times the size of the data and fills up the hard drive.
> Is there a way to initialize the database without keeping the
> transaction logs?
> I can't seem to truncate and shrink during initialization either.
> Any help is greatly appreciated.
> Michael Swart

Keeping SQL 2000 databases in synch after restore.

We have 4 different databases, running on sql server 2000. I scheduled
the database to be backed up at 5:00, and every hour for the trans
log.
If we have a hardware failure and have to restore from backup. how do
I make sure that the database are all starting at the same time. (if
database common takes 2 min to back up and database customer takes 30
min to back up) how do I make sure these 2 database are at the same
point in time.
Is there anything I can do in my sql backup job to have the backup's
end at the same time?
Currently all of the backup are different jobs.
Nicholas.GadaczSo you're saying there are transactional integrity reasons why the DB's all
need to be restored to the exact same point in time?
RESTORE LOG allows you to specify STOPAT for point in time recovery, but
RESTORE DATABASE doesn't.
I can't think of a clean way to do that for a full database without using
tran log restores...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"First Tracks Research" <info@.ftresearch.com> wrote in message
news:4d02a84e.0401061017.1db0b24d@.posting.google.com...
> We have 4 different databases, running on sql server 2000. I scheduled
> the database to be backed up at 5:00, and every hour for the trans
> log.
> If we have a hardware failure and have to restore from backup. how do
> I make sure that the database are all starting at the same time. (if
> database common takes 2 min to back up and database customer takes 30
> min to back up) how do I make sure these 2 database are at the same
> point in time.
> Is there anything I can do in my sql backup job to have the backup's
> end at the same time?
> Currently all of the backup are different jobs.
> Nicholas.Gadacz|||I really don't mean to be a smart ass here. I realize it may not be the
answer you are looking for. But this is kind of a design issue. If there
are transactional integrity issues, the easiest and cleanest way is to put
those objects in the same database. You may have name conflicts, but those
will be much easier to resolve now than the issues you have started to run
into now. What if tomorrow you want to send a snapshot replication of five
related tables? You will have the same issue.
If you do take my advice and put your databases into one, a good way to
avoid naming conflicts in your code, is to script one of the databases in
its entirety, do a search and replace and change all occurences of
conflicting names at the object definition as well as the references in code
simultaneously. Then you can put the two together without conflict. Again,
if you decide to do that, I can be made available for assistance remotely.
Pls remove NO_SPAM(s) from my email if you need to reach me.
--
Ata R
Parvan Consulting Inc
NO_SPAMar_alias001@.NO_SPAMparvan.net
"First Tracks Research" <info@.ftresearch.com> wrote in message
news:4d02a84e.0401061017.1db0b24d@.posting.google.com...
> We have 4 different databases, running on sql server 2000. I scheduled
> the database to be backed up at 5:00, and every hour for the trans
> log.
> If we have a hardware failure and have to restore from backup. how do
> I make sure that the database are all starting at the same time. (if
> database common takes 2 min to back up and database customer takes 30
> min to back up) how do I make sure these 2 database are at the same
> point in time.
> Is there anything I can do in my sql backup job to have the backup's
> end at the same time?
> Currently all of the backup are different jobs.
> Nicholas.Gadacz

Keep one connection open for log

I am using SQL 7. If I open one connection for long, I notice that as I keep
running more SQL statement my I/O and CPU Usage keep growing. Even though I
am done with the connection not running any statement I still see those
resouces being used.
Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
Please help.
Hi
Look up 'Connection Pooling' in BOL.
The MDAC driver keeps the connection open by default 120 seconds, and if
another query, to the same saver, using the same credentials comes along on
the same client machine., it just re-uses the existing connection.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:64E68C08-BACE-44A0-9301-2476AA954CD3@.microsoft.com...
> I am using SQL 7. If I open one connection for long, I notice that as I
keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though
I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.
|||I do not agree with you at all. For SQL 7 it is not true. I saw connections
stays there as long as I do not discoonect.
You have not answered any thing of my question. My bad luck is no body else
going to answer this question.
"Astros" wrote:

> I am using SQL 7. If I open one connection for long, I notice that as I keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.
|||Hi
Well, then give us more information. Give us outputs of sp_who2 over
intervals and run profiler at the same time to see what is being submitted
to SQL Server. You might find that there are requests being submitted. There
is no known bug where counters increase themselves for no reason.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> I do not agree with you at all. For SQL 7 it is not true. I saw
connections
> stays there as long as I do not discoonect.
> You have not answered any thing of my question. My bad luck is no body
else[vbcol=seagreen]
> going to answer this question.
> "Astros" wrote:
keep[vbcol=seagreen]
though I[vbcol=seagreen]
|||Hi Mike,
I don't mean to be rude the other day. My application using one connection
and doing same kind of activities again and again. Several hundred time doing
same insert for a different record. It is not cursor as far as SQL server
concern. From within the application it is repeating.
Another situation is: I open query analyser and start using it for different
type of select or updat etc. Using same connection. I see that counter for
I/O and CPU keep increasing. Not necessarily I am using more resouce
consuming SQL but I never see those resouceses being released. Unless I killl
the connection.
Aziz
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Well, then give us more information. Give us outputs of sp_who2 over
> intervals and run profiler at the same time to see what is being submitted
> to SQL Server. You might find that there are requests being submitted. There
> is no known bug where counters increase themselves for no reason.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> connections
> else
> keep
> though I
>
>

Keep one connection open for log

I am using SQL 7. If I open one connection for long, I notice that as I keep
running more SQL statement my I/O and CPU Usage keep growing. Even though I
am done with the connection not running any statement I still see those
resouces being used.
Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
Please help.Hi
Look up 'Connection Pooling' in BOL.
The MDAC driver keeps the connection open by default 120 seconds, and if
another query, to the same saver, using the same credentials comes along on
the same client machine., it just re-uses the existing connection.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:64E68C08-BACE-44A0-9301-2476AA954CD3@.microsoft.com...
> I am using SQL 7. If I open one connection for long, I notice that as I
keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though
I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.|||I do not agree with you at all. For SQL 7 it is not true. I saw connections
stays there as long as I do not discoonect.
You have not answered any thing of my question. My bad luck is no body else
going to answer this question.
"Astros" wrote:
> I am using SQL 7. If I open one connection for long, I notice that as I keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.|||Hi
Well, then give us more information. Give us outputs of sp_who2 over
intervals and run profiler at the same time to see what is being submitted
to SQL Server. You might find that there are requests being submitted. There
is no known bug where counters increase themselves for no reason.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> I do not agree with you at all. For SQL 7 it is not true. I saw
connections
> stays there as long as I do not discoonect.
> You have not answered any thing of my question. My bad luck is no body
else
> going to answer this question.
> "Astros" wrote:
> > I am using SQL 7. If I open one connection for long, I notice that as I
keep
> > running more SQL statement my I/O and CPU Usage keep growing. Even
though I
> > am done with the connection not running any statement I still see those
> > resouces being used.
> >
> > Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> >
> > Please help.|||Hi Mike,
I don't mean to be rude the other day. My application using one connection
and doing same kind of activities again and again. Several hundred time doing
same insert for a different record. It is not cursor as far as SQL server
concern. From within the application it is repeating.
Another situation is: I open query analyser and start using it for different
type of select or updat etc. Using same connection. I see that counter for
I/O and CPU keep increasing. Not necessarily I am using more resouce
consuming SQL but I never see those resouceses being released. Unless I killl
the connection.
Aziz
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Well, then give us more information. Give us outputs of sp_who2 over
> intervals and run profiler at the same time to see what is being submitted
> to SQL Server. You might find that there are requests being submitted. There
> is no known bug where counters increase themselves for no reason.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> > I do not agree with you at all. For SQL 7 it is not true. I saw
> connections
> > stays there as long as I do not discoonect.
> >
> > You have not answered any thing of my question. My bad luck is no body
> else
> > going to answer this question.
> >
> > "Astros" wrote:
> >
> > > I am using SQL 7. If I open one connection for long, I notice that as I
> keep
> > > running more SQL statement my I/O and CPU Usage keep growing. Even
> though I
> > > am done with the connection not running any statement I still see those
> > > resouces being used.
> > >
> > > Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> > >
> > > Please help.
>
>

Keep one connection open for log

I am using SQL 7. If I open one connection for long, I notice that as I keep
running more SQL statement my I/O and CPU Usage keep growing. Even though I
am done with the connection not running any statement I still see those
resouces being used.
Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
Please help.Hi
Look up 'Connection Pooling' in BOL.
The MDAC driver keeps the connection open by default 120 seconds, and if
another query, to the same saver, using the same credentials comes along on
the same client machine., it just re-uses the existing connection.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:64E68C08-BACE-44A0-9301-2476AA954CD3@.microsoft.com...
> I am using SQL 7. If I open one connection for long, I notice that as I
keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though
I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.|||I do not agree with you at all. For SQL 7 it is not true. I saw connections
stays there as long as I do not discoonect.
You have not answered any thing of my question. My bad luck is no body else
going to answer this question.
"Astros" wrote:

> I am using SQL 7. If I open one connection for long, I notice that as I ke
ep
> running more SQL statement my I/O and CPU Usage keep growing. Even though
I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.|||Hi
Well, then give us more information. Give us outputs of sp_who2 over
intervals and run profiler at the same time to see what is being submitted
to SQL Server. You might find that there are requests being submitted. There
is no known bug where counters increase themselves for no reason.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> I do not agree with you at all. For SQL 7 it is not true. I saw
connections
> stays there as long as I do not discoonect.
> You have not answered any thing of my question. My bad luck is no body
else[vbcol=seagreen]
> going to answer this question.
> "Astros" wrote:
>
keep[vbcol=seagreen]
though I[vbcol=seagreen]|||Hi Mike,
I don't mean to be rude the other day. My application using one connection
and doing same kind of activities again and again. Several hundred time doin
g
same insert for a different record. It is not cursor as far as SQL server
concern. From within the application it is repeating.
Another situation is: I open query analyser and start using it for different
type of select or updat etc. Using same connection. I see that counter for
I/O and CPU keep increasing. Not necessarily I am using more resouce
consuming SQL but I never see those resouceses being released. Unless I kill
l
the connection.
Aziz
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Well, then give us more information. Give us outputs of sp_who2 over
> intervals and run profiler at the same time to see what is being submitted
> to SQL Server. You might find that there are requests being submitted. The
re
> is no known bug where counters increase themselves for no reason.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> connections
> else
> keep
> though I
>
>

KDC Problem

Hello:
A while back I started getting KDC errors in my System log on my domain
controller. The error is:
Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 3/16/2005
Time: 9:34:08 AM
User: N/A
Computer: TPADC1
Description:
There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
type 10.
After researching this I did a "ldifde" dump of the active directory
database and then searched the dump and found a double entry for
"MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
domain admins accounts. Since this appeared to be a duplicate I decided to
delete it. Within a few minutes I had problems with connections to SQL. I
put it back right away and then everything was working fine again.
Obviously the SQL server has some kind of a link to this...
I have done some searching but have not found anything on it. Does anyone
have any suggestions on cleaning this up?
Harrison Midkiff
Have a look at http://support.microsoft.com/default...b;en-us;321044
Peter
"Do not awake the sleeping dragon for you are crunchy and taste good with
ketchup".
Peter The Spate
"Harrison Midkiff" wrote:

> Hello:
> A while back I started getting KDC errors in my System log on my domain
> controller. The error is:
> Event Type: Error
> Event Source: KDC
> Event Category: None
> Event ID: 11
> Date: 3/16/2005
> Time: 9:34:08 AM
> User: N/A
> Computer: TPADC1
> Description:
> There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
> type 10.
> After researching this I did a "ldifde" dump of the active directory
> database and then searched the dump and found a double entry for
> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
> domain admins accounts. Since this appeared to be a duplicate I decided to
> delete it. Within a few minutes I had problems with connections to SQL. I
> put it back right away and then everything was working fine again.
> Obviously the SQL server has some kind of a link to this...
> I have done some searching but have not found anything on it. Does anyone
> have any suggestions on cleaning this up?
> Harrison Midkiff
>
>
|||Peter:
Thanks for replying to my post.
This is the article I followed which allowed me to find the duplicate but is
was on a user account not a computer account. I think perhaps SQL has
something in it hard coded to reference this user account.
Any suggestions welcome...
Harrison Midkiff
"Peter 'Not Peter The Spate' Nolan"
<PeterNotPeterTheSpateNolan@.discussions.microsoft. com> wrote in message
news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...[vbcol=seagreen]
> Have a look at
> http://support.microsoft.com/default...b;en-us;321044
> Peter
> "Do not awake the sleeping dragon for you are crunchy and taste good with
> ketchup".
> Peter The Spate
> "Harrison Midkiff" wrote:
|||try with setspn tool
or
1. use adsiedit.msc and show servicePrincipalName for your sql server
(computer account)
2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
delete duplicated spn
-- -- "Within a few minutes I had problems with connections to SQL. "
what? error message?
"Harrison Midkiff" wrote:

> Peter:
> Thanks for replying to my post.
> This is the article I followed which allowed me to find the duplicate but is
> was on a user account not a computer account. I think perhaps SQL has
> something in it hard coded to reference this user account.
> Any suggestions welcome...
> Harrison Midkiff
> "Peter 'Not Peter The Spate' Nolan"
> <PeterNotPeterTheSpateNolan@.discussions.microsoft. com> wrote in message
> news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
>
>
|||Yes. To determine which domain account is the one that is currently being
used, we can use Adsiedit.msc to delete one of the
MSSQLSvc/elvis.aviinc.local:1433 SPNs, then *restart* the SQL service(s).
The SQL service will re-add the SPN on the currently used service account.
If it was not readded, then the duplicate has been removed.
Adsiedit.msc and Ldp.exe are included on the Windows 2000 installation CD.
You can install these tools from the CD in Support\Tools\Setup.exe
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: KDC Problem
>thread-index: AcUqezBszBBVWy/FSSSK8UVZqmT1Hg==
>X-WBNR-Posting-Host: 212.200.135.192
>From: "=?Utf-8?B?QWxla3NhbmRhciBHcmJpYw==?="
<AleksandarGrbic@.discussions.microsoft.com>
>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
<AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
<#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>[vbcol=seagreen]
>Subject: Re: KDC Problem
>Date: Wed, 16 Mar 2005 14:55:03 -0800
>Lines: 81
>Message-ID: <3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382093
>X-Tomcat-NG: microsoft.public.sqlserver.server
>try with setspn tool
>or
>1. use adsiedit.msc and show servicePrincipalName for your sql server
>(computer account)
>2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
>delete duplicated spn
>-- -- "Within a few minutes I had problems with connections to SQL. "
>what? error message?
>
>
>"Harrison Midkiff" wrote:
but is[vbcol=seagreen]
with[vbcol=seagreen]
domain[vbcol=seagreen]
MSSQLSvc/elvis.aviinc.local:1433 of[vbcol=seagreen]
the[vbcol=seagreen]
decided[vbcol=seagreen]
SQL.
>
|||Aleksandar:
Thanks for replying to my post.
The error which was appearing on the SQL Enterprise Manager was, "Unable to initialize SSPI context".
Any suggestions?
Harrison Midkiff
"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...[vbcol=seagreen]
> try with setspn tool
> or
> 1. use adsiedit.msc and show servicePrincipalName for your sql server
> (computer account)
> 2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
> delete duplicated spn
> -- -- "Within a few minutes I had problems with connections to SQL. "
> what? error message?
>
>
> "Harrison Midkiff" wrote:
|||Hi Harrison,
You may want to restart the SQL Server service after you have removed the
duplicate SPN. If the SPN is re-added, remove the other SPN and then
restart the SQL Server service.
Feel free to let me know if this resolves your problem.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
<AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
<#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
<3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
>Subject: Re: KDC Problem
>Date: Thu, 17 Mar 2005 13:03:45 -0500
>Lines: 254
>Organization: Audio Visual Innovations, Inc.
>MIME-Version: 1.0
>Content-Type: multipart/alternative;
>boundary="--=_NextPart_000_012E_01C52AF1.C085DB50"
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 208.5.55.183
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!TK2MSFTNGP0
9.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382241
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Aleksandar:
>Thanks for replying to my post.
>The error which was appearing on the SQL Enterprise Manager was, "Unable
to initialize SSPI context".
>Any suggestions?
>Harrison Midkiff
>"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...[vbcol=seagreen]
(computer account)[vbcol=seagreen]
what? error message?[vbcol=seagreen]
but is[vbcol=seagreen]
with[vbcol=seagreen]
domain[vbcol=seagreen]
MSSQLSvc/elvis.aviinc.local:1433 of[vbcol=seagreen]
the[vbcol=seagreen]
decided[vbcol=seagreen]
SQL.
>
|||In almost every case I remember SSPI errors was related with wrong DNS
records, so check the DNS.
(ex computer name is London instead of London.nwtraders.msft ) SETSPN works
with FQDN only.
Regards,
Daniel
"Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
news:uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl...
> Hello:
> A while back I started getting KDC errors in my System log on my domain
> controller. The error is:
> Event Type: Error
> Event Source: KDC
> Event Category: None
> Event ID: 11
> Date: 3/16/2005
> Time: 9:34:08 AM
> User: N/A
> Computer: TPADC1
> Description:
> There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
> type 10.
> After researching this I did a "ldifde" dump of the active directory
> database and then searched the dump and found a double entry for
> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
> domain admins accounts. Since this appeared to be a duplicate I decided
to
> delete it. Within a few minutes I had problems with connections to SQL.
I
> put it back right away and then everything was working fine again.
> Obviously the SQL server has some kind of a link to this...
> I have done some searching but have not found anything on it. Does anyone
> have any suggestions on cleaning this up?
> Harrison Midkiff
>
|||William:
Thanks for replying to my post. Do you know of any tech net articles which
may explain this behavior. The reason I ask is due to the sensitive nature
of SQL we are going to have a meeting before we attempt any changes.
Thanks.
Harrison Midkiff
"William Wang[MSFT]" <v-rxwang@.online.microsoft.com> wrote in message
news:lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl...
> Hi Harrison,
> You may want to restart the SQL Server service after you have removed the
> duplicate SPN. If the SPN is re-added, remove the other SPN and then
> restart the SQL Server service.
> Feel free to let me know if this resolves your problem.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
> <AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
> <#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
> <3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!TK2MSFTNGP0
> 9.phx.gbl
> to initialize SSPI context".
> message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...
> (computer account)
> what? error message?
> but is
> with
> domain
> MSSQLSvc/elvis.aviinc.local:1433 of
> the
> decided
> SQL.
>
|||Hi Harrison,
The relevent articles I could find are:
305971 Windows 2000 Server Prompts Domain User for Credentials
http://support.microsoft.com/?id=305971
811889 HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/?id=811889
HTH!
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
<AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
<#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
<3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
<O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
<lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl>
>Subject: Re: KDC Problem
>Date: Wed, 23 Mar 2005 08:32:22 -0500
>Lines: 155
>Organization: Audio Visual Innovations, Inc.
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <Oi9BAz6LFHA.3328@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 208.5.55.190
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!TK2MSFTNGP1
4.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382949
>X-Tomcat-NG: microsoft.public.sqlserver.server
>William:
>Thanks for replying to my post. Do you know of any tech net articles
which
>may explain this behavior. The reason I ask is due to the sensitive
nature[vbcol=seagreen]
>of SQL we are going to have a meeting before we attempt any changes.
>Thanks.
>Harrison Midkiff
>"William Wang[MSFT]" <v-rxwang@.online.microsoft.com> wrote in message
>news:lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl...
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!TK2MSFTNGP0[vbcol=seagreen]
>
message[vbcol=seagreen]
directory[vbcol=seagreen]
of
>
>

KDC Problem

Hello:
A while back I started getting KDC errors in my System log on my domain
controller. The error is:
Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 3/16/2005
Time: 9:34:08 AM
User: N/A
Computer: TPADC1
Description:
There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
type 10.
After researching this I did a "ldifde" dump of the active directory
database and then searched the dump and found a double entry for
"MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
domain admins accounts. Since this appeared to be a duplicate I decided to
delete it. Within a few minutes I had problems with connections to SQL. I
put it back right away and then everything was working fine again.
Obviously the SQL server has some kind of a link to this...
I have done some searching but have not found anything on it. Does anyone
have any suggestions on cleaning this up?
Harrison MidkiffHave a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;321044
Peter
"Do not awake the sleeping dragon for you are crunchy and taste good with
ketchup".
Peter The Spate
"Harrison Midkiff" wrote:
> Hello:
> A while back I started getting KDC errors in my System log on my domain
> controller. The error is:
> Event Type: Error
> Event Source: KDC
> Event Category: None
> Event ID: 11
> Date: 3/16/2005
> Time: 9:34:08 AM
> User: N/A
> Computer: TPADC1
> Description:
> There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
> type 10.
> After researching this I did a "ldifde" dump of the active directory
> database and then searched the dump and found a double entry for
> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
> domain admins accounts. Since this appeared to be a duplicate I decided to
> delete it. Within a few minutes I had problems with connections to SQL. I
> put it back right away and then everything was working fine again.
> Obviously the SQL server has some kind of a link to this...
> I have done some searching but have not found anything on it. Does anyone
> have any suggestions on cleaning this up?
> Harrison Midkiff
>
>|||Peter:
Thanks for replying to my post.
This is the article I followed which allowed me to find the duplicate but is
was on a user account not a computer account. I think perhaps SQL has
something in it hard coded to reference this user account.
Any suggestions welcome...
Harrison Midkiff
"Peter 'Not Peter The Spate' Nolan"
<PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in message
news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
> Have a look at
> http://support.microsoft.com/default.aspx?scid=kb;en-us;321044
> Peter
> "Do not awake the sleeping dragon for you are crunchy and taste good with
> ketchup".
> Peter The Spate
> "Harrison Midkiff" wrote:
>> Hello:
>> A while back I started getting KDC errors in my System log on my domain
>> controller. The error is:
>> Event Type: Error
>> Event Source: KDC
>> Event Category: None
>> Event ID: 11
>> Date: 3/16/2005
>> Time: 9:34:08 AM
>> User: N/A
>> Computer: TPADC1
>> Description:
>> There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
>> type 10.
>> After researching this I did a "ldifde" dump of the active directory
>> database and then searched the dump and found a double entry for
>> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
>> domain admins accounts. Since this appeared to be a duplicate I decided
>> to
>> delete it. Within a few minutes I had problems with connections to SQL.
>> I
>> put it back right away and then everything was working fine again.
>> Obviously the SQL server has some kind of a link to this...
>> I have done some searching but have not found anything on it. Does
>> anyone
>> have any suggestions on cleaning this up?
>> Harrison Midkiff
>>|||try with setspn tool
or
1. use adsiedit.msc and show servicePrincipalName for your sql server
(computer account)
2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
delete duplicated spn
-- -- "Within a few minutes I had problems with connections to SQL. "
what? error message'
"Harrison Midkiff" wrote:
> Peter:
> Thanks for replying to my post.
> This is the article I followed which allowed me to find the duplicate but is
> was on a user account not a computer account. I think perhaps SQL has
> something in it hard coded to reference this user account.
> Any suggestions welcome...
> Harrison Midkiff
> "Peter 'Not Peter The Spate' Nolan"
> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in message
> news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
> > Have a look at
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;321044
> >
> > Peter
> >
> > "Do not awake the sleeping dragon for you are crunchy and taste good with
> > ketchup".
> > Peter The Spate
> >
> > "Harrison Midkiff" wrote:
> >
> >> Hello:
> >>
> >> A while back I started getting KDC errors in my System log on my domain
> >> controller. The error is:
> >>
> >> Event Type: Error
> >> Event Source: KDC
> >> Event Category: None
> >> Event ID: 11
> >> Date: 3/16/2005
> >> Time: 9:34:08 AM
> >> User: N/A
> >> Computer: TPADC1
> >> Description:
> >> There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
> >> type 10.
> >>
> >> After researching this I did a "ldifde" dump of the active directory
> >> database and then searched the dump and found a double entry for
> >> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
> >> domain admins accounts. Since this appeared to be a duplicate I decided
> >> to
> >> delete it. Within a few minutes I had problems with connections to SQL.
> >> I
> >> put it back right away and then everything was working fine again.
> >> Obviously the SQL server has some kind of a link to this...
> >>
> >> I have done some searching but have not found anything on it. Does
> >> anyone
> >> have any suggestions on cleaning this up?
> >>
> >> Harrison Midkiff
> >>
> >>
> >>
>
>|||Yes. To determine which domain account is the one that is currently being
used, we can use Adsiedit.msc to delete one of the
MSSQLSvc/elvis.aviinc.local:1433 SPNs, then *restart* the SQL service(s).
The SQL service will re-add the SPN on the currently used service account.
If it was not readded, then the duplicate has been removed.
Adsiedit.msc and Ldp.exe are included on the Windows 2000 installation CD.
You can install these tools from the CD in Support\Tools\Setup.exe
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: KDC Problem
>thread-index: AcUqezBszBBVWy/FSSSK8UVZqmT1Hg==>X-WBNR-Posting-Host: 212.200.135.192
>From: "=?Utf-8?B?QWxla3NhbmRhciBHcmJpYw==?="
<AleksandarGrbic@.discussions.microsoft.com>
>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
<AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
<#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
>Subject: Re: KDC Problem
>Date: Wed, 16 Mar 2005 14:55:03 -0800
>Lines: 81
>Message-ID: <3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382093
>X-Tomcat-NG: microsoft.public.sqlserver.server
>try with setspn tool
>or
>1. use adsiedit.msc and show servicePrincipalName for your sql server
>(computer account)
>2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
>delete duplicated spn
>-- -- "Within a few minutes I had problems with connections to SQL. "
>what? error message'
>
>
>"Harrison Midkiff" wrote:
>> Peter:
>> Thanks for replying to my post.
>> This is the article I followed which allowed me to find the duplicate
but is
>> was on a user account not a computer account. I think perhaps SQL has
>> something in it hard coded to reference this user account.
>> Any suggestions welcome...
>> Harrison Midkiff
>> "Peter 'Not Peter The Spate' Nolan"
>> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in message
>> news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
>> > Have a look at
>> > http://support.microsoft.com/default.aspx?scid=kb;en-us;321044
>> >
>> > Peter
>> >
>> > "Do not awake the sleeping dragon for you are crunchy and taste good
with
>> > ketchup".
>> > Peter The Spate
>> >
>> > "Harrison Midkiff" wrote:
>> >
>> >> Hello:
>> >>
>> >> A while back I started getting KDC errors in my System log on my
domain
>> >> controller. The error is:
>> >>
>> >> Event Type: Error
>> >> Event Source: KDC
>> >> Event Category: None
>> >> Event ID: 11
>> >> Date: 3/16/2005
>> >> Time: 9:34:08 AM
>> >> User: N/A
>> >> Computer: TPADC1
>> >> Description:
>> >> There are multiple accounts with name
MSSQLSvc/elvis.aviinc.local:1433 of
>> >> type 10.
>> >>
>> >> After researching this I did a "ldifde" dump of the active directory
>> >> database and then searched the dump and found a double entry for
>> >> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of
the
>> >> domain admins accounts. Since this appeared to be a duplicate I
decided
>> >> to
>> >> delete it. Within a few minutes I had problems with connections to
SQL.
>> >> I
>> >> put it back right away and then everything was working fine again.
>> >> Obviously the SQL server has some kind of a link to this...
>> >>
>> >> I have done some searching but have not found anything on it. Does
>> >> anyone
>> >> have any suggestions on cleaning this up?
>> >>
>> >> Harrison Midkiff
>> >>
>> >>
>> >>
>>
>|||This is a multi-part message in MIME format.
--=_NextPart_000_012E_01C52AF1.C085DB50
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Aleksandar:
Thanks for replying to my post.
The error which was appearing on the SQL Enterprise Manager was, "Unable =to initialize SSPI context".
Any suggestions?
Harrison Midkiff
"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in =message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...
> try with setspn tool
> > or > > 1. use adsiedit.msc and show servicePrincipalName for your sql server =
> (computer account)
> > 2. use ldp.exe and search for "servicePrincipalName=3DMSSQLSvc/elvis*"
> delete duplicated spn
> > -- -- "Within a few minutes I had problems with connections to SQL. " =
> what? error message'
> > > > > "Harrison Midkiff" wrote:
> >> Peter:
>> >> Thanks for replying to my post.
>> >> This is the article I followed which allowed me to find the duplicate =but is >> was on a user account not a computer account. I think perhaps SQL =has >> something in it hard coded to reference this user account.
>> >> Any suggestions welcome...
>> >> Harrison Midkiff
>> "Peter 'Not Peter The Spate' Nolan" >> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in =message >> news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
>> > Have a look at >> > http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;321044
>> >
>> > Peter
>> >
>> > "Do not awake the sleeping dragon for you are crunchy and taste =good with
>> > ketchup".
>> > Peter The Spate
>> >
>> > "Harrison Midkiff" wrote:
>> >
>> >> Hello:
>> >>
>> >> A while back I started getting KDC errors in my System log on my =domain
>> >> controller. The error is:
>> >>
>> >> Event Type: Error
>> >> Event Source: KDC
>> >> Event Category: None
>> >> Event ID: 11
>> >> Date: 3/16/2005
>> >> Time: 9:34:08 AM
>> >> User: N/A
>> >> Computer: TPADC1
>> >> Description:
>> >> There are multiple accounts with name =MSSQLSvc/elvis.aviinc.local:1433 of
>> >> type 10.
>> >>
>> >> After researching this I did a "ldifde" dump of the active =directory
>> >> database and then searched the dump and found a double entry for
>> >> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one =of the
>> >> domain admins accounts. Since this appeared to be a duplicate I =decided >> >> to
>> >> delete it. Within a few minutes I had problems with connections =to SQL. >> >> I
>> >> put it back right away and then everything was working fine again.
>> >> Obviously the SQL server has some kind of a link to this...
>> >>
>> >> I have done some searching but have not found anything on it. =Does >> >> anyone
>> >> have any suggestions on cleaning this up?
>> >>
>> >> Harrison Midkiff
>> >>
>> >>
>> >> >> >> --=_NextPart_000_012E_01C52AF1.C085DB50
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Aleksandar:
Thanks for replying to my =post.
The error which was appearing on =the SQL Enterprise Manager was, "Unable to =initialize SSPI context".
Any suggestions?
Harrison Midkiff
"Aleksandar Grbic" wrote in message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...> =try with setspn tool> > or > > 1. use adsiedit.msc and show servicePrincipalName for your sql server > (computer account)> > 2. use ldp.exe and search for "servicePrincipalName=3DMSSQLSvc/elvis*"> delete duplicated =spn> > -- -- "Within a few minutes I had problems with connections to =SQL. " > what? error message'> > > => > "Harrison Midkiff" wrote:> > Peter:> > Thanks for replying to my =post.> > This is the article I followed which allowed me to find the =duplicate but is > was on a user account not a computer account. I think perhaps SQL has > something in it hard =coded to reference this user account.> > Any suggestions =welcome...> > Harrison Midkiff> "Peter ='Not Peter The Spate' Nolan" > wrote in message > news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...> > Have a look at > => http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;321044=> >> > Peter> >> > "Do not awake the sleeping dragon for you are =crunchy and taste good with> > ketchup".> > Peter The Spate> >> > "Harrison Midkiff" =wrote:> >> >> Hello:> >>> =>> A while back I started getting KDC errors in my System log on my domain> >> controller. The error is:> >>> >> Event Type: Error> >> =Event Source: KDC> >> Event Category: None> =>> Event ID: 11> >> Date: 3/16/2005> >> Time: 9:34:08 AM> >> User: N/A> =>> Computer: TPADC1> >> Description:> >> =There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 =of> >> type 10.> >>> >> After =researching this I did a "ldifde" dump of the active directory> >> =database and then searched the dump and found a double entry for> =>> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one =of the> >> domain admins accounts. Since this =appeared to be a duplicate I decided > >> to> >> =delete it. Within a few minutes I had problems with connections to SQL. > >> I> >> put it back right away and =then everything was working fine again.> >> Obviously the =SQL server has some kind of a link to this...> >>> =>> I have done some searching but have not found anything on it. Does > >> anyone> >> have any suggestions =on cleaning this up?> >>> >> Harrison Midkiff> >>> >>> >> > > >

---

--=_NextPart_000_012E_01C52AF1.C085DB50--|||Hi Harrison,
You may want to restart the SQL Server service after you have removed the
duplicate SPN. If the SPN is re-added, remove the other SPN and then
restart the SQL Server service.
Feel free to let me know if this resolves your problem.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
<AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
<#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
<3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
>Subject: Re: KDC Problem
>Date: Thu, 17 Mar 2005 13:03:45 -0500
>Lines: 254
>Organization: Audio Visual Innovations, Inc.
>MIME-Version: 1.0
>Content-Type: multipart/alternative;
> boundary="--=_NextPart_000_012E_01C52AF1.C085DB50"
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 208.5.55.183
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
9.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382241
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Aleksandar:
>Thanks for replying to my post.
>The error which was appearing on the SQL Enterprise Manager was, "Unable
to initialize SSPI context".
>Any suggestions?
>Harrison Midkiff
>"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...
>> try with setspn tool
>> or
>> 1. use adsiedit.msc and show servicePrincipalName for your sql server >
(computer account)
>> 2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
>> delete duplicated spn
>> -- -- "Within a few minutes I had problems with connections to SQL. " >
what? error message'
>>
>>
>> "Harrison Midkiff" wrote:
>> Peter:
>> Thanks for replying to my post.
>> This is the article I followed which allowed me to find the duplicate
but is
>> was on a user account not a computer account. I think perhaps SQL has
>> something in it hard coded to reference this user account.
>> Any suggestions welcome...
>> Harrison Midkiff
>> "Peter 'Not Peter The Spate' Nolan"
>> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in message
>> news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
>> > Have a look at
>> > http://support.microsoft.com/default.aspx?scid=kb;en-us;321044
>> >
>> > Peter
>> >
>> > "Do not awake the sleeping dragon for you are crunchy and taste good
with
>> > ketchup".
>> > Peter The Spate
>> >
>> > "Harrison Midkiff" wrote:
>> >
>> >> Hello:
>> >>
>> >> A while back I started getting KDC errors in my System log on my
domain
>> >> controller. The error is:
>> >>
>> >> Event Type: Error
>> >> Event Source: KDC
>> >> Event Category: None
>> >> Event ID: 11
>> >> Date: 3/16/2005
>> >> Time: 9:34:08 AM
>> >> User: N/A
>> >> Computer: TPADC1
>> >> Description:
>> >> There are multiple accounts with name
MSSQLSvc/elvis.aviinc.local:1433 of
>> >> type 10.
>> >>
>> >> After researching this I did a "ldifde" dump of the active directory
>> >> database and then searched the dump and found a double entry for
>> >> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of
the
>> >> domain admins accounts. Since this appeared to be a duplicate I
decided
>> >> to
>> >> delete it. Within a few minutes I had problems with connections to
SQL.
>> >> I
>> >> put it back right away and then everything was working fine again.
>> >> Obviously the SQL server has some kind of a link to this...
>> >>
>> >> I have done some searching but have not found anything on it. Does
>> >> anyone
>> >> have any suggestions on cleaning this up?
>> >>
>> >> Harrison Midkiff
>> >>
>> >>
>> >>
>>
>|||In almost every case I remember SSPI errors was related with wrong DNS
records, so check the DNS.
(ex computer name is London instead of London.nwtraders.msft ) SETSPN works
with FQDN only.
Regards,
Daniel
"Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
news:uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl...
> Hello:
> A while back I started getting KDC errors in my System log on my domain
> controller. The error is:
> Event Type: Error
> Event Source: KDC
> Event Category: None
> Event ID: 11
> Date: 3/16/2005
> Time: 9:34:08 AM
> User: N/A
> Computer: TPADC1
> Description:
> There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
> type 10.
> After researching this I did a "ldifde" dump of the active directory
> database and then searched the dump and found a double entry for
> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
> domain admins accounts. Since this appeared to be a duplicate I decided
to
> delete it. Within a few minutes I had problems with connections to SQL.
I
> put it back right away and then everything was working fine again.
> Obviously the SQL server has some kind of a link to this...
> I have done some searching but have not found anything on it. Does anyone
> have any suggestions on cleaning this up?
> Harrison Midkiff
>|||William:
Thanks for replying to my post. Do you know of any tech net articles which
may explain this behavior. The reason I ask is due to the sensitive nature
of SQL we are going to have a meeting before we attempt any changes.
Thanks.
Harrison Midkiff
"William Wang[MSFT]" <v-rxwang@.online.microsoft.com> wrote in message
news:lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl...
> Hi Harrison,
> You may want to restart the SQL Server service after you have removed the
> duplicate SPN. If the SPN is re-added, remove the other SPN and then
> restart the SQL Server service.
> Feel free to let me know if this resolves your problem.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
>>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
> <AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
> <#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
> <3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
>>Subject: Re: KDC Problem
>>Date: Thu, 17 Mar 2005 13:03:45 -0500
>>Lines: 254
>>Organization: Audio Visual Innovations, Inc.
>>MIME-Version: 1.0
>>Content-Type: multipart/alternative;
>> boundary="--=_NextPart_000_012E_01C52AF1.C085DB50"
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 208.5.55.183
>>Path:
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
> 9.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382241
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Aleksandar:
>>Thanks for replying to my post.
>>The error which was appearing on the SQL Enterprise Manager was, "Unable
> to initialize SSPI context".
>>Any suggestions?
>>Harrison Midkiff
>>"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
> message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...
>> try with setspn tool
>> or
>> 1. use adsiedit.msc and show servicePrincipalName for your sql server >
> (computer account)
>> 2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
>> delete duplicated spn
>> -- -- "Within a few minutes I had problems with connections to SQL. " >
> what? error message'
>>
>>
>> "Harrison Midkiff" wrote:
>> Peter:
>> Thanks for replying to my post.
>> This is the article I followed which allowed me to find the duplicate
> but is
>> was on a user account not a computer account. I think perhaps SQL has
>> something in it hard coded to reference this user account.
>> Any suggestions welcome...
>> Harrison Midkiff
>> "Peter 'Not Peter The Spate' Nolan"
>> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in message
>> news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
>> > Have a look at
>> > http://support.microsoft.com/default.aspx?scid=kb;en-us;321044
>> >
>> > Peter
>> >
>> > "Do not awake the sleeping dragon for you are crunchy and taste good
> with
>> > ketchup".
>> > Peter The Spate
>> >
>> > "Harrison Midkiff" wrote:
>> >
>> >> Hello:
>> >>
>> >> A while back I started getting KDC errors in my System log on my
> domain
>> >> controller. The error is:
>> >>
>> >> Event Type: Error
>> >> Event Source: KDC
>> >> Event Category: None
>> >> Event ID: 11
>> >> Date: 3/16/2005
>> >> Time: 9:34:08 AM
>> >> User: N/A
>> >> Computer: TPADC1
>> >> Description:
>> >> There are multiple accounts with name
> MSSQLSvc/elvis.aviinc.local:1433 of
>> >> type 10.
>> >>
>> >> After researching this I did a "ldifde" dump of the active directory
>> >> database and then searched the dump and found a double entry for
>> >> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of
> the
>> >> domain admins accounts. Since this appeared to be a duplicate I
> decided
>> >> to
>> >> delete it. Within a few minutes I had problems with connections to
> SQL.
>> >> I
>> >> put it back right away and then everything was working fine again.
>> >> Obviously the SQL server has some kind of a link to this...
>> >>
>> >> I have done some searching but have not found anything on it. Does
>> >> anyone
>> >> have any suggestions on cleaning this up?
>> >>
>> >> Harrison Midkiff
>> >>
>> >>
>> >>
>>
>>
>|||Hi Harrison,
The relevent articles I could find are:
305971 Windows 2000 Server Prompts Domain User for Credentials
http://support.microsoft.com/?id=305971
811889 HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/?id=811889
HTH!
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
<AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
<#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
<3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
<O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
<lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl>
>Subject: Re: KDC Problem
>Date: Wed, 23 Mar 2005 08:32:22 -0500
>Lines: 155
>Organization: Audio Visual Innovations, Inc.
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <Oi9BAz6LFHA.3328@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 208.5.55.190
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
4.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382949
>X-Tomcat-NG: microsoft.public.sqlserver.server
>William:
>Thanks for replying to my post. Do you know of any tech net articles
which
>may explain this behavior. The reason I ask is due to the sensitive
nature
>of SQL we are going to have a meeting before we attempt any changes.
>Thanks.
>Harrison Midkiff
>"William Wang[MSFT]" <v-rxwang@.online.microsoft.com> wrote in message
>news:lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl...
>> Hi Harrison,
>> You may want to restart the SQL Server service after you have removed the
>> duplicate SPN. If the SPN is re-added, remove the other SPN and then
>> restart the SQL Server service.
>> Feel free to let me know if this resolves your problem.
>> Sincerely,
>> William Wang
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> --
>>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
>> <AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
>> <#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
>> <3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
>>Subject: Re: KDC Problem
>>Date: Thu, 17 Mar 2005 13:03:45 -0500
>>Lines: 254
>>Organization: Audio Visual Innovations, Inc.
>>MIME-Version: 1.0
>>Content-Type: multipart/alternative;
>> boundary="--=_NextPart_000_012E_01C52AF1.C085DB50"
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 208.5.55.183
>>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
>> 9.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382241
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Aleksandar:
>>Thanks for replying to my post.
>>The error which was appearing on the SQL Enterprise Manager was, "Unable
>> to initialize SSPI context".
>>Any suggestions?
>>Harrison Midkiff
>>"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
>> message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...
>> try with setspn tool
>> or
>> 1. use adsiedit.msc and show servicePrincipalName for your sql server
>> (computer account)
>> 2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
>> delete duplicated spn
>> -- -- "Within a few minutes I had problems with connections to SQL. "
>> what? error message'
>>
>>
>> "Harrison Midkiff" wrote:
>> Peter:
>> Thanks for replying to my post.
>> This is the article I followed which allowed me to find the duplicate
>> but is
>> was on a user account not a computer account. I think perhaps SQL has
>> something in it hard coded to reference this user account.
>> Any suggestions welcome...
>> Harrison Midkiff
>> "Peter 'Not Peter The Spate' Nolan"
>> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
message
>> news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
>> > Have a look at
>> > http://support.microsoft.com/default.aspx?scid=kb;en-us;321044
>> >
>> > Peter
>> >
>> > "Do not awake the sleeping dragon for you are crunchy and taste good
>> with
>> > ketchup".
>> > Peter The Spate
>> >
>> > "Harrison Midkiff" wrote:
>> >
>> >> Hello:
>> >>
>> >> A while back I started getting KDC errors in my System log on my
>> domain
>> >> controller. The error is:
>> >>
>> >> Event Type: Error
>> >> Event Source: KDC
>> >> Event Category: None
>> >> Event ID: 11
>> >> Date: 3/16/2005
>> >> Time: 9:34:08 AM
>> >> User: N/A
>> >> Computer: TPADC1
>> >> Description:
>> >> There are multiple accounts with name
>> MSSQLSvc/elvis.aviinc.local:1433 of
>> >> type 10.
>> >>
>> >> After researching this I did a "ldifde" dump of the active
directory
>> >> database and then searched the dump and found a double entry for
>> >> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one
of
>> the
>> >> domain admins accounts. Since this appeared to be a duplicate I
>> decided
>> >> to
>> >> delete it. Within a few minutes I had problems with connections to
>> SQL.
>> >> I
>> >> put it back right away and then everything was working fine again.
>> >> Obviously the SQL server has some kind of a link to this...
>> >>
>> >> I have done some searching but have not found anything on it. Does
>> >> anyone
>> >> have any suggestions on cleaning this up?
>> >>
>> >> Harrison Midkiff
>> >>
>> >>
>> >>
>>
>>
>
>|||Hi William,
I was reading the messages posted by Harrison, it seems tobe that he has the
same problem than me, i used ldp.exe and i could find this accounts:
ldap_search_s(ld, "dc=dinamica,dc=com,dc=co", 2,
"serviceprincipalname=MSSQLSvc/ns.dinamica.com.co:1433", attrList, 0, &msg)
Result <0>: (null)
Matched DNs:
Getting 2 entries:
>> Dn: CN=Administrator,CN=Users,DC=dinamica,DC=com,DC=co
1> canonicalName: dinamica.com.co/Users/Administrator;
1> cn: Administrator;
1> description: Built-in account for administering the computer/domain;
1> distinguishedName: CN=Administrator,CN=Users,DC=dinamica,DC=com,DC=co;
4> objectClass: top; person; organizationalPerson; user;
1> name: Administrator;
>> Dn: CN=NS,OU=Domain Controllers,DC=dinamica,DC=com,DC=co
1> canonicalName: dinamica.com.co/Domain Controllers/NS;
1> cn: NS;
1> distinguishedName: CN=NS,OU=Domain Controllers,DC=dinamica,DC=com,DC=co;
5> objectClass: top; person; organizationalPerson; user; computer;
1> name: NS;
I have found two accounts, Administrator who is an user account, and the
other account is a computer account called NS, but NS is the name of the
server where SQL Server is running.
What should i do?
I hope you can help. Thanks
Javier Espinosa
"William Wang[MSFT]" wrote:
> Hi Harrison,
> The relevent articles I could find are:
> 305971 Windows 2000 Server Prompts Domain User for Credentials
> http://support.microsoft.com/?id=305971
> 811889 HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
> http://support.microsoft.com/?id=811889
> HTH!
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> >Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
> >From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
> >References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
> <AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
> <#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
> <3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
> <O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
> <lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl>
> >Subject: Re: KDC Problem
> >Date: Wed, 23 Mar 2005 08:32:22 -0500
> >Lines: 155
> >Organization: Audio Visual Innovations, Inc.
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> >X-RFC2646: Format=Flowed; Original
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> >Message-ID: <Oi9BAz6LFHA.3328@.TK2MSFTNGP14.phx.gbl>
> >Newsgroups: microsoft.public.sqlserver.server
> >NNTP-Posting-Host: 208.5.55.190
> >Path:
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
> 4.phx.gbl
> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382949
> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >
> >William:
> >
> >Thanks for replying to my post. Do you know of any tech net articles
> which
> >may explain this behavior. The reason I ask is due to the sensitive
> nature
> >of SQL we are going to have a meeting before we attempt any changes.
> >Thanks.
> >
> >Harrison Midkiff
> >"William Wang[MSFT]" <v-rxwang@.online.microsoft.com> wrote in message
> >news:lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl...
> >> Hi Harrison,
> >>
> >> You may want to restart the SQL Server service after you have removed the
> >> duplicate SPN. If the SPN is re-added, remove the other SPN and then
> >> restart the SQL Server service.
> >>
> >> Feel free to let me know if this resolves your problem.
> >>
> >> Sincerely,
> >>
> >> William Wang
> >> Microsoft Online Partner Support
> >>
> >> When responding to posts, please "Reply to Group" via your newsreader so
> >> that others may learn and benefit from your issue.
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> --
> >>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
> >>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
> >>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
> >> <AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
> >> <#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
> >> <3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
> >>Subject: Re: KDC Problem
> >>Date: Thu, 17 Mar 2005 13:03:45 -0500
> >>Lines: 254
> >>Organization: Audio Visual Innovations, Inc.
> >>MIME-Version: 1.0
> >>Content-Type: multipart/alternative;
> >> boundary="--=_NextPart_000_012E_01C52AF1.C085DB50"
> >>X-Priority: 3
> >>X-MSMail-Priority: Normal
> >>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> >>Message-ID: <O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
> >>Newsgroups: microsoft.public.sqlserver.server
> >>NNTP-Posting-Host: 208.5.55.183
> >>Path:
> >>
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
> >> 9.phx.gbl
> >>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382241
> >>X-Tomcat-NG: microsoft.public.sqlserver.server
> >>
> >>Aleksandar:
> >>Thanks for replying to my post.
> >>The error which was appearing on the SQL Enterprise Manager was, "Unable
> >> to initialize SSPI context".
> >>Any suggestions?
> >>Harrison Midkiff
> >>"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
> >> message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...
> >> try with setspn tool
> >>
> >> or
> >>
> >> 1. use adsiedit.msc and show servicePrincipalName for your sql server
> >
> >> (computer account)
> >>
> >> 2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
> >> delete duplicated spn
> >>
> >> -- -- "Within a few minutes I had problems with connections to SQL. "
> >
> >> what? error message'
> >>
> >>
> >>
> >>
> >> "Harrison Midkiff" wrote:
> >>
> >> Peter:
> >>
> >> Thanks for replying to my post.
> >>
> >> This is the article I followed which allowed me to find the duplicate
> >> but is
> >> was on a user account not a computer account. I think perhaps SQL has
> >> something in it hard coded to reference this user account.
> >>
> >> Any suggestions welcome...
> >>
> >> Harrison Midkiff
> >> "Peter 'Not Peter The Spate' Nolan"
> >> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
> message
> >> news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
> >> > Have a look at
> >> > http://support.microsoft.com/default.aspx?scid=kb;en-us;321044
> >> >
> >> > Peter
> >> >
> >> > "Do not awake the sleeping dragon for you are crunchy and taste good
> >> with
> >> > ketchup".
> >> > Peter The Spate
> >> >
> >> > "Harrison Midkiff" wrote:
> >> >
> >> >> Hello:
> >> >>
> >> >> A while back I started getting KDC errors in my System log on my
> >> domain
> >> >> controller. The error is:
> >> >>
> >> >> Event Type: Error
> >> >> Event Source: KDC
> >> >> Event Category: None
> >> >> Event ID: 11
> >> >> Date: 3/16/2005
> >> >> Time: 9:34:08 AM
> >> >> User: N/A
> >> >> Computer: TPADC1
> >> >> Description:
> >> >> There are multiple accounts with name
> >> MSSQLSvc/elvis.aviinc.local:1433 of
> >> >> type 10.
> >> >>
> >> >> After researching this I did a "ldifde" dump of the active
> directory
> >> >> database and then searched the dump and found a double entry for
> >> >> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one
> of
> >> the
> >> >> domain admins accounts. Since this appeared to be a duplicate I
> >> decided
> >> >> to
> >> >> delete it. Within a few minutes I had problems with connections to
> >> SQL.
> >> >> I
> >> >> put it back right away and then everything was working fine again.
> >> >> Obviously the SQL server has some kind of a link to this...
> >> >>
> >> >> I have done some searching but have not found anything on it. Does
> >> >> anyone
> >> >> have any suggestions on cleaning this up?
> >> >>
> >> >> Harrison Midkiff
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
>

KDC Problem

Hello:
A while back I started getting KDC errors in my System log on my domain
controller. The error is:
Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 3/16/2005
Time: 9:34:08 AM
User: N/A
Computer: TPADC1
Description:
There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
type 10.
After researching this I did a "ldifde" dump of the active directory
database and then searched the dump and found a double entry for
"MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
domain admins accounts. Since this appeared to be a duplicate I decided to
delete it. Within a few minutes I had problems with connections to SQL. I
put it back right away and then everything was working fine again.
Obviously the SQL server has some kind of a link to this...
I have done some searching but have not found anything on it. Does anyone
have any suggestions on cleaning this up?
Harrison MidkiffHave a look at [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;321044[/url
]
Peter
"Do not awake the sleeping dragon for you are crunchy and taste good with
ketchup".
Peter The Spate
"Harrison Midkiff" wrote:

> Hello:
> A while back I started getting KDC errors in my System log on my domain
> controller. The error is:
> Event Type: Error
> Event Source: KDC
> Event Category: None
> Event ID: 11
> Date: 3/16/2005
> Time: 9:34:08 AM
> User: N/A
> Computer: TPADC1
> Description:
> There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
> type 10.
> After researching this I did a "ldifde" dump of the active directory
> database and then searched the dump and found a double entry for
> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
> domain admins accounts. Since this appeared to be a duplicate I decided t
o
> delete it. Within a few minutes I had problems with connections to SQL.
I
> put it back right away and then everything was working fine again.
> Obviously the SQL server has some kind of a link to this...
> I have done some searching but have not found anything on it. Does anyone
> have any suggestions on cleaning this up?
> Harrison Midkiff
>
>|||Peter:
Thanks for replying to my post.
This is the article I followed which allowed me to find the duplicate but is
was on a user account not a computer account. I think perhaps SQL has
something in it hard coded to reference this user account.
Any suggestions welcome...
Harrison Midkiff
"Peter 'Not Peter The Spate' Nolan"
<PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in message
news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...[vbcol=seagreen]
> Have a look at
> http://support.microsoft.com/defaul...kb;en-us;321044
> Peter
> "Do not awake the sleeping dragon for you are crunchy and taste good with
> ketchup".
> Peter The Spate
> "Harrison Midkiff" wrote:
>|||try with setspn tool
or
1. use adsiedit.msc and show servicePrincipalName for your sql server
(computer account)
2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
delete duplicated spn
-- -- "Within a few minutes I had problems with connections to SQL. "
what? error message'
"Harrison Midkiff" wrote:

> Peter:
> Thanks for replying to my post.
> This is the article I followed which allowed me to find the duplicate but
is
> was on a user account not a computer account. I think perhaps SQL has
> something in it hard coded to reference this user account.
> Any suggestions welcome...
> Harrison Midkiff
> "Peter 'Not Peter The Spate' Nolan"
> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in message
> news:AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com...
>
>|||Yes. To determine which domain account is the one that is currently being
used, we can use Adsiedit.msc to delete one of the
MSSQLSvc/elvis.aviinc.local:1433 SPNs, then *restart* the SQL service(s).
The SQL service will re-add the SPN on the currently used service account.
If it was not readded, then the duplicate has been removed.
Adsiedit.msc and Ldp.exe are included on the Windows 2000 installation CD.
You can install these tools from the CD in Support\Tools\Setup.exe
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: KDC Problem
>thread-index: AcUqezBszBBVWy/FSSSK8UVZqmT1Hg==
>X-WBNR-Posting-Host: 212.200.135.192
>From: "examnotes"
<AleksandarGrbic@.discussions.microsoft.com>
>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
<AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
<#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
>Subject: Re: KDC Problem
>Date: Wed, 16 Mar 2005 14:55:03 -0800
>Lines: 81
>Message-ID: <3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382093
>X-Tomcat-NG: microsoft.public.sqlserver.server
>try with setspn tool
>or
>1. use adsiedit.msc and show servicePrincipalName for your sql server
>(computer account)
>2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
>delete duplicated spn
>-- -- "Within a few minutes I had problems with connections to SQL. "
>what? error message'
>
>
>"Harrison Midkiff" wrote:
>
but is[vbcol=seagreen]
with[vbcol=seagreen]
domain[vbcol=seagreen]
MSSQLSvc/elvis.aviinc.local:1433 of[vbcol=seagreen]
the[vbcol=seagreen]
decided[vbcol=seagreen]
SQL.[vbcol=seagreen]
>|||Aleksandar:
Thanks for replying to my post.
The error which was appearing on the SQL Enterprise Manager was, "Unable to
initialize SSPI context".
Any suggestions?
Harrison Midkiff
"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in message news:3DA4EE9
0-C742-482D-B063-C81B448C47E1@.microsoft.com...[vbcol=seagreen]
> try with setspn tool
>
> or
>
> 1. use adsiedit.msc and show servicePrincipalName for your sql server
> (computer account)
>
> 2. use ldp.exe and search for "servicePrincipalName=MSSQLSvc/elvis*"
> delete duplicated spn
>
> -- -- "Within a few minutes I had problems with connections to SQL. "
> what? error message'
>
>
>
>
> "Harrison Midkiff" wrote:
>|||Hi Harrison,
You may want to restart the SQL Server service after you have removed the
duplicate SPN. If the SPN is re-added, remove the other SPN and then
restart the SQL Server service.
Feel free to let me know if this resolves your problem.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
<AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
<#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
<3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
>Subject: Re: KDC Problem
>Date: Thu, 17 Mar 2005 13:03:45 -0500
>Lines: 254
>Organization: Audio Visual Innovations, Inc.
>MIME-Version: 1.0
>Content-Type: multipart/alternative;
> boundary="--=_NextPart_000_012E_01C52AF1.C085DB50"
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 208.5.55.183
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
9.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382241
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Aleksandar:
>Thanks for replying to my post.
>The error which was appearing on the SQL Enterprise Manager was, "Unable
to initialize SSPI context".
>Any suggestions?
>Harrison Midkiff
>"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...
(computer account)[vbcol=seagreen]
what? error message'[vbcol=seagreen]
but is[vbcol=seagreen]
with[vbcol=seagreen]
domain[vbcol=seagreen]
MSSQLSvc/elvis.aviinc.local:1433 of[vbcol=seagreen]
the[vbcol=seagreen]
decided[vbcol=seagreen]
SQL.[vbcol=seagreen]
>|||In almost every case I remember SSPI errors was related with wrong DNS
records, so check the DNS.
(ex computer name is London instead of London.nwtraders.msft ) SETSPN works
with FQDN only.
Regards,
Daniel
"Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
news:uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl...
> Hello:
> A while back I started getting KDC errors in my System log on my domain
> controller. The error is:
> Event Type: Error
> Event Source: KDC
> Event Category: None
> Event ID: 11
> Date: 3/16/2005
> Time: 9:34:08 AM
> User: N/A
> Computer: TPADC1
> Description:
> There are multiple accounts with name MSSQLSvc/elvis.aviinc.local:1433 of
> type 10.
> After researching this I did a "ldifde" dump of the active directory
> database and then searched the dump and found a double entry for
> "MSSQLSvc/elvis.aviinc.local:1433". I found it duplicated on one of the
> domain admins accounts. Since this appeared to be a duplicate I decided
to
> delete it. Within a few minutes I had problems with connections to SQL.
I
> put it back right away and then everything was working fine again.
> Obviously the SQL server has some kind of a link to this...
> I have done some searching but have not found anything on it. Does anyone
> have any suggestions on cleaning this up?
> Harrison Midkiff
>|||William:
Thanks for replying to my post. Do you know of any tech net articles which
may explain this behavior. The reason I ask is due to the sensitive nature
of SQL we are going to have a meeting before we attempt any changes.
Thanks.
Harrison Midkiff
"William Wang[MSFT]" <v-rxwang@.online.microsoft.com> wrote in message
news:lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl...
> Hi Harrison,
> You may want to restart the SQL Server service after you have removed the
> duplicate SPN. If the SPN is re-added, remove the other SPN and then
> restart the SQL Server service.
> Feel free to let me know if this resolves your problem.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
> <AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
> <#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
> <3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNG
P0
> 9.phx.gbl
> to initialize SSPI context".
> message news:3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com...
> (computer account)
> what? error message'
> but is
> with
> domain
> MSSQLSvc/elvis.aviinc.local:1433 of
> the
> decided
> SQL.
>|||Hi Harrison,
The relevent articles I could find are:
305971 Windows 2000 Server Prompts Domain User for Credentials
http://support.microsoft.com/?id=305971
811889 HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/?id=811889
HTH!
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Reply-To: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>From: "Harrison Midkiff" <HMidkiff@.aviinc.com>
>References: <uHsGc7jKFHA.2764@.tk2msftngp13.phx.gbl>
<AEC55981-252F-4AF5-B46A-BCC8C71F330E@.microsoft.com>
<#mEsdElKFHA.604@.TK2MSFTNGP10.phx.gbl>
<3DA4EE90-C742-482D-B063-C81B448C47E1@.microsoft.com>
<O3FTruxKFHA.1156@.TK2MSFTNGP09.phx.gbl>
<lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl>
>Subject: Re: KDC Problem
>Date: Wed, 23 Mar 2005 08:32:22 -0500
>Lines: 155
>Organization: Audio Visual Innovations, Inc.
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <Oi9BAz6LFHA.3328@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 208.5.55.190
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
4.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:382949
>X-Tomcat-NG: microsoft.public.sqlserver.server
>William:
>Thanks for replying to my post. Do you know of any tech net articles
which
>may explain this behavior. The reason I ask is due to the sensitive
nature
>of SQL we are going to have a meeting before we attempt any changes.
>Thanks.
>Harrison Midkiff
>"William Wang[MSFT]" <v-rxwang@.online.microsoft.com> wrote in message
>news:lcT4rWsLFHA.1376@.TK2MSFTNGXA02.phx.gbl...
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0[vbcol=seagreen]
>
>
message[vbcol=seagreen]
directory[vbcol=seagreen]
of[vbcol=seagreen]
>
>