Re: Security
From: mat (mat_at_discussions.microsoft.com)
Date: 12/13/04
- Next message: Maury Markowitz: "Re: What's the proper syntax for this?"
- Previous message: ChrisR: "long running jobs crashing the box"
- In reply to: mat: "Re: Security"
- Next in thread: jrpm: "Re: Security"
- Reply: jrpm: "Re: Security"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 13 Dec 2004 08:33:07 -0800
this is the error
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Timeout expired
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
"mat" wrote:
> 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: Maury Markowitz: "Re: What's the proper syntax for this?"
- Previous message: ChrisR: "long running jobs crashing the box"
- In reply to: mat: "Re: Security"
- Next in thread: jrpm: "Re: Security"
- Reply: jrpm: "Re: Security"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
