Surface Area Configuration for Services and Connections (Remote Connections) - Analysis Services

SQL Server Setup

In Microsoft SQL Server 2005 Express Edition, Developer Edition, and Evaluation Edition, remote connections are disabled by default. In other editions, remote connections are enabled by default. Use this dialog to enable or disable remote connections.

Enabling remote connections for Analysis Services opens a TCP/IP port on the server. Enable remote connections only if you want to allow connections from remote computers.

Note:
You must restart the Analysis Services service to apply protocol changes.

Options

Local connections only

Select this option to disable remote connections.

If this option is selected, the Analysis Services instance listens for connections from the local computer only. Connections from remote computers fail.

Local and remote connections

Select this option to enable remote connections.

If this option is selected, the Analysis Services instance listens for connections from the local computer and from remote computers using TCP/IP.

See Also