Hi,

I have a VB.NET application that call a SQL 2000 DTS package. This worked
fine when running the client application from my machine but as soon as the
client application was moved to a production machine I get the following
error when trying to run the DTS package.

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

I had this error the very first time I tried to call the package when in a
test env. and I discovered a connection in the package that was using Windows
auth which, I changed to SQL auth. and it ran fine untill now.
I am at loss and have to idea what could be causing the problem.
I am in desparate need if any suggestions.

Thank You!

More information:

I can run the DTS package from Enterprise Manager by registering a new sql
server with SQL auth. and using the applications login and password.

I can also run the dts package if I run the client application from my pc.

The DBA's where I am at for some reason can not run the DTS Package from SQL
Enterprise Manager. We have compared Network Protocols installed and the
order of precendence and the default ports are the same on my machine as
thiers.

All machines are WINXP Pro except for the database server which is WIN2K.

I am at a loss and can not determine the cause of this problem.

Any suggestions on what to check or what might be the cause is greatly
appreciated.