How to: Configure Windows Firewall for Analysis Services Access
Windows Firewall system prevents unauthorized access to computer resources. To access an instance of Analysis Services through this firewall you must configure the firewall to enable access. There are many firewall systems available. If you are running a firewall other than Windows Firewall, consult your firewall documentation for information that is specific to your system. The information that follows is specific to Windows Firewall.
You must configure Windows Firewall to enable access to the relevant port for authorized users or computers, including configuring Analysis Services to use a specific TCP/IP port. The default instance of Analysis Services uses port 2383, but that can be changed. Named instances of Analysis Services use dynamic ports. For more information about how to configure for the use of a specific port, see How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager). If you are running a default instance of Analysis Services only, using the SQL Server Browser service is optional. To use SQL Server Browser, you must open UDP port 1434.
Note
By default, Microsoft Windows XP Service Pack 2 enables the Windows Firewall, which closes port 2383 to prevent Internet computers from connecting to your computer. Connections to Analysis Services over the Internet using TCP/IP will not work unless you reopen port 2383. For more information, see your Windows documentation.
To configure the Windows XP Firewall or Windows Server 2003 Firewall
In Control Panel, double-click Windows Firewall.
In the Windows Firewall dialog box, click the Exceptions tab, and then click Add Port.
The Add a Port dialog box opens. In the Name box, type Analysis Services.
In the Port Number box, type the port number of the Analysis Services instance, for example, 2383, for the default instance.
Make sure that TCP is selected, and then click OK.
Note
If you are running named instances of Analysis Services, you must make sure the port number for that named instance is listed as an exception and that SQL Server Browser service is also listed as an exception.
To open the port to make available the SQL Server Browser service
In Control Panel, double-click Windows Firewall.
In the Windows Firewall dialog box, click the Exceptions tab, and then click Add Port.
The Add a Port dialog box opens. In the Name box, type SQL Server Browser.
In the Port Number box, type 1434.
Select UDP, and then click OK.
Note
Click Add Program in the Windows Firewall dialog box for additional options, such as granting access to specific programs, and restricting access to certain IP addresses or network subnets. For more information, see your Windows documentation.
See Also
Other Resources
Administering Analysis Services in Management Studio How-to Topics
How to: Configure a Firewall for SQL Server Access
SQL Server Browser Service