Monday, July 18, 2011

How to change Sql server Windows Authentication to Mixed Mode Authentication

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?

Ans:-

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

No comments:

Post a Comment