Read my last blog on Error while configuring SQL Server Cluster here. As a DBA, we cannot or say we should not limit our self to only Database Engine related stuff. Today let's learn something related to Analysis Service i.e. SSAS.
In one of the migration project, I wanted to migrate an SSAS Database which is called as "Cube" to another Server.
So firstly, I needed the backup of the Cube. See the following command to take the backup of the Cube.
|SSAS Cube Backup Code|
Now, I wanted to restore this backup to my new Server. But when I tried to connect the SSAS, it got failed due to SSAS was disabled. So tried to start the SSAS and it gave the following error:
And when I checked Windows Event Viewer it captured the below error message:
|Windows Event Viewer|
I started searching more in google related to this error and in most of the sites they will provide the same solution which we saw above. And the search continued and continued till I landed to the next solution. And solution was to check the msmdsrv.ini file (It is an Configuration file for AS).
Basically when we configure AS, we have to pass a location where Data and Log file will create, but in my case no such files where created. So what did was as follows:
1. Created two Folder's Data & Log on E:\ and F:\ drive respectively and gave full permission to it.
2. Open the msmdsrc.ini file (in notepad) from this location (default):
C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config
4. Then tried to re-start the AS and it was successfully started.
So the resolution for this seems simple. Want to know what is SQL Server Azure read my introduction post on Azure. Do comment if you like of dislike the page.
Thank You !!!
Keep Learning and Enjoy Learning !!!