Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 installed SQL Server Express but may have have done so setting it in "windows authentication" mode.

It took forever to install. Is there a way to switch it to "mixed mode" (or even verify whether it's in Mixed Mode)?

share|improve this question
up vote 1 down vote accepted

Try this registry hack. Change the value in:

HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\LoginMode

to 0 or 2 for mixed mode. 1 means integrated auth.

Details are in this MS KB.

share|improve this answer
I ended up just reinstalling. I think that may have been a better idea because it also prompted me for a Server Admin Password during the install (didn't do that in previous install). – Clay Nichols Mar 4 '10 at 14:37
you can re-set the sa password from your integrated auth login – Nick Kavadias Mar 5 '10 at 10:14

You should be able to download and install SQL Server Management Studio Express and see/set the authentication mode using it.

Once SSMSE is installed, you can connect to your SQL Server instance, right click the instance name and go to Properties. From there go to the Security page, and you should see a radio selection for "Windows authentication mode" or "SQL Server and Windows authentication mode". The latter is mixed mode.

share|improve this answer

In SQL Server Management Studio:

  1. Open Object Explorer
  2. Right click on root entry
  3. Click Properties
  4. Under Security Change to: SQL Server and Windows Authentication Mode
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.