Step 14 - Add DisableStrictNameChecking Registry Key

  • Article

Applies To: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012

This step explains how to add the DisableStrictNameChecking registry key. This key allows connections to be made to the SQL server by names other than the proper name. By default, SQL Server 2008 will not allow this.

To add the DisableStrictNameChecking Registry Key

  1. Log on to SQL2.fabrikam.com as fabrikam\Administrator.

  2. Click Start, type regedit.exe in the Start Search box, and then press ENTER.

  3. Expand the following registry key:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters

  4. Right-click Parameters, click New, and then click DWORD (32-bit) Value.

  5. In the Value name box, type DisableStrictNameChecking, and then press ENTER.

  6. Double-click the DisableStrictNameChecking registry value and type 1 in the Value data box, and then click OK.

  7. Close Registry Editor.