Re: Resetting DTS password

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

Date: Wed, 29 Sep 2004 13:00:49 +0100

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
    ... 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. ...
    (microsoft.public.sqlserver.programming)
  • Re: Resetting DTS password
    ... 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. ...
    (microsoft.public.sqlserver.security)
  • Re: Error running DTS package on a schedule (only!)
    ... To determine wich account was used by SQL Agent: ... |> | When I try to schedule a job for this DTS package under SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduled Backup for SQL Database
    ... and the service does restart ok. ... >> For some reason the SQL agent under server management does not restart ... Only problem is when the SQL server ...
    (microsoft.public.sqlserver.server)
  • Re: Replication Monitor disappears
    ... account and see if it shows up. ... Looking for a SQL Server replication book? ... When I was setting up replication I had SQL ... Finally I was able to start the SQL Agent service by ...
    (microsoft.public.sqlserver.replication)