Industrial Scientific DSX-L, Startup Manual

Page: 61 / 120

57
3.14. Configuring the Firewall
3.14.1. Windows Firewall Settings for SQL Server
Step Instruction
NOTE: the user should be logged-on as an Administrator to perform the following
tasks.
1.
Make sure that “IIS_IUSRS” group has been provided the full access permissions for
“C:\Windows\Temp” directory.
•
Navigate to C:\Windows.
•
Right-click on “Temp” directory and choose Properties.
•
In Security tab, make sure that IIS_IUSRS group has been listed. If not listed,
click the “Modify” or “Edit” button; click the “Add” button and add
“IIS_IUSRS”; and click the Resolve button on the right-hand side. Mark “Full
Control” and click Apply and OK. It will give one warning message; click OK.
2. Enable Windows Firewall if it was disabled earlier.
3. Go to All Programs >> Microsoft SQL Server {Version} >> Configuration Tools >>
SQL Server Configuration Manager.
4. Choose SQL Server Services and check that SQL Server (<<instance name>>) is
running.
5. Navigate to SQL Server Network Configuration >> Protocols for MSSQLSERVER and
Enable TCP/IP if it is disabled.
6. Navigate to SQL Server Network Configuration >> Protocols for DSS (if available) and
Enable TCP/IP if it is disabled.
7. Right-click on TCP/IP and choose Properties.
Scroll to the bottom and clear TCP Dynamic Ports and add TCP Port as “14331” ( note: