Difference between revisions of "Firewall Issues"

From DataSelf Knowledge Base
Jump to navigation Jump to search
 
Line 1: Line 1:
{{#breadcrumb:Main Page}}
+
{{#breadcrumb:BI_Installation_and_Trouble-shooting}}
 
[[Category:Firewalls]]
 
[[Category:Firewalls]]
 
{{TOCFloatRight}}
 
{{TOCFloatRight}}

Latest revision as of 22:21, 4 March 2015

Firewall Settings on Windows Server

Firewall is found in Control Panel - go to Advanced Settings.

See the attached pdf, at the end about setting ports, since you may just need to set a PORT permissions, and not the program permissions as below. https://dataselfsupport.com/attachments/61/DsBi_MsSqlServer2008R2Installation1103.pdf

Firewall is Preventing Workstations from Connecting to the Server

You may have to configure Windows Firewall settings to allow remote access to MS SQL Server and MS Analysis Services. For details, please visit http://msdn.microsoft.com/en-us/library/cc646023.aspx.
Tip: here are common ports used by SQL services:
a. For the default instance or the only named instance on a server: TCP port 1433, TCP port 2383.
b. For named instances: UDP port 1434, TCP port 2382

The server’s firewall was preventing workstations from connecting to the server.

  • Add two new rules to firewall: MSSQLservice and SSASservice.

firewall1.JPG

  • Do the following procedure for each rule:

Image:firewall2.JPG Image:firewall3.JPG

  • Click on the Browse button:

Image:firewall4.JPG

  • Go to the SQL folder and add the apps responsible for SQL and AS services:
Usually: C:Files\Microsoft SQL Server 2008\MSSQL10_50.DSBI\MSSQL\Binn\sqlservr.exe

C:Files\Microsoft SQL Server 2008\MSAS10_50.DSBI\OLAP\bin\msmdsrv.exe

(that is, MS SQL 10_50 and MS AS 10_50)

firewall5.JPG

firewall6.JPG

firewall7.JPG

  • Finally, name each rule accordingly:

firewall8.JPG