Re: SA password change?
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/31/02
- Next message: Johan: "SQL Server Security: NT Groups"
- Previous message: Pankul Verma: "Re: major security concern - any sql user with minimal permission can see code for all stored procs and triggers"
- In reply to: Termy: "SA password change?"
- Next in thread: Luis F Rivera G: "Re: SA password change?"
- Reply: Luis F Rivera G: "Re: SA password change?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Fri, 31 May 2002 11:52:51 -0600
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!
- Next message: Johan: "SQL Server Security: NT Groups"
- Previous message: Pankul Verma: "Re: major security concern - any sql user with minimal permission can see code for all stored procs and triggers"
- In reply to: Termy: "SA password change?"
- Next in thread: Luis F Rivera G: "Re: SA password change?"
- Reply: Luis F Rivera G: "Re: SA password change?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
