Firewall Issues

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.

• Do the following procedure for each rule:

Image: Image:

• Click on the Browse button:

Image:

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

• Finally, name each rule accordingly: