missing password

Hi there,
I have run up a WSUS server and used msde for the sql database and
sods law I thought I'd be clever and use a different password to
normal which at the time I thought I'd remember and I've completely
forgot it.
By any chance does anyone know of a way I can now retrieve this as I
would like to link up the server in enterprise manager.
Any help would be appreciated, even if its too say I've got no chance.
Many thanks.Login to MSDE using windows authentication and change the password.
Steps:-
1. Login into MSDE machine using a Admin account
2. go to command prompt
3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
4. Execute SP_Password NULL,'New_sa_password','SA'
This will change the SA password to the password you provide in step 4.
Thanks
Hari
"CJC" wrote:
> Hi there,
> I have run up a WSUS server and used msde for the sql database and
> sods law I thought I'd be clever and use a different password to
> normal which at the time I thought I'd remember and I've completely
> forgot it.
> By any chance does anyone know of a way I can now retrieve this as I
> would like to link up the server in enterprise manager.
> Any help would be appreciated, even if its too say I've got no chance.
> Many thanks.
>|||Thanks for your reply, I have only had chance to look at it.
This command for changing the password, will it matter what username I
initially used when setting it up, as I probably didnt use SA? Or is
this command saying I am creating this password for this username, so
in theory could I put 'joe.bloggs' instead of 'sa'
Also I'm terrible for being over cautious, is this likely to screw
anything else up, as currently the server is running fine, its just I
cannot link WSUS into enterprise manager.
Thanks again.
On 2 Feb, 20:54, Hari Prasad <HariPra...@.discussions.microsoft.com>
wrote:
> Login to MSDE using windows authentication and change the password.
> Steps:-
> 1. Login into MSDE machine using a Admin account
> 2. go to command prompt
> 3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
> 4. Execute SP_Password NULL,'New_sa_password','SA'
> This will change the SA password to the password you provide in step 4.
> Thanks
> Hari
> "CJC" wrote:
> > Hi there,
> > I have run up a WSUS server and used msde for the sql database and
> > sods law I thought I'd be clever and use a different password to
> > normal which at the time I thought I'd remember and I've completely
> > forgot it.
> > By any chance does anyone know of a way I can now retrieve this as I
> > would like to link up the server in enterprise manager.
> > Any help would be appreciated, even if its too say I've got no chance.
> > Many thanks.