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."
- Combine 2 SQL Statements
- How to get a list of tables with composite primary key in SQL Server?
- How to find all trigger associated with a table with SQL Server?
- SSRS Query execution failed for dataset
- SQL Server SELECT LAST N Rows
- Order by Specific id first then By rest
- SQL Server query to find all permissions/access for all users in a database
- Cannot access temporary tables from within a function
- Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
- How to create table using select query in SQL Server?
- Get the database name in which Stored Procedure exists
- Errors: "INSERT EXEC statement cannot be nested." and "Cannot use the ROLLBACK statement within an INSERT-EXEC statement." How to solve this?
- Set variable to NULL if not found in query statement
- T-SQL USE satetement in condition
- Get MAX value of a BIT column
- Is full text search suitable for searching people's names?
- The transaction log for the database is full
- SQL Server 2008 R2 DeadLock on query Notification (SqlDependency)
- Why use the INCLUDE clause when creating an index?
- Why am I getting Data provider or other service returned an E_FAIL status? SQL Native Client
- Import Excel Spreadsheet Data to an EXISTING sql table?
- Retrieving billions of rows from remote server?
- Combining (concatenating) date and time into a datetime
- SQL ignore part of WHERE if parameter is null
- Schema objects not visible in SQL Server Management Studio 2008
- Using RegEx in SQL Server
- How to convert number of minutes to hh:mm format in TSQL?
- Error 'the subreport could not be found at the specified location. Please verify that the subreport has been published and that the name is correct'
- Retrieving last record in each group from database - SQL Server 2005/2008
- How to get the name of a the student who got max marks in each subject?