error when running the DTSRUN command

Hi
We're using SqlServer 2000.

I want to run a DTS using the DTSRUN command.
The commmand is inside a ".bat" file which my application is running
from an SQL client.
No matter how I run it from the client it fails giving me the message:

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

I've tried to run it from the client from the application, from the
command prompt and it fails.
I went into enterprise on the client and tried to run the DTS from
there. The run failed already on the 1st step which is a call to a
stored procedure, also giving me the same message. This really stuck me
as wierd because in enterprise I'm accessing the server successfully so
why the above messgae. It identifies the server and I am accessing it.

Because it failed on the 1st step which is a call to a stored procedure
I tried running the sp from within query analyzer and it succeeded.

Has anyone got any idea what the problem is and ghow to solve it.

Thanks !

David Greenberg

Re: error when running the DTSRUN command

David Greenberg (davidgr@iba.org.il) writes:
> I want to run a DTS using the DTSRUN command.
> The commmand is inside a ".bat" file which my application is running
> from an SQL client.
> No matter how I run it from the client it fails giving me the message:
>
> [ConnectionOpen (Connect()).]SQL Server does not exist or access denied
>
> I've tried to run it from the client from the application, from the
> command prompt and it fails.
> I went into enterprise on the client and tried to run the DTS from
> there. The run failed already on the 1st step which is a call to a
> stored procedure, also giving me the same message. This really stuck me
> as wierd because in enterprise I'm accessing the server successfully so
> why the above messgae. It identifies the server and I am accessing it.
>
> Because it failed on the 1st step which is a call to a stored procedure
> I tried running the sp from within query analyzer and it succeeded.
>
> Has anyone got any idea what the problem is and ghow to solve it.

You can't accuse me to know too much about DTS, but I see that a
DTS package has connection properties. I would assume that you can
have a package on server A, and run it against server B.

So I would check the connection properties of the package (or the step,
as different task surely must be able to connect to different servers).

The error message simply means that you are trying to connect to a
server that is not available. (Not running, misspelled, a firewall
in the way etc.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx