Friday, March 30, 2012

Running Analysis Services 2005 on a separate sever

My first question is can I run Analysis Services 2005 on a different server to where the databases are running

If yes, any pointers to some articles.

Hi justSomeone,

You can create an empty Analysis Services database within an instance of Analysis Services, by using either SQL Server Management Studio or Business Intelligence Development Studio, and then connect directly to that database using Business Intelligence Development Studio and create objects within it (rather than within a project). When working with an Analysis Services database in this manner, changes made to objects take effect in the database to which you are connecting when the changed object is saved.

You may find this article is useful to you:http://msdn2.microsoft.com/en-us/library/ms174953.aspx

Also, this one:http://msdn2.microsoft.com/en-us/library/ms174953.aspx gives you a step-by-step guidline on how to configure datasource in Microsoft SQL Server 2005 Analysis Services (SSAS).

Hope my suggestion helps

No comments:

Post a Comment