Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 08-07-2009
Member
 
Join Date: Jun 2009
Posts: 41
SQL 2008 Cluster Adding Analysis Services

Hello
On my Windows Server 2003 Enterprise Edition am with two node SQL Server 2008 Enterprise Edition cluster.and now i wish to append SSAS to the current cluster installation.but the thing is that it fails stating that the instance is clustered and to choose another instance.while i try to by "New Installation or Add features,on the rule check at the end of the install wizard.So any one here to help me out to install SSAS to an existing cluster installation with out major issues
any helps would be greatly received
thanks in advance
Reply With Quote
  #2  
Old 08-07-2009
Member
 
Join Date: May 2008
Posts: 3,313
Re: SQL 2008 Cluster Adding Analysis Services

Instead of the typical install process change the list of installed programs populates, locate Microsoft SQL Server 2005 and click.optthe instance you're going to alternate and select Database Engine.you are also free to change to the Workstation Components from Add/Remove Programs in the Control Panel.

To install a new component,browse or enter the location of the setup.exe file and click OK. perform system checks and launch the installation wizard.If warnings or errors arefound at this point you may need to quit the installation, resolve the issues, and restart the installation from the start.Select Reporting Services from the listing of components available for installation or upgrading. you'll now be prompted for the account you wish to run Reporting Services under..At this point you've given all the data that the setup program needs to perform the installation on the existing Microsoft SQL Server 2005 instance.also able to configure Reporting Services at this time. completion of the install via use of the Reporting Services Configuration Tool can do in the same manner.
Reply With Quote
  #3  
Old 08-07-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: SQL 2008 Cluster Adding Analysis Services

Me too had same problem just like you mentioned and never succeeded in adding Analysis Services to the existing SQL instance.Finally i understood i better had to add Analysis Services as a separate named instance
Ultimately what worked was installing a second instance of SQL Server with Replication components on the same box, then going through Control Panel to change the default instance. then i was able to install the Replication components successfully.
Reply With Quote
  #4  
Old 08-07-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
Re: SQL 2008 Cluster Adding Analysis Services

Installing a clustered install of SQL is simple as far as my concern. but remember after you setuping the cluster you need to simply run through the SQL 2000 installer.so that it will recognize that clustering has been setup and will prompt you to set it up as a clustered install.
Reply With Quote
  #5  
Old 21-07-2009
Member
 
Join Date: Jul 2009
Posts: 1
Re: SQL 2008 Cluster Adding Analysis Services

It doesn't seem like anybody is actually reading your question. I'm having this exact issue trying to add SSAS to an existing clustered SQL 2008 instance, with the same error. Have you found a solution yet?
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "SQL 2008 Cluster Adding Analysis Services"
Thread Thread Starter Forum Replies Last Post
move a Vmware 2008 R2 fail over cluster to a stand a lone 2008 R2 server mservis Windows Server Help 1 16-08-2011 02:36 PM
Problem adding disks to a Windows 2003 Cluster Darkhelmet75 Windows Server Help 2 29-08-2008 09:27 PM
Windows 2008 cluster for SQL server 2005 cluster Roger Windows Server Help 2 21-05-2008 10:16 AM
Adding new physical disk resource to cluster ILYA Windows Server Help 5 24-10-2007 06:33 PM
Adding new physical disk resource to 2003 active/passive cluster kesm0724 Windows Server Help 3 02-05-2007 01:12 AM


All times are GMT +5.5. The time now is 08:18 PM.