Re: Security
From: mat (mat_at_discussions.microsoft.com)
Date: 12/13/04
- Next message: Henri: "Re: bug with TABLE variable???"
- Previous message: Uri Dimant: "Re: DTS TRansform Task giving inconsistent results."
- In reply to: jrpm: "Re: Security"
- Next in thread: mat: "Re: Security"
- Reply: mat: "Re: Security"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 13 Dec 2004 08:23:05 -0800
i have tried it using both the account of the agent, a domain account that is
SA on both SQl servers, by running a job and my domain account which is also
SA on both SQL servers by using exec xp_cmdshell 'dtsrun'. The account used
in the dts package connection is a SQL Login that is SA on the server it is
connecting to ( i have also tried it using a domain account with SA access).
"jrpm" wrote:
> 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?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
- Next message: Henri: "Re: bug with TABLE variable???"
- Previous message: Uri Dimant: "Re: DTS TRansform Task giving inconsistent results."
- In reply to: jrpm: "Re: Security"
- Next in thread: mat: "Re: Security"
- Reply: mat: "Re: Security"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
