How to retrieve sa password on Win98?

Hi, we have a problem on a server of our customer running SQL Server
2000. That PC is connected to the Internet, and probably someone has
changed the sa password.
In fact, trying to connect to the sql server using "SQL Server
Enterprise Manager" results in this error message:
"A connection could not be established to SERVERNAME - Login failed for sa."
Query Analyzer instead gives: "Unable to connect to server. Server Msg
18456, Level 16, State 1. Login failed for user sa".
Searching on the net I have found a bunch of good ways to follow, even
if they all require to join into Windows as Administrator user (and
thus, using Windows Authentication mode).
However I can't proceed because the server that runs SQL Server is
Windows 98, thus Windows Authentication Mode is not available.
Can you help please?
TIA,
PaoloPaolo wrote:

> Hi, we have a problem on a server of our customer running SQL Server
> 2000.
Hrm... sorry, I meant SQL Server 7 ;)|||I was not aware that it is possible to install SQL Server on Windows 98.
Are you talking about MSDE? or perhaps the Developer Edition of SQL Server?
Since you did not take the appropriate steps to secure your "server" and you
already looked into other options but they will not work for you perhaps the
only option you have left is to contact Microsoft Support.
I do have one final idea: Shut down the "server" copy the database files,
and attach them to a new server. At least you will be able to access your
data.
Keith
"Paolo" <paolo@.red.it> wrote in message
news:%23EtmbfCkEHA.3160@.TK2MSFTNGP10.phx.gbl...
> Hi, we have a problem on a server of our customer running SQL Server
> 2000. That PC is connected to the Internet, and probably someone has
> changed the sa password.
> In fact, trying to connect to the sql server using "SQL Server
> Enterprise Manager" results in this error message:
> "A connection could not be established to SERVERNAME - Login failed for
sa."
> Query Analyzer instead gives: "Unable to connect to server. Server Msg
> 18456, Level 16, State 1. Login failed for user sa".
> Searching on the net I have found a bunch of good ways to follow, even
> if they all require to join into Windows as Administrator user (and
> thus, using Windows Authentication mode).
> However I can't proceed because the server that runs SQL Server is
> Windows 98, thus Windows Authentication Mode is not available.
> Can you help please?
> TIA,
> Paolo|||Keith Kratochvil wrote:

> I do have one final idea: Shut down the "server" copy the database files,
> and attach them to a new server. At least you will be able to access your
> data.
>
Thanks for the suggestion, it worked!
I copied a pristine master database from a vanilla sql server
installation to the "locked" sql server, then the databases containing
datas has been attached using sp_attach_db.
Finally I have specified a non blank password for user sa...
Regards,
Paolo|||I am glad that you were able to figure things out!
Keith
"Paolo" <paolo@.red.it> wrote in message
news:%23a6VLoOkEHA.3844@.TK2MSFTNGP12.phx.gbl...
> Keith Kratochvil wrote:
>
files,[vbcol=seagreen]
your[vbcol=seagreen]
> Thanks for the suggestion, it worked!
> I copied a pristine master database from a vanilla sql server
> installation to the "locked" sql server, then the databases containing
> datas has been attached using sp_attach_db.
> Finally I have specified a non blank password for user sa...
> Regards,
> Paolo