Installing SQL 2005 Analysis failover cluster on windows 2008 Failover cluster

• Ali-1044608

  SSC Rookie

  Points: 35

  More actions

  March 22, 2009 at 2:11 am

  #155453

  Hi.

  I have installed an sql 2005 Failover cluster on windows 2008 Failover cluster.I have some queries on it.

  I want to install sql analysis failover cluster on my sql 2005 failover cluster which i didn,t select during my initial setup of sql 2005 failover cluster.Is there any pre-requisities i have to follow before installing sql 2005 analysis failover cluster on my exisitng sql 2005 failover cluster.

  i have installed sql 2005 failover cluster with WIndows authentication.I want to change it to mixed authentication with the SA Account.Can i do it with sql studio managment.Where can i change the windows authentication to mixed mode.

  Apprecite your help

  Regards

  Ali

• Mohit K. Gupta

  SSChampion

  Points: 12130

  More actions

  March 22, 2009 at 4:18 pm

  #964185

  For Analysis Server have a look at http://support.microsoft.com/default.aspx/kb/910230.

  For other question you can change your security settings from SSMS without issues.

  Thanks.

  Mohit.

  [font="Arial"]---

  Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
  Microsoft FTE - SQL Server PFE

  * Some time its the search that counts, not the finding...
  * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

  How to ask for help .. Read Best Practices here[/url].

• Ali-1044608

  SSC Rookie

  Points: 35

  More actions

  March 23, 2009 at 1:42 am

  #964269

  Hi Mohit.

  Thanks for the article.I have a small doubt on this MS KB Article.SQL 2005 Analysis services on exisitng failover cluster i can install using the splash.exe as expilained in the article rather than installing analysis service using command prompt.

  Regrads,

  Ali

• Mohit K. Gupta

  SSChampion

  Points: 12130

  More actions

  March 23, 2009 at 11:14 am

  #964614

  I am not quite understanding what you mean ...

  Are you saying you prefer to install it using Command Prompt instead of the installer interface SQL comes with?

  Mohit.

  [font="Arial"]---

  Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
  Microsoft FTE - SQL Server PFE

  * Some time its the search that counts, not the finding...
  * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

  How to ask for help .. Read Best Practices here[/url].

• Ali-1044608

  SSC Rookie

  Points: 35

  More actions

  March 24, 2009 at 1:41 am

  #964997

  Hi Mohit.

  I want to install the sql failover analysis services on the exsitng sql failover cluster using the setup.exe that comes with sql server installer Not the command line.

  The normal way of installing sql 2005 using setup.exe.

  Regards,

  Ali

• Mohit K. Gupta

  SSChampion

  Points: 12130

  More actions

  March 24, 2009 at 10:46 pm

  #965783

  This article (http://support.microsoft.com/default.aspx/kb/910230) is showing you how to do it using GUI not command line. HTA is a HTML file that can be executed; thats all. After you select the components to install it will launch that setup.exe

  Thanks.

  [font="Arial"]---

  Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
  Microsoft FTE - SQL Server PFE

  * Some time its the search that counts, not the finding...
  * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

  How to ask for help .. Read Best Practices here[/url].