Re: SQL 6.5 sa Password, how to change?
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 02/04/04
- Next message: Steve Thompson: "Re: SQL 6.5 sa Password, how to change?"
- Previous message: Russell Fields: "Re: Linked Server : SQL Server 2000"
- In reply to: PBS: "SQL 6.5 sa Password, how to change?"
- Next in thread: PBS: "Re: SQL 6.5 sa Password, how to change?"
- Reply: PBS: "Re: SQL 6.5 sa Password, how to change?"
- Reply: PBS: "Re: SQL 6.5 sa Password, how to change?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
>
>
- Next message: Steve Thompson: "Re: SQL 6.5 sa Password, how to change?"
- Previous message: Russell Fields: "Re: Linked Server : SQL Server 2000"
- In reply to: PBS: "SQL 6.5 sa Password, how to change?"
- Next in thread: PBS: "Re: SQL 6.5 sa Password, how to change?"
- Reply: PBS: "Re: SQL 6.5 sa Password, how to change?"
- Reply: PBS: "Re: SQL 6.5 sa Password, how to change?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]