Re: SSPI Contexts
- From: dogirard@xxxxxxxxxxxxxxxxxxxx (Doug Girard [MSFT])
- Date: Fri, 03 Mar 2006 22:52:51 GMT
Chris,
A very good source for troubleshooting the error is
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889. You might
also want to have a look at
http://blogs.msdn.com/sql_protocols/archive/2005/10/15/481297.aspx for more
information.
Sometimes these errors have to do with SQL Server registering the Service
Principle Name (SPN) for the service in Active Directory, but later having
a problem like an incorrect shutdown of the SQL service (and/or a change in
the service account that runs SQL) which does not remove this entry from
AD, which later results in Kerberos errors. Forcibly removing machine
entries from the AD may help in certain cases. These two links should
provide more than enough background and guidance.
HTH,
Doug Girard [MSFT]
Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
From: "Tomas Restrepo \(MVP\)" <tomasr@xxxxxxxx>TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
References: <1126160472.535055.122950@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: SSPI Contexts
Date: Thu, 8 Sep 2005 06:15:17 -0500
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
X-RFC2646: Format=Flowed; Original
Message-ID: <uGTHdaGtFHA.2008@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.biztalk.general
NNTP-Posting-Host: cable200-116-204-143.epm.net.co 200.116.204.143
Path:
0.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.biztalk.general:30740might
X-Tomcat-NG: microsoft.public.biztalk.general
Chris,
We have our BizTalk server setup in a DMZ and the SQL Server database
is housed internally on another server. Recently we noticed in the
event logs the following errors:
An attempt to connect to "BizTalkMgmtDb" SQL Server database on server
"sqlsvr" failed with error: "Cannot generate SSPI context".
Immediately following this error, the BizTalkServerApplication host
recycles itself. Once it has done this it works okay for approximately
another 30 minutes where this same process repeats itself.
Has anyone ever seen this occur and if so, what troubleshooting or
resolution did you conclude? I'm just not sure what could cause this
"SSPI context" generation process to fail. My IT group and I have read
a number of Microsoft articles but nothing stands out at us that leads
us to finding anything incorrect.
Usually, an SSPI Context problem means that you have connectivity problems
to your domain controller. One thing I've seen that can cause a lot of
trouble is the machine's clock getting out of sync with the domain
controller's one (you might want to check that the server in the DMZ can
synchronize its clock with the domain controller correctly, for example).
Also, start looking for netlogon errors in the server's eventlog, you
find something there that can pinpoint the cause.
--
Tomas Restrepo
tomasr@xxxxxxxx
http://www.winterdom.com/
.
- Prev by Date: Re: Newbie To BizTalk
- Next by Date: Re: first project in BT2006
- Previous by thread: Newbie To BizTalk
- Next by thread: Newbie Question: How to redeploy a project
- Index(es):
Relevant Pages
|
