Re: Trouble with sa password

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 07/08/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 08 Jul 2002 12:48:10 -0600

If you don't have sa and the password listed in the dtsrun
command for the job, I would guess that you may have
schedule the packages using the DTS schedule package
functionality. In this case, it will create an encrypted
string for the dtsrun utility - the command in the job step
looks like: DTSRUN /~Zxxxxxxxxxxxx.
The login and password that is encrypted in this string is
based upon what login and password was used in Enterprise
Manager to register the server.
You can either change the dtsrun commands in the jobs, just
entering the dtsrun parameters yourself.
Or if you are using SQL Server 2000, you can use the
dtsrunui utility to generate the encrypted command. From the
advanced button on the dtsrunui utility, there is an option
to generate a command line. It will be based on
whatever login you use when the dtsrunui utility starts.
To generate the an encrypted command from 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 Mon, 8 Jul 2002 08:18:10 -0700, "Namir Rodriguez"
<namir_rodriguez@hotmail.com> wrote:

>No I'm not using sa to connect SQL Server inside my dts
>packages. I think that the packages has been saved with
>SQL Server security using sa.
>
>I will check it
>
>>-----Original Message-----
>>In your DTS packages how are your SQL Server
>>connections defined - if any use sa then you will
>>need to change the password or better still use NT
>authentication
>>
>>HTH
>>Jasper Smith
>>
>>"Namir Rodriguez" <Namir_Rodriguez@hotmail.com> wrote in
>message
>>news:12fde01c2239b$15cdb120$a5e62ecf@tkmsftngxa07...
>>> I have Windows Authentication in the Connection
>>> Properties.-
>>>
>>> I'm looking that the problem is only with the jobs that
>>> run DTS packages.
>>>
>>>
>>> >-----Original Message-----
>>> >In EM goto Management Folder>SQL Server Agent.
>>> >Right click and choose Properties and click on the
>>> >connection tab. Change the password or alternatively
>>> >use NT authentication
>>> >
>>> >HTH
>>> >Jasper Smith
>>> >
>>> >"Namir Rodriguez" <namir_rodriguez@hotmail.com> wrote
>in
>>> message
>>> >news:1545c01c22364$a04df300$3aef2ecf@TKMSFTNGXA09...
>>> >> Hi all!..
>>> >>
>>> >> I have a SQL Server with 25 jobs running.... The jobs
>>> >> executes Database Maintenance Plans over the
>databases
>>> and
>>> >> other run DTS Packages...
>>> >>
>>> >> When I change the 'sa' password, all the jobs fail
>with
>>> >> the message:
>>> >> Invalid password for user sa
>>> >>
>>> >> What can I do, I need to change de sa password
>>> >
>>> >
>>> >.
>>> >
>>
>>
>>.
>>