Re: SQL 6.5 sa Password, how to change?

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 02/04/04


Date: Wed, 4 Feb 2004 11:10:48 -0500

Paul,

Use sp_password to change it. Make it a strong password. Here is
Microsoft's simple definition of strong:

Security Note Use strong passwords. A strong password makes it more
difficult for unauthorized users to break into a system by cracking the
password. A strong password is at least seven characters long; contains a
combination of letters, numbers, and symbol characters within the password;
and is not a dictionary word, command name, person's name, or system user
name. A strong password also is updated regularly and is significantly
different from previous passwords.

And never, never, never have an application run as sa. (This will slightly
limit what the application can do.) Always run as a user with appropriate
rights granted.

Russell Fields
"PBS" <pbs@allwave.com> wrote in message
news:ONAHHaz6DHA.2064@TK2MSFTNGP11.phx.gbl...
> Hello:
>
> What is the procedure for changing the sa password in SQL 6.5?
>
> Thanks
> Paul
>
>