Re: Very Very Urgent, Please Help

No, production servers services will always run under domian admin account.
This is not the issue.


"Darren Gosbell" <dgosbell_at_yahoo_dot_com> wrote in message
news:MPG.1d8b89989fc5c0c7989688@xxxxxxxxxxxxxxxxxxxxx
It sounds like you are running the SQL Agent service under the local
system account which does not have access to the DTS packages.

The way I normally set up SQL Agent is to run it under a domain user
account. This has 2 advantages.

1) It can then access network resources such as file shares (Local
System can only access resources on the SQL Server itself)

2) You can also "debug" security issues such as the one you are now
having because you can log in under the same account as the SQL Agent
and run the packages from Enterprise manager it is often easier to see
exactly where your problems are occurring.

I would recommend setting up this user with the minimum require security
privileges. RESIST the temptation to set this user up as an
administrator as it could mean that any user that can schedule a job can
run a process under this account. If someone cracks an SA password, they
can schedule a job to give them full access to your machine at the OS
level and from there possibly out into your network.

--
Regards
Darren Gosbell
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#bi0pnMtFHA.596@xxxxxxxxxxxxxxxxxxxx>,
willgart@xxxxxxxxxxxxxxxxx says...
> does the SQL Agent service run under a known account?
>
> "DKRReddy" <dkrreddy@xxxxxxxxxxx> wrote in message
> news:%23SWDRmJtFHA.664@xxxxxxxxxxxxxxxxxxxxxxx
> > When running the dts package as a job , it's failing while opening the
> > package itself.
> > Security log in keep filling, is this the cause?
> >
> >
> >
> > "Darren Gosbell" <dgosbell_at_yahoo_dot_com> wrote in message
> > news:MPG.1d88f7c738031b6f989685@xxxxxxxxxxxxxxxxxxxxx
> > This sounds like a permissions issue. If you can run the packages from
> > Enterprise manager then the issue is not necessarily with the packages
> > themselves.
> >
> > If the packages are executed via a SQL agent job that launches them
> > using dtsrun, then I suggest you check which account the SQL Agent
> > service is running under. It might also have something to do with the
> > owner of the Agent jobs.
> >
> > Packages run via Enterprise Manager run in the security context of the
> > currently logged on user. Packages launched via SQL Agent run in the
> > context of the account that the SQL Agent Service logs in under.
> >
> > --
> > Regards
> > Darren Gosbell
> > <dgosbell_at_yahoo_dot_com>
> > Blog: http://www.geekswithblogs.net/darrengosbell
> >
> > In article <eP$UU6osFHA.3164@xxxxxxxxxxxxxxxxxxxx>, dkrreddy@xxxxxxxxxxx
> > says...
> >> All packages are refering to the new server only.If I run the package
> >> from
> >> enterprise manager runs fine no timeout errors.
> >>
> >>
> >>
> >> "Jéjé" <willgart@xxxxxxxxxxxxxxxxx> wrote in message
> >> news:OHhuUhnsFHA.3404@xxxxxxxxxxxxxxxxxxxxxxx
> >> > does your packages are stored in the MSDB database?
> >> > Have you changed your main package to use the right SQL Server
> >> > instance?
> >> >
> >> > if your main dts package try to open a package on the <old server>
and
> > if
> >> > this server is down, then you'll receive a timeout error.
> >> >
> >> >


.

Relevant Pages

  • Re: Very Very Urgent, Please Help
    ... Try logging onto the server under the domain account that the SQL Agent ... >> system account which does not have access to the DTS packages. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Very Very Urgent, Please Help
    ... It sounds like you are running the SQL Agent service under the local ... system account which does not have access to the DTS packages. ... System can only access resources on the SQL Server itself) ... having because you can log in under the same account as the SQL Agent and run the packages from Enterprise manager it is often easier to see exactly where your problems are occurring. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Very Very Urgent, Please Help
    ... It sounds like you are running the SQL Agent service under the local ... system account which does not have access to the DTS packages. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Saving a file on remote server
    ... As a Windows scheduled task using DTSRUN in a batch or command-line, ... I'd really consider setting up the SQL Agent service ... to run under some account with limited network access for items such as this. ...
    (microsoft.public.sqlserver.dts)
  • RE: dts package error
    ... "Donna Lambert" wrote: ... > under the context of the SQL Agent account. ... > account and try to manually kick off the package. ...
    (microsoft.public.sqlserver.dts)