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?
Right click on server which you have connected
In that select Server Properties - Security - [Server Authentication section] you check Sql Server and Windows authentication mode