Hi Chuk,
Assuming you are able to logon to windows NT/2000 server (PC where the SQL server is installed) with the NT Administrator account. If yes, then you just need to *ENABLE* the Windows Authentication. Now you can logon to SQL server without providing any password. Now you can change the sa password.

HTH

Sushil K Sharma
Sr. Systems Specialist
TIL NEPZ

-----Original Message-----
From: Speaks, Chuck W. [SMTP:Chuck.[Email Address Removed] Wednesday, May 22, 2002 1:34 AM
To: '[Email Address Removed] RE: Changing Lost SA Password



I have a remote admin that setup a SQL Server instance a while back and has
forgotten the sa password. I recall hearing something about a stored
procedure that will change the sa password without knowing the current
password. Does anyone have any information on this process?

Thanks,
Chuck


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page