Hi folks,

I created a DTS package on a SQL Server and Scheduled it by right
clicking on that package. After that I have changed the owner of the job
to 'sa'.
The job fails with error: DTSRun: Loading... Error: -2147467259
(80004005); Provider Error: 14(E) Error string:
[DBNETLIB][ConnectionOpen (Invalid Instance()].]Invalid connection.
Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help Context: 0. Process Exit Code 1. The step failed.

Here is the additional info:
1. I have logged into the SQL Server from another machine thru EM using
a SQL Server login which has sa access.
2. When I saved the package, EM shows my windows login as Owner of the
package (but i connected to SQL Server using my SQL Server login that
has sa access).
3. When a user (who has local admin access to the SQL Server box)
schedules the job, it works well.

Is it a must to have Local Admin rights to schedule a DTS package.

Any ideas...

Thanks in advance.
-----

*** Sent via Developersdex http://www.developersdex.com ***

Looks like the DTSRUN command created in the job step has some bad
connection information.

When using the schedule package function it generates the command line using
the security info held in your local Enterprise Manager registration. This
may not be valid on the server itself, for example a server name may not
reolve correctly if there are aliases used or different name resolution
servers between teh EM client and the server itself.

Manually create the command line (DTSRUNUI), to be sure of what is used.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Venkat" <nospam_venkat_asp (AT) yahoo (DOT) co.uk> wrote

Thanks Darren,

I manually created the DTSRun string and compared with the one which is
created by EM. Both are identical.

If I schedule it by logging into the box as local admin (but same SQL
Server login which I used to in EM), it executes. Is it a must to have
Local Admin of the box to schedule a DTS package?

Thanks!!!
-----

*** Sent via Developersdex http://www.developersdex.com ***