Learning the Tricks of the Trade - Microsoft SQL Server 2008 R2 Administration - page 415

5. To set up a communication channel using your own port for each instance, scroll

down to Port property and set the relevant value (for instance 2383 ) and we need
to ensure that the defined port number has been added under the Windows firewall
exceptions list to allow connections.

6. By default, the Port property value is 0, which means the default port is 2383 used

by an Analysis Services instance.

7. To set BuiltIn | Administrator windows group as server admin, scroll down to

Security | BuiltinAdminsAreServerAdmins and choose false from the drop-down
box in the Value column. To set Service accounts as server admin, choose Security |
ServiceAccountsIsServerAdmin property and set it to true.

The default value for ServiceAccountsIsServerAdmin property is True,
which controls the SQL Server Analysis Services (SSAS) itself and is
considered to have administrative privileges to the Analysis Server.

8. To set the server time, scroll towards ServerTimeout property and set relevant value

in seconds, the default value is 3600 seconds. To set the temporary directory,
scroll down to the TempDir property to set the directory, and the default folder for
temporary analysis will be %:\Program Files\Microsoft SQL Server\
MSAS10_50.SQL2K8R2\OLAP\Temp .

Many of these server settings are affected after the instance is
restarted. All the settings as Advanced under Category and 'yes'
under Restart columns require a restart of the SSAS instance.

9. Click OK to effect all the selected changes and proceed to restart the SSAS instance
using SQL Server Configuration Manager tool.
10. Finally, to change language and/or collation settings for the installed Analysis
Services instance, click on the Language/Collation option on the Select a page
pane. Similarly, to add a specific user or group of users as Server Administrators for
SSAS instance, choose the Security option on the Select a page pane.

This completes the important points in administering and managing multiple instances of
Analysis Services using SQL server tools.

How it works...

The important aspect of this recipe is setting up the port to enable an SSAS instance to
accept the client connections. If the default port 2383 is changed on the SSAS instance,
then unless an Analysis Services client specifies a port number, the connection will not
be successful.