Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.