Home / server / Questions / 118540
Accepted
Clay Nichols
Asked: 2010-03-03 15:38:18 +0800 CST

Any way to switch SQL Server 2008 Express from "windows autentication" to "mixed mode"?

  • 772

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)?

sql-server-2008 windows-7

3 Answers

  1. Best Answer

    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.

    • 1

  2. 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.

    • 0

  3. 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
    • 0