Re: SA password change?

From: Luis F Rivera G (riveralf@hotmail.com)
Date: 06/05/02 

From: "Luis F Rivera G" <riveralf@hotmail.com>
Date: Wed, 5 Jun 2002 10:30:13 -0700

Thanks Sue... Great Tip!!!

Luis F Rivera G

>-----Original Message-----
>You have to generate a new dtsrun encrypted command. If
you
>are on SQL Server 2000, you can use the dtsrunui utility.
>>From the advanced button on the dtsrunui utility, there is
>an option to generate a command line. You'd need to use sa
>and the password for the login info in the utility. It
>encrypts the /U <username> and /P <password> for the
login
>and password of the package.
>If you are on SQL Server 7, You can do a dtsrun from the
>command line with the user, password, package name etc. -
>dtsrun /S Server /U user /P password /N Package,
>At the end, include the arguments /!X /!Y /!C
>The package won't execute, it will generate the encrypted
>command line and will copy the encrypted command to the
>clipboard for you to paste into a job. Strip off the
ending
>/!X /!Y /!C and that's the encrypted line you need.
>
>-Sue
>
>On Wed, 5 Jun 2002 08:41:30 -0700, "Luis F Rivera G"
><riveralf@hotmail.com> wrote:
>
>>Sue, excuse me. How can I change the sa password
encripted
>>in the DTS.
>>
>>
>>>-----Original Message-----
>>>If you have any applications referencing the sa account,
>>>they will have problems but they should probably be
>>changed
>>>to use an account other than sa.
>>>If you have any DTS packages that were scheduled
through
>>the
>>>schedule package option of the package by a user who had
>>>Enterprise Manager registered with the sa account, those
>>>will have the sa password encrypted in the dtsrun
command
>>>and will need to be changed.
>>>
>>>-Sue
>>>
>>>On Fri, 31 May 2002 08:54:31 -0700, "Termy"
>>><termyterm@yahoo.com> wrote:
>>>
>>>>I am jr DBA for a small company. We need to change the
>>SA
>>>>password. What pre tasks should be completed prior to
>>this
>>>>change and how should this (the change)be done? Your
>>>>answer may save a job!
>>>
>>>.
>>>
>
>.
>