Add Analysis Services to a clustered SQL Server 2008 instance
I have an existing multi-instance SQL 2008 cluster, and I'm trying to add Analysis Services to an existing instance. I start the installation, pick "Add features", configure SSAS, and then on the final pre-installation check, I fail the "Existing clustered or cluster-prepared instance" check. Of course I'd fail this check - I'm trying to add a feature to an existing clustered instance. Here's a picture of the error:
(source: trycatchfinally.net)
Has anybody successfully added a feature to a clustered instance in SQL 2008? I can't believe it can't be done - my alternative is to remove SQL from one node, try to add the feature again, hoping I don't fail this same check (though I probably will), and then re-add to the second node. This seems dangerous and unnecessary.
I found another person who had the same question, but the people answering it clearly aren't even reading the question, since they're mentioning how to cluster a server, and that he should use SQL 2000, so this is no help at all (though I'd love to point him here once it's answered: http://forums.techarena.in/software-development/1209984.htm
Take a look at the SQL Server 2008 Failover Clustering whitepaper.
Page 31 & 32
"Note: SQL Server 2008 does not support adding features to an existing failover cluster instance, so Analysis Services cannot be added to an existing instance of SQL Server. To share a resource group with an instance of SQL Server, you must choose to install Analysis Services during the initial installation of SQL Server."
- SSIS set result set from data flow to variable
- How to find which column is violating Constraints?
- Convert varchar into datetime in SQL Server
- How can I get the last 12 months from the current date PLUS extra days till 1st of the last month retrieved
- How does alter table switch work on SQL Server?
- Do clustered indexes have to be unique?
- How to find which OLE provider is available for SQL Server?
- Find Physical Location of Filegroup on SQL 2008 using TSQL
- SQL Server 2008 problem with Authentication
- INSERT INTO vs SELECT INTO
- Issue with bulk insert
- Conditional split based on array variable
- How to rollback or commit a transaction in SQL Server
- Using RegEx in SQL Server
- How to print VARCHAR(MAX) using Print Statement?
- An attempt to login using SQL authentication failed
- SQL Server Varbinary(max): select a subset of bytes from the varbinary field
- T-SQL - Projecting multiple records into one row for each key
- Pros & Cons of TRUNCATE vs DELETE FROM
- How to disconnect all users in sql server except sa?
- How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
- SQL Server add auto increment primary key to existing table
- Selecting all with a length of less than 8 characters, and not null, and not empty
- SQL date format conversion to MMDDYYYY
- How can I query how much time a SQL server database restore takes?
- To find the next work day
- Convert VARCHAR to SMALLDATETIME as part of UPDATE statement
- Put stored procedure result set into a table variable without specifying its schema
- Paging with Entity Framework 7 and SQL Server 2008
- Database design: Calculating the Account Balance