Issues with XP SP2

[Bobba Buoy]

I installed XP SP2 on my machine (which also hosts sql server 2000 db) and now I can not access the sql server to use DTS to export data, although I can do anything else I want with it. The error I get is this:

Error Source: Microsoft OLE DB Provider for SQL Server. Error Description: [DBNETLIB][Connection Open (Connect())]. SQL Server does not exist or access denied. Context: Error during initialization of the provider.

The thing is, I can log in to another machine on my network using remote desktop and then log in to s ql server on that machine and perform the export from there.

Any ideas?

Thanks~

[putts]

Have you tried going into the DTS package since the update and removing the step and re-adding it?

Maybe it's having a hard time establishing your credentials?