Cannot generate SPPI Context

From: Sven Peeters (sven.peeters_at_systemat.com)
Date: 06/03/04 

Date: Thu, 3 Jun 2004 08:26:06 -0700

Hi,

We recently replaced one of our SQL 2000 machines in our 2-server cluster ( both Win2K SP4 ).
Since the replacement we can no longer access the SQL-server via Windows Authentication ( SQL turns mainly on this new server ).
This happens on ALL machines including the server ( We use Win Auth for the Query Analyzer ).
The server only listens on TCP/IP, i would like to avoid using named pipes.

Does anybody have any idea how to troubleshoot this?
What protocol is used NTML or Kerberos and what do you recommend to use.

Already big thnx for the answers ...

Sven Peeters
Belgium

Relevant Pages

  • Re: Problems connecting to SQL server on W2K3 from Win 2000 workst
    ... Can you connect to a network share on the SQL server? ... Also I know this isn't as important on 2k machines but is the primary DNS ... >> This is because you are using Windows authentication without a domain ... >> because it tends not to work, use SQL Authentication and you'll always ...
    (microsoft.public.sqlserver.connect)
  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)
  • Re: Should I install Certificate Authority to solve these problems ?
    ... You can use IPsec with or without certs from your PKI. ... negotiations to your AD machines or those trusting the ... > In the item 1 below, the tool in use is a HP server management tool (type ... >>> Management is pushing to get Certificate Authority ...
    (microsoft.public.win2000.security)
  • Re: network slows down after SP2 install
    ... the machines updated from W2K still open and read the ... Locate the "Microsoft network server: ... Install SP2 for WIN XP and latest service pack for Office 2003 on ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: network slows down after SP2 install
    ... These machines cannot even run the program locally being disconnected from the server with a local copy of the database. ... Install SP2 for WIN XP and latest service pack for Office 2003 on ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)