Ports to firewall --
1976 for SQL Server (other SQL Server installations use port 1433)
TDP: 139, 445
UDP: 137, 138
Registry hack -- Enable Local Account Token Filter Policy
Regedit
Expand the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
If the LocalAccountTokenFilterPolicy registry entry does not exist, follow these steps:
On the Edit menu, click New, and then click DWORD Value.
Type LocalAccountTokenFilterPolicy, and then press ENTER.
Right-click LocalAccountTokenFilterPolicy, and then click Modify.
In the Value data box, type 1, and then click OK.
Exit Registry Editor.
No need to reboot.
Dave J
Comments