Friday, March 30, 2012

How to change the directories used by the "SQL Server Analysis Services"

I had to change the directories used by the SQL Server Analysis Services. This is what I have done.

    I have changed the directories for the SQL Server Analysis Services through the properties window Next I stopped the SQL Server Analysis Services and moved the entire OLAP directory to a different directory on the same drive Then I tried to start the SQL Server Analysis Services which fails

In the Event log I only see the following entry:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 8355
Date: 18/04/2007
Time: 13:02:53
User: N/A
Computer: SQLSERVER
Description:
Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected as well. Bring msdb online, or enable Service Broker.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: a3 20 00 00 10 00 00 00 £ ......
0008: 0a 00 00 00 49 00 53 00 ....I.S.
0010: 4f 00 41 00 50 00 50 00 O.A.P.P.
0018: 32 00 35 00 34 00 00 00 2.5.4...
0020: 07 00 00 00 6d 00 61 00 ....m.a.
0028: 73 00 74 00 65 00 72 00 s.t.e.r.
0030: 00 00 ..

By changing the directories back to their original values in the msmdsrv.ini file and moving the entire directory back to its original location I was able to start the SQL Server Analysis Services, but I really need to move the directories, any help is appreciated.

As with any application, after it is installed, it is not easy to move it to different location. I would strongly recommend that you consider re-installing SSAS.

But, there is a way for you to move data folder, that is usually the biggest folder.

For that go to SSAS properties, change parameter: DataDir to your desired location, then stop SSAS, move your data folder to new location and start SSAS.

Vidas Matelis

No comments:

Post a Comment