Re: Resetting DTS password

From: Allen Davidson (allen.davidson_at_europe.mccann.com)
Date: 09/29/04


Date: Wed, 29 Sep 2004 14:37:00 +0100

Hi Tudor - in this case I think you are stuck.

The pakage will be stored in encrypted form and without the owner password I
don't think you can do anything (anything at all usefull) with it.

Allen

"Tudor Sofron" <tsofron@cluj.astral.rom> wrote in message
news:eG$U24hpEHA.3520@TK2MSFTNGP11.phx.gbl...
> Doesn't help. I can't do that until i open the package...What I need is to
> change the owner password of the dts...
>
> Tudor
>
>
>
> "Allen Davidson" <allen.davidson@europe.mccann.com> wrote in message
> news:eoaY3vhpEHA.1296@TK2MSFTNGP12.phx.gbl...
> > Hi Tudor - I would change the owner of the package.
> >
> > We run/own all our packages under a 'pretend' domain account reservd for
> > SQL - this is also the account that SQL and SQL agent run under.
> >
> > Hope this helps.
> >
> > "Tudor Sofron" <tsofron@cluj.astral.rom> wrote in message
> > news:O0fjbohpEHA.868@TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > > can anybody please how to reset passwords for an DTS? I need to edit
and
> > run
> > > it...but the former DBA left without giving us the passwords...
> > >
> > > Thanks,
> > > Tudor
> > >
> > >
> >
> >
>
>



Relevant Pages

  • Re: Resetting DTS password
    ... The pakage will be stored in encrypted form and without the owner password I ... don't think you can do anything (anything at all usefull) with it. ...
    (microsoft.public.sqlserver.server)
  • Re: Resetting DTS password
    ... The pakage will be stored in encrypted form and without the owner password I ... don't think you can do anything (anything at all usefull) with it. ...
    (microsoft.public.sqlserver.programming)