Category Archives: Analysis Services

Backing Up an Analysis Services Database

How to Backup Analysis Services Database ? Backing up Analysis Services database, lets administrators save a particular state of a SQL Server Analysis Services database and its objects. We can take Analysis Services Database Backup in various ways Manually, graphically using SQL Server Management Studio Manually, using a XMLA command / script Schedule a Analysis [...]

Create a XMLA for SQL Analysis OLAP Database Backup

What is Script to take OLAP Database backup manually ? How to Backup Analysis Services Database ? YES, we can create a XMLA script to backup OLAP database . Backing up Analysis Services database, lets administrators save a particular state of a SQL Server Analysis Services database and its objects. We can take Analysis Services [...]

Max Memory setting for SQL Server Analysis Services

Can we set a MAX Memory setting for Microsoft SQL Server Analysis Services like Microsoft SQL Server Database Engine ? How can control memory for SQL Server Analysis Services ? Yes, we can control memory utilization of SQL Server Analysis Services. But this is also true that we cannot directly restrict the SQL Server analysis [...]

SQL Server Analysis Services Authentication Modes

Question : Can I have SQL Server Authentication Modes for SQL Server Analysis Services ? OR What Authentication Mechanisms are available for SQL Server Analysis Services ? Answer : SQL Server Analysis Services (SSAS) supports only Windows Authentication.  Thus there is no option left out for setting up SQL Server Analysis Services Authentication Mode.

SQL Server Analysis Services Clustering

Does Microsoft SQL Server Analysis Services (SSAS) Supports clustering ? YES, Microsoft SQL Server Analysis Services (SSAS) supports windows clustering. SQL Server Analysis Services is independent service and SSAS resource is not dependent on the SQL Server Database Engine resource. Analysis Services on clustered environments listens on the default port – TCP 2383. Even if [...]

SQL Server Analysis Services Editions

Can I use Analysis Services in SQL Server Express Edition ? SQL Server Analysis Services available in what all editions ? SQL Sever Analysis Services (SSAS) is supported by following Editions of SQL Server Standard Edition Developer Edition Enterprise Edition DataCenter Edition Evaluation Edition SQL Server Analysis Services, Integration Services or  Reporting Services are not [...]

Change SQL Server Analysis Services Port

Can I Change SQL Server Analysis Services Port ? How to Change SQL Server Analysis Services Port ? Yes, you can change SQL Server Analysis Services Port my making Changes in Analysis Services Configuration File. There are two ways of Changing SQL Server Analysis Services Change SSAS port using Configuration File Change SSAS port using [...]