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:
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)
|
