Tuesday, February 07, 2012
Sign-up
Home

Videos

Forums

About
       Contact Us
       Meet the Instructors
You are @ Forums
 
 Ads
  

 
 Learn Microsoft BI Forum
 
  Learn Microsoft BI Forum  Core Servers  Analysis Servic...  Moving SSAS to another server
Previous Previous
 
Next Next
New Post 5/6/2009 2:29 PM
  shairal
9 posts
No Ranking


Moving SSAS to another server 

Initially I built all my SQL '08 databases, SSIS, and SSAS packages on a virtual machine.  Now I need to move everthing over to a new server we have purchased.  However, moving my SSAS cubes has been a nightmare, though I don't think it should be - must be the user :-) 

I think the first issue I need to address is,  I get a message ... The Source property references unknown 'Data Source View' with ID = 'MyDatabase'.  I get this message for each of the tables in my cube.

Also, I'm wondering about permissions ... my SSAS service account was named differently with different passwords in my vm - how is this going to effect the processing?

I did a restore to get all my databases over to the new server and they all work fine. 

Thanks in advance for the help!

 
 
New Post 5/6/2009 11:02 PM
  cutley
363 posts
1st Level Poster


Re: Moving SSAS to another server 

Normally to move cubes I just do a backup and restore. Right after the restore I change the data source connections to point to the new server. That should take care of all the issues. However, the message you are getting says that it can't find a DSV... I can't say I've heard of that one. What is the name of the DSV in the SSAS database? Did you change the name after you moved it? Was the cube fully processed when you moved it?

The SSAS service account should be fine as long as the data source uses an account that has access to the data. If the account the data source uses is the same as the SSAS service account, make sure the service account has at least read access to the database.
 
New Post 5/7/2009 12:44 PM
  shairal
9 posts
No Ranking


Re: Moving SSAS to another server 

ugh! I found my error ... when I did a backup and restore of the database onto the new server, I made a typeo when naming the database.  Once I took the db offline, renamed it correctly and brought it back up, all worked fine.  It's amazing the havoc one extra little letter can cause!  Thanks for your help! 

You're site is a life saver! Love the videos - they have helped me tremendously!
 
 Page 1 of 1
Previous Previous
 
Next Next
  Learn Microsoft BI Forum  Core Servers  Analysis Servic...  Moving SSAS to another server
  
Copyright 2011 by CIOBriefings LLC