XP Access problems

From: David O'Brien (dobber_at_fulfill.it)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 11:46:20 +0100

Hi, I've just recently started to evaluate SQL Server2000. I've created a
couple of DTS packages which I would like users to try. Having loaded the
client software on Win2000 PC's everything works fine. However trying to use
XP(SP1) is a different matter. The XP PC continually fails to connect with a
'Cannot generate SSPI context' error. I am running the SQL Server on my
Win2000 PC SP4. I've loaded the SQL2000 SP's. If I try to access my PC
through Network places using the XP PC I get a sign on screen whereas with
Win2000 Pc's I get straight onto my PC. I've looked at 811889. I can ping my
PC from XP and it resolves the name when using the -a. I'm using windows
authentication as the security system. Any suggestions?

Relevant Pages

  • Problems connecting to SQL Server
    ... I am a complete newbie when it comes to SQL, ... I have seen in the documentation for Maximo that I need to install the SQL ... Client software was installed on the other two stations (one WIN2000 and one ...
    (microsoft.public.sqlserver.clients)
  • Cant connect to databases through Enterprise Manager
    ... We have client software that uses SQL 7 as a database. ... registration properties (by right-clicking on the COMPUTER ...
    (microsoft.public.sqlserver.connect)
  • Re: ActiveX script works in DTS but not in job, why?
    ... Account that SQL Agent runs under and it is a Local Admin on the box. ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... that would be since I need to be able to load DTS packages from either a SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: ActiveX script works in DTS but not in job, why?
    ... Peter DeBetta, MVP - SQL Server ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... 2000 databases including DTS packages. ...
    (microsoft.public.sqlserver.dts)
  • Re: several steps in a dts package
    ... Depends on what you mean by "inline SQL". ... Columnist, SQL Server Professional ... DTS packages can run ActiveX VBScript tasks. ...
    (microsoft.public.sqlserver.dts)