Erland Sommarskog wrote:
> I assume that the server is not configured for Windows Authentication?
> But as long as you have Windows admin privilege on the box, this can be
> arranged. Go the registry, and find
>
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. The server (very
old) is running NT4 Service Pack 6. I also searched the registry for
local users that registered the sql server in enterprise manager. I found
logins and passwords in the registry but none of them happened to be the
sa password.