|
Configuration of a Firewall for Building Integration System (bis) 1 Purpose
|
bet | 7/10 | Sana | 31.03.2021 | Hajmi | 171,58 Kb. | | #13816 |
Port Usage of the SQL Server
The following settings have to be done on the PC where the corresponding SQL Server is running.
a) SQL Server for the BIS database connections (Event log/db9000, acedb, BIS Reports)
Port settings (UDP):
For Windows XP:
Start the Windows Firewall via “Start” – “Settings” – “Control Panel” – “Windows-Firewall”
Select tab „exceptions“
For Windows 7, Windows Server 2008 R2:
Start the Windows Firewall via “Start” – “Control Panel” – “Windows-Firewall”
Select “Advanced settings”, do the following for Inbound Rules
Add new Rule
Rule Type: Port (TCP)
For all Operating Systems:
Allow UDP port 1434 for SQL Server Browser service
Port settings (TCP):
For Windows XP:
Start the Windows Firewall via “Start” – “Settings” – “Control Panel” – “Windows-Firewall”
Select tab „exceptions“
For Windows 7, Windows Server 2008 R2:
Start the Windows Firewall via “Start” – “Control Panel” – “Windows-Firewall”
Select “Advanced settings”, do the following for Inbound Rules
Add new Rule
Rule Type: Port (TCP)
For all Operating Systems:
Allow TCP port 443 for SQL Server Browser service
Program settings (Sqlservr.exe):
For Windows XP:
Start the Windows Firewall via “Start” – “Settings” – “Control Panel” – “Windows-Firewall”
Select tab “Exceptions” and add the following program:
For Windows 7, Windows Server 2008 R2:
Start the Windows Firewall via “Start” – “Control Panel” – “Windows-Firewall”
Select “Advanced settings”, do the following for Inbound Rules
Add new Rule
Rule Type: Program
Allow the following program:
For all Operating Systems:
C:\Program Files\Microsoft SQL Server\MSSQL10.(INSTANCE_NAME)\MSSQL\Binn\sqlservr.exe
(in case of Windows 7 64 Bit or Windows Server 2008 R2 64 Bit the path can be C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.(INSTANCE_NAME)\MSSQL\Binn\sqlservr.exe)
|
| |