Re: Schedule a DTS package

I didn't get it.Sorry:)
If you want to schadule a DTS package to run everyday ,which account do you
use for that?

Thanks
"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23SB$SyPiFHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
> sysadmin means God in SQL Server
>
> It does not mean you will avoid all the security problems. If the job is
> owned by a sysadmin then the job will fire as the Service account. What
> if the service account is a Local System account? It cannot see off its
> own HDD so will not be able to get resources from the network etc.
>
>
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "J-T" <JT@xxxxxxxxxx> wrote in message
> news:e0k1EgMiFHA.328@xxxxxxxxxxxxxxxxxxxxxxx
>>I know that I have to schedule a DTS package under an account which is in
>>sysadmin role in order not to face security problems.Dose sysadmin role
>>mean System administator?
>>
>> What type of account you guys use for you oleDBConnections insode the
>> packages Sqlserver accoun or domain account? if sql server what kind of
>> role that account belongs to>?
>>
>> Thanks a lot
>>
>
>


.

Relevant Pages

  • Jobs, owners, and permissions
    ... When the owner of a job is not member of sysadmin, ... must configure a proxy account in order to execute ActiveX ...
    (microsoft.public.sqlserver.security)
  • Re: problem with Execute SQL Task
    ... thanks Allan ... > If the owner of the job is a sysadmin then the guy executing the package ... > sysadmin then the package runner is the proxy account. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server and Agent Accounts
    ... I log in to the server as a sysadmin. ... Here is a scenario that I tested: I created a Windows account called ... Apparently when SQL Agent logs in to the publisher it uses Domain\Maer. ...
    (microsoft.public.sqlserver.replication)
  • Re: Schedule a DTS package
    ... It does not mean you will avoid all the security problems. ... owned by a sysadmin then the job will fire as the Service account. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: remove guest user in msdb
    ... in your your opinion while is the best security choice? ... Assing the sysadmin role to an NT normal user account and use this to start the SQL_SERVER_AGENT. ... > Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.server)