Re: XP Access problems

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 14:50:01 -0400

"David O'Brien" <dobber@fulfill.it> wrote in message
news:upedK$IdEHA.592@TK2MSFTNGP11.phx.gbl...
> 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?
>
This sounds like a security related (or personal firewall?) issue. Check the
following troubleshooting guide:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889&Product=sql2k

Steve

Relevant Pages

  • 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: SQLVDI and Report Server Windows Service
    ... This error is starting to appear on another server now but coinciding only with the backup. ... There's more to the hotfixes than just sqlvdi.dll, but I notice that the version of that file on my SQL install is the same as the one in the KB you've already tried. ... "David @ Solsletta" wrote in message ... Unfortunately, that's all the information I've got, but if you can get that hotfix it should solve the problem. ...
    (microsoft.public.windows.server.sbs)
  • Re: how to use datetime range in prepare statement
    ... Hi David, ... coming from SQL Server and is complaining aboutPerhaps you could use SQL ... declare @P1 int ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Accidently removed monitoring tool and cannot reinstall
    ... David, I checked and could not find a mssql$sbsmonitoring ... I have under Program Files SQL Directories ... Any idea how to reinstall the missing directory ... If this error persists, run the Monitoring ...
    (microsoft.public.windows.server.sbs)
  • 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)