Re: SQL 6.5 sa Password, how to change?
From: PBS (pbs_at_allwave.com)
Date: 02/05/04
- Next message: anonymous_at_discussions.microsoft.com: "Re: Another 17055 error problem"
- Previous message: Don: "Linked server config prob"
- In reply to: Russell Fields: "Re: SQL 6.5 sa Password, how to change?"
- Next in thread: Dan Guzman: "Re: SQL 6.5 sa Password, how to change?"
- Reply: Dan Guzman: "Re: SQL 6.5 sa Password, how to change?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 4 Feb 2004 17:55:12 -0700
OK:
I went ahead and changed the sa password. There must be some other gotcha
that I don't understand. After changing it I can no longer connect to SQL
Server. Do I need to Stop/Start the service? I changed the PW both through
Enterprise Manager, and using sp_password. In both cases I had to change it
back using sp_password to the original PW in order to connect to SQL.
Any suggestions?
Thank You,
Paul
"Russell Fields" <RussellFields@NoMailPlease.Com> wrote in message
news:e%23Djpqz6DHA.2712@tk2msftngp13.phx.gbl...
> 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: anonymous_at_discussions.microsoft.com: "Re: Another 17055 error problem"
- Previous message: Don: "Linked server config prob"
- In reply to: Russell Fields: "Re: SQL 6.5 sa Password, how to change?"
- Next in thread: Dan Guzman: "Re: SQL 6.5 sa Password, how to change?"
- Reply: Dan Guzman: "Re: SQL 6.5 sa Password, how to change?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
