Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to enable mixed mode authentication (SQL Server and Windows).

I've tried following these rules but the registry key I need to change is missing...

any ideas on how I can do this?


MSDE 2000
Windows Server 2003 x64

MSDE 2000 is part of another program (Ipswitch's WhatsUp 2005) so I'm unable to set any install switches.

share|improve this question
What version of SQL server and windows? – Zypher Sep 2 '11 at 20:11
updated my question with the versions – Trev Sep 6 '11 at 17:10

If you've not started using MSDE yet, and I'm assuming you're referring to MSDE 2000, then my suggestion would be to uninstall it and reinstall it from the command line using the appropriate install switches to enable mixed mode authentication and whatever additional options you need enabled, such as network protocols.

share|improve this answer
MSDE is installed as part of another program (Ipswitch's WhatsUp 2005) and I don't think I'm able to set any install switches, if I was this would probably be the correct answer.... updated my question with this info. – Trev Sep 6 '11 at 17:12
up vote 0 down vote accepted

Ok, I figured it out from this post

MSDE uses 32-bit registry keys, and on a 64-bit server these keys are stored in a different location in the Registry. They were stored under HKEY_LOCAL_MACHINE\SOFTWARE\ Wow6432Node\Microsoft\MSSQLServer

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.