Post reply

SQL Clusters and Analysis Services DSO

  • December 13, 2004 at 11:44 pm

    #109114

    Greetings,

    My initial intension was not to cross-post, but I posted this issue earlier today on the SQL Server Administrators forum and so far have not received any feedback. As my need to clarify this configuration process is pressing, I decided to pose the same question under the Data Warehousing forum, in case I can attract the attention of an Analysis Services guru who has faced the same predicament.

    I have a need to run Analysis Services on a single Server instance, but obtaining its data from a SQL Server Cluster. I gather Analysis Services is not designed to work within a SQL Cluster. However, the Analysis Services instance outside the SQL Cluster will need to communicate with the appropriate SQL Server maintained data within that cluster.

    Does anyone know if there are any problems with installing the Decision Support Objects (DSO) within a SQL Cluster?

    If this configuration does work, are there any issues that I would need to consider?

    I do need Analysis Services to also integrate with an IIS based we application and I know that there are no issues with having DSO installed on that box.

    Any constructive feedback would be very much appreciated.

    Cheers,

    Wayne

  • December 15, 2004 at 1:13 am

    #533898

    Hi Wayne ,

    Obtaining data form another sql server is not at all a problem as its just another datasource for analysis services. However where will IIS be loaded? Explain your architecture in more detail as there are a few configurations that you need to do if the web site is not running on the same server as Analysis Services.

     

     


    Andy.

  • December 15, 2004 at 1:38 am

    #533901

    Hi Andy,

    Thanks for responding to my post. Actually, the IIS to Analysis Services piece of the puzzle is something that I don't have any problems with. I know that as long as DSO installed on the IIS Server (including SP3a), I will be fine with communicating with Analysis Services, which will be installed on a separate box.

    My question related to the need for DSO within the SQL Server Cluster. After further research, I think I'll found the answer. I don't think I even need to load DSO within the SQL Server Cluster, as the administration of Analysis Services (the OLAP Cube functions) will be soley from the IIS box.

    As there is no need for Analysis Service communication with the SQL Server Cluster, there will therefore be no need for DSO to be loaded within the Cluster.

    Thanks again for the reply.

    Cheers,

    Wayne

  • December 15, 2004 at 1:48 am

    #533903

    Maybe this will help.

    You must load DSO on the IIS front end. IIS an the Analysis services server.You use HTTP connectivity. You need to register msmdpump.dll on Front end and Analysis servers. Create a virtual dir on both machines with msolap.asp.

    I got this from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_datapump.asp

    I really battled to get this up on my servers. 32bit front end &  64bit back end.

    Good luck.


    Andy.

  • December 15, 2004 at 10:09 pm

    #534075

    Thanks Andy for your feedback.

    The link that you provided was very informative. I hadn't come across that one in my research. The suggestions may also be helpful as I go forward with this over the next few days.

    I really appreciate your assistance.

    Cheers,

    Wayne

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply