Trucos de Sql Server How to change the security mode in SQL Server after installation

Another way to change the security mode after installation is to stop SQL Server and set the appropriate registry key for your installation:

Default instance:

HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode

Named instance:

HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\LoginMode

to 0 or 2 for mixed-mode or 1 for integrated. (Integrated is the default setup for the SQL Server 2000 Data Engine.)

Note The 0 and 2 values have the same functionality. They both set the security to mixed-mode.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To set this key to mixed-mode, follow these steps:

1.
Stop SQL Server and all related services, such as SQLAgent, from the Services control panel.

2.
Click Start, click Run, type regedt32, and then click OK.

3.
Find the HKEY_LOCAL_MACHINE window on the local computer.

4.
Navigate to the following registry key for the default instance:

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer

5.
Navigate to the following registry key for a named instance:

HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\LoginMode

6.
On the right-hand pane, find the value LoginMode and double-click it.

7.
In the DWORD Editor window, set the value to 0 or 2. Also, make sure that the Hex radio button is selected.

8.
Click OK.


Restart SQL Server and SQL Server Agent services for this change to take effect.