Hi all,

Recently, I added new DTS in SQL Server. The DTS owner is admin1(this SQL
user is SQL System Administrators and has right to access related database as
"public"). This DTS works perfectly fine when manual run in server. However,
schedule job always failed. The job owner is admin2. This user also has
access right to same database. We are using "domain1\backoper" to run SQL
services and SQL Agent services. Other existing jobs with similar owners
settings do not have this problem. Anything wrong with admin1? Please advise.
Below is the error details.

Executed as user: domain1\backoper. DTSRun: Loading... Error:
-2147467259 (80004005); Provider Error: 17 (11) Error string:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0. Process Exit Code 1. The step failed.

Hello JamesY,

The owner of the package has very very little to do with anything where executing
a package is concerned. it is all about who is doing the executing and doing
things interactively and as a job are not the same thing

http://support.microsoft.com/?kbid=269074


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com