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