August 15, 2011 at 12:39 pm
Right now in my environment, I have SSDE, SSRS and SSAS all in one server(Single BOX).
Now, I have to move the SSAS services to another server so that OLTP and OLAP will be in two diffrent boxes.
How do I do that?
What will be the Impacts on having the SSAS services seperated from the database engine?
April 4, 2012 at 11:50 am
Moving SSAS instance from a server.
First take Cube bakups.
next apply them to destination server (double check src (ware house it is using)).
Make sure you change to new server name in cube processing jobs.
Take care of the Service accounts.
If there are any reports related to the cubes change the servernames for that.
depend up on whether its two tier or three tier application make changes over there.
contact your sys admin make a DNS flush (this will speed up the server request queue)
Add if I am missing any thing.
friendly
@bi
April 4, 2012 at 11:55 am
You do realize that you need a separate license for this? If someone tells you that you don't, they are wrong (past experience). I take this as step 1.
Jared
CE - Microsoft
April 4, 2012 at 11:25 pm
+1 for the licensing
How to get your cube to the other server:
Analysis Services Deployment Methods
(this was the first result for the google search deploy ssas)
Or just deploy from the BIDS solution if possible.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 11:56 pm
Koen Verbeeck (4/4/2012)
+1 for the licensingHow to get your cube to the other server:
Analysis Services Deployment Methods
(this was the first result for the google search deploy ssas)
Or just deploy from the BIDS solution if possible.
+1
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply