Re: Security

From: jrpm (jrpm_at_discussions.microsoft.com)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 07:55:05 -0800

What account is executing DTSRUN, ie, the batch component.

If you are running outside of SS, then you need to check that account in
Scheduled Tasks. There is an option to specify who runs the job.

"mat" wrote:

> I am, the agents login is and i have changed the SQL login that the
> connection to the other server uses to sysadmin.
>
> So basicly, all logins used are sysadmin
>
> i have even tried to get it to work by giving the SQL Agents login sysadmin
> rights on the other server and not even this works
>
> i am completly stuck.....
>
> "Uri Dimant" wrote:
>
> > mat
> > Are you member of SysAdmin Server Role?
> >
> >
> > "mat" <mat@discussions.microsoft.com> wrote in message
> > news:D93B7A67-FDE5-49CC-919E-33BEE08A3ECD@microsoft.com...
> > > Thanks
> > > The connection within the package uses a SQL login for the SQL server it
> > > connects to, so even though it is executing using the agent, so using the
> > > agents permissions, i presumed that the actual connection will be made
> > using
> > > the defined login.
> > >
> > > is this true?
> > >
> > > "Uri Dimant" wrote:
> > >
> > > > mat
> > > > When you execute the DTS by clicking on the package it is running
> > under
> > > > permissions that defined on your workstation (local account probably) ,
> > as
> > > > opposite when it runs with a job ,it should be run under SQL Server
> > Agent
> > > > account (It should be most likely a domain account)
> > > >
> > > >
> > > >
> > > > "mat" <mat@discussions.microsoft.com> wrote in message
> > > > news:5520F76E-AE6E-4B14-AE67-2CCBBC4179DC@microsoft.com...
> > > > > I have a dts package that transfers data from one sql server to
> > another.
> > > > it
> > > > > uses a SQL login to connect to the second server. When the DTS package
> > is
> > > > > executed it runs fine but if it is executed from a job or using the
> > dtsrun
> > > > > utility it always fails
> > > > >
> > > > > Can anyone help?
> > > >
> > > >
> > > >
> >
> >
> >

Relevant Pages

  • 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: SA PW
    ... with an account that has sysadmin role on the server (as she said, ... Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • RE: using SSH to execute commands on remote servers as different user
    ... >User sysadmin on server A now has access to B,C,D,E,F without the password. ... This is what we currently do for the sysadmin account. ... need to connect to serverB or serverC as userA or userB account. ...
    (freebsd-isp)
  • Re: SA can not create users
    ... i try to reregiter server using local admin and Sa account ... and i have sql 7 with sp4 on server and i am trying this directly on server ... Simon Hayes wrote: ... >removing the registration and re-creating it with a sysadmin account, ...
    (comp.databases.ms-sqlserver)
  • Re: Web server in CE 5.0 using ISAPI extensions
    ... SysAdmin is actually implemented as an ISAPI extension. ... resolve the problem of the file download (show the file name ... efficent way to realize a web server on CE. ...
    (microsoft.public.windowsce.app.development)