Microsoft Analysis Server 9.0 processing on wrong machine

karnax
karnax used Ask the Experts™
on
In order to do some testing of our OLAP cubes, I have done a database backup of both the SQL server data, and the Analysis server data from our live machine. I made some changes to my local copy of the SQL server, then went to the Microsoft SQL Server Management Studio, connected to my localhost machine, right-clicked on the Analysis services database, and ran the "process" command. This seems to process the data on the live server, not on my localhost. Is this because I restored on my localhost from a backup? Is there a way to change this to run it locally against the local SQL server and local Analysis server databases?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I might have answered my own question. If you click on the database, then "Data Sources", you will see your database. Right-click and go to properties. In the properties under "Connection String" you can change what to connect to.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial