"moongirl" wrote:

> I have been searching for the solution to this all day and have found
> many people who have had the same problem but I still can't get this
> resolved on my system, so I am really hoping someone can help! I
> created a DTS package that is very simple. It connects to the database
> using sql log in details using the sa username and password, and it
> then executes a stored procedure.
>
> The stored procedure executes fine, and so does the package. So far, so
> good......
>
> BUT.... I then right click on the DTS package and schedule it to run
> once per day but it has failed every day this week. The error message
> is:
>
> The job failed.  The Job was invoked by User sa.  The last step to run
> was step 1 (UHD).
>
> .....and the detailed error msg says:
>
> Executed as user: 9-FRONTEND\SYSTEM. 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.
>
> I set the package and the job up through Enterprise Manager on my
> machine (login MYDOMAIN/myname) and the owner of the package is
> MYDOMAIN/myname. When I log on to the server where the database is I
> log on as Administrator/adminpassword.
>
> I understand that this is some kind of permissions issue but I just
> can't seem to figure it out. Incidentally both SQL SERVER and SQL
> SERVER AGENT services log on with the 'Local System Account'. If I
> right click on the SQL Server Agent item in Enterprise Manager and look
> at the Job System details the "Only users with SysAdmin privileges can
> execute CmdExec and ActiveScripting...." checkbox is checked.
>
> What do I need to do in order to get this to work?????! Any help very
> very much appreciated!
>
>