SvenOlsen (cfo@ait.com) writes:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters.
>> Change LoginMode from 0 to 1. Restart SQL Server.
>
> I have been trying to recover a lost sa password as well. The SQL Server
> is not configured for windows authentication. When I looked in the
> registry for the key referenced above, it was not there.

Is the entire Parameters key missing, or is just the LoginMode missing?
In either case, why not just try adding the value and see if it helps?

Of course, an entire key tree is missing this can indicate that the
installation is broken in several ways.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp