Re: Schedule a DTS package

Any job owned by any user can run every day.

Have a read of this

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

--



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:%23eyRtdYiFHA.1412@xxxxxxxxxxxxxxxxxxxxxxx
>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

  • Re: Execute Persmission denied on object sp_OACreate
    ... > I logged in as that user, tried to execute the DTS ... which then launches the DTS package using the sp_OA* procs? ... account is used during proc execution. ... > proxy account to use in the Job Systems tab of SQL Server Agent ...
    (microsoft.public.sqlserver.security)
  • Re: modify user account for dts connections
    ... www.SQLDTS.com - The site for all your DTS needs. ... > employee's account into another account for all ... >>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Move or Setup of SQL Database toa Remote Server Fails
    ... as well as have SysAdmin privileges on the DB. ... Registered type 501ST MASTER for 501ST SCCM1DB\master ... Could not connect SQL Server 'master' db. ... The SCCM Primary Site Computer Account and the User account I am using ...
    (microsoft.public.sms.setup)
  • Re: Scheduled DTS package wont execute all steps
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >I have several DTS packages scheduled as jobs in SQL Server Agent. ... > I have configured SQLServerAgent to use a domain account (the same account ...
    (microsoft.public.sqlserver.dts)
  • RE: Problem with DTS
    ... Next, if you use a Domain Account for the services, you can grant explicit ... defined account to run the SQL Server services under: you can log in to the ... > There are some DTS which have been creating some time ago. ... But when login as local Admin directly on the server and open ...
    (microsoft.public.sqlserver.server)
Quantcast