Re: Schedule a DTS package

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: 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: The Microsoft Search service cannot be administered under the pres
    ... the BUILTIN\Administrator account as well as a member of the Sysadmin role? ... SQL Server Full-Text Search Does Not Populate Catalogs ... you or your server's sysadmin have removed the ... exec sp_defaultdb N'NT Authority\System', N'master' ...
    (microsoft.public.sqlserver.fulltext)
  • 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)
  • Re: Schedule a DTS package
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >> owned by a sysadmin then the job will fire as the Service account. ...
    (microsoft.public.sqlserver.dts)
  • Re: Security issue when running packages from SQL Agent.
    ... only sysadmin role members can execute CmdExec steps by ... You will then be prompted to specify a valid Windows account ... for the SQL Server Agent proxy. ...
    (microsoft.public.sqlserver.security)
Loading