change standard security password of sa

Dear All,
I failed to change the standard security password of sa
which is generated automatically. Whatever I changed it by
the function sp_password and it alerted successful. The
password of sa is still the same as before. How to change
the password of sa ......../.According to Books Online:
sp_password [ [ @.old =3D ] 'old_password' , ] { [ @.new =3D] 'new_password' } [ , [ @.loginame =3D ] 'login' ]
So, you would use something like this:
sp_password 'thecurrentpassword', 'thenewpassword', 'sa'
-- Keith
"ken" <anonymous@.discussions.microsoft.com> wrote in message =news:09c701c3c626$86cca000$a301280a@.phx.gbl...
> Dear All,
> I failed to change the standard security password of sa
> which is generated automatically. Whatever I changed it by
> the function sp_password and it alerted successful. The
> password of sa is still the same as before. How to change
> the password of sa ......../.|||When SQL Server is isntalled the sa password in NULL. There is not
automatically generated password. So if after installation the password for
sa in not NULL then someone is changing it after the installation.
Rand
This posting is provided "as is" with no warranties and confers no rights.

change standard security password of sa

Dear All,
I failed to change the standard security password of sa
which is generated automatically. Whatever I changed it by
the function sp_password and it alerted successful. The
password of sa is still the same as before. How to change
the password of sa ......../.Try logging into SQL Server using Windows Authentication as an
administrator on the machine. Then use Enterprise Manager, right click on
the sa account and change the password.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Change sa password error

Hi all,
I have a customer who is trying to change their sa password
in MSDE 2000 using the sp_password procedure.
When they attempt this, they are returned the following error:
Msg 552, Level 16, State 1, Server abcdef\inst, Procedure
sp_password, Line 63
CryptoAPI function 'CryptAcquireContext' failed. Error
0x80090006: Invalid
Signature.
Can anyone provide any insight into this?
From my own research it seems like there might be a problem
with their crypto library, but I am unsure of how to fix this.
Thanks
Jay
That's not exact, but close to an issue I had trying to run MSDE 2000 on NT
4.0 server. If you run MSDE 2000 on NT 4.0 with >512 MB of RAM, then
CryptoAPI functions have problems. Check out KB321459 on Microsoft.
"Jay" <anonymous@.discussions.microsoft.com> wrote in message
news:2b3d01c4a796$3f625b40$a601280a@.phx.gbl...
> Hi all,
> I have a customer who is trying to change their sa password
> in MSDE 2000 using the sp_password procedure.
> When they attempt this, they are returned the following error:
> Msg 552, Level 16, State 1, Server abcdef\inst, Procedure
> sp_password, Line 63
> CryptoAPI function 'CryptAcquireContext' failed. Error
> 0x80090006: Invalid
> Signature.
> Can anyone provide any insight into this?
> From my own research it seems like there might be a problem
> with their crypto library, but I am unsure of how to fix this.
> Thanks
> Jay
|||Yes I had already seen that KB.
I forgot to add in my original post that this is on a Win2K
server (SP4) with all latest patches.

>--Original Message--
>That's not exact, but close to an issue I had trying to
run MSDE 2000 on NT
>4.0 server. If you run MSDE 2000 on NT 4.0 with >512 MB
of RAM, then
>CryptoAPI functions have problems. Check out KB321459 on
Microsoft.
|||For the benefit of those who encounter this problem later.
Microsoft advised me to re-install IE to repair the mismatched DLL's.
I am waiting on the client to do this so I can't vouch for it's success, but
thought I would post this as it may help others in the future.
Jay
"Jay" wrote:

> Hi all,
> I have a customer who is trying to change their sa password
> in MSDE 2000 using the sp_password procedure.
>