How can I change from SQL Server Windows mode to mixed mode SQL Server 2008

Question

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 can I do this

User · Answer

From this  http   weblogs sqlteam com peterl archive 2008 06 19 How-to-change-authentication-mode-in-SQL-Server aspx  One can catch that you may change it through windows registry key    SQLEXPRESS instance     Software Microsoft Microsoft SQL Server SQLEXPRESS LoginMode    2       and restart service

User · Answer

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

User · Answer

From MSDN   To change security authentication mode      In SQL Server Management Studio Object Explorer  right-click the   server  and then click Properties       On the Security page  under Server authentication  select the new   server authentication mode  and then click OK       In the SQL Server Management Studio dialog box  click OK to   acknowledge the requirement to restart SQL Server       In Object Explorer  right-click your server  and then click Restart    If SQL Server Agent is running  it must also be restarted    To enable the SA login      In Object Explorer  expand Security  expand Logins  right-click SA    and then click Properties       On the General page  you might have to create and confirm a password   for the login       On the Status page  in the Login section  click Enabled  and then   click OK

User · Answer

If the problem is that you don t have access to SQL Server and now you are using mixed mode to enable sa or grant an account admin privileges  then it is far easier just to uninstall SQL Server and reinstall

User · Answer

I had no success with other attempts on a SQL Server 2012  What I did was use SQL Server Management Studio to generate a script to change the value  and got this   USE  master  GO EXEC xp instance regwrite N HKEY LOCAL MACHINE   N Software Microsoft MSSQLServer MSSQLServer   N LoginMode   REG DWORD  2 GO   After that  I enabled the sa account using this   ALTER LOGIN sa ENABLE   GO ALTER LOGIN sa WITH PASSWORD     lt strongPasswordHere gt     GO      then  I restarted the service  and everything worked

User · Answer

Open the registry and search for key LoginMode under   HKEY LOCAL MACHINE SOFTWARE Microsoft Microsoft SQL Server   Update the LoginMode value as 2

User · Answer

Open up SQL Server Management Studio and connect to your database server  Right Click The Database Server and click Properties  Set the Server Authentication to SQL Server and Windows Authentication Mode

[sql-server] How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?

Examples related to sql-server