Try these
http://support.microsoft.com/default.aspx?scid=kb;en-
us;814401
http://support.microsoft.com/default.aspx?scid=kb;en-
us;811889
HTH
>--Original Message--
>We have had two instances of installing Windows 2000
Service Pack 4 [*] on machines running SQL Server 2000
SP3a+HF and subsequently seeing errors from SQL Server
client tools (QA and Enterprise Manager):
> Cannot generate SSPI context
>SETSPN -L shows a valid service principle name, and the
other options in KB 811889 have been tried. We are using a
domain user account as the service account for SQL Server.
>What else can we look for to resolve this problem please?
>
>[*] re-building the machine with SP3 and the problem does
not appear. We need W2K SP4 for SQL Server Reporting
Services.
>
>.
>Thanks Ray, but you might have missed the reference in my original email to
KB 811889, we have tried all the suggested resolutions in this KB article, e
xcept contacting PSS to open a case, we're trying this avenue first :-)
The machine in question is a member of the domain and is able to connect to
other domain members and accepts Terminal Services connections (and NTLM aut
henticated HTTP and telnet) without problem, the problem seems to occur spec
ifically with authenticatin
g SQL Server tools and only happens after W2K SP4 is installed.
-- Ray Higdon wrote: --
Try these
http://support.microsoft.com/defaul...kb;en-us;814401
http://support.microsoft.com/defaul...kb;en-us;811889
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment