"J-T" <JT@nospam.com> wrote in message
news:e0k1EgMiFHA.328@tk2msftngp13.phx.gbl...
>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
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23SB$SyPiFHA.1252@TK2MSFTNGP09.phx.gbl...
> 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@nospam.com> wrote in message
> news:e0k1EgMiFHA.328@tk2msftngp13.phx.gbl...
>>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
>>
>
>

"J-T" <JT@nospam.com> wrote in message
news:%23eyRtdYiFHA.1412@TK2MSFTNGP10.phx.gbl...
>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@no-spam.sqldts.com> wrote in message
> news:%23SB$SyPiFHA.1252@TK2MSFTNGP09.phx.gbl...
>> 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@nospam.com> wrote in message
>> news:e0k1EgMiFHA.328@tk2msftngp13.phx.gbl...
>>>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
>>>
>>
>>
>
>