Re: sa password

From: Beth Breidenbach (beth.breidenbach@getronics.com)
Date: 05/23/02 

From: "Beth Breidenbach" <beth.breidenbach@getronics.com>
Date: Thu, 23 May 2002 09:48:03 -0700

Or, if you're more inclined to SQL QueryAnalyzer (my preference)

sp_password oldpassword, newpassword, loginname

"Beth Breidenbach" <beth.breidenbach@getronics.com> wrote in message
news:OWZuLlnACHA.2080@tkmsftngp05...
> To reset your password:
>
> * go to SQL Enterprise Manager,
>
> * click the plus sign to expand your server's icon,
>
> * expand the "Security" folder,
>
> * click Logins,
>
> * select the "sa" user from the right-hand pane and double-click it
>
> * enter a password in the "Password" text-box. (NOTE: the asterisk mask
> appears even if you don't have a password assigned...)
>
> * Click "OK"
>
> * re-enter the password when prompted.
>
> * Click "OK"
>
> Best of luck,
>
> Beth
>
> "ben" <john88m@hotmail.com> wrote in message
> news:eoCrUinACHA.1340@tkmsftngp04...
> > How do i change the sa password?
> >
> >
>
>

Quantcast