tags:

views:

679

answers:

2

hi, I have installed Sql Server 2008 express edition but by mistake I kept the windows authentication mode.

Now I want to change that to SQL SERVER MIXED mode. How to do this?

Edit:

After getting the answer from Jason Punyon & Svetlozar Angelov, I checked Server Authentication under security tab where I found that the Default value selected is Sql Server & Windows mode.

Then why not I can use the Mixed mode and I have to login via Windows authentication? I am 100% confident that when I installed I kept the mode to be Windows Authentication only!

Thanks in advance

+4  A: 

You can do it with SQL Management Studio -

Server Properties - Security - [Server Authentication section] you check Sql Server and Windows authentication mode

Here is the msdn source - http://msdn.microsoft.com/en-us/library/ms188670.aspx

Svetlozar Angelov
Thank you very much. Atlast I got the success after going thru the link.
priyanka.sarkar
A: 
  1. Open up SQL Server Management Studio and connect to your database server.
  2. Right Click The Database Server and click Properties.
  3. Set the Server Authentication to SQL Server and Windows Authentication Mode.
Jason Punyon