Environment
Veritas Cluster Server
Microsoft Cluster Server
Microsoft SQL Server 200x
Situation
Error: 'System.Runtime.InteropServices.COMException (0x800437B6): [Microsoft][ODBC SQL Server Driver][SQL Server]The specified @server_name (<localhost\instancename>) does not exist.'
Cannot install using a non- Microsoft Cluster.
Resolution
Analysis Center supports only Microsoft Cluster Server (MSCS). At this time, Analysis Center does not have a workaround to support Veritas Cluster Server.
Analysis Center requires some components of Microsoft SQL Server and Microsoft Analysis Server that do not work on non-MSCS (Microsoft Cluster Server) clusters. SQL Server 200x has built-in support for MSCS so the installation detects MSCS automatically and configures SQL to run in a cluster. SQL Server 200x Failover Clustering is only supported on MSCS, which means Microsoft only supports SQL Server 200x problems can be reproduced in an MSCS environment.
Virtual Server Name Requirements
Analysis Center uses the SQL Virtual Server name to connect to the SQL cluster and registers the Virtual Server name as the name of the server. The local hostname of the node is not used as the SQL Name in a cluster install. Veritas Cluster Server uses a normal installation of SQL Server, using the local hostname, and requires that each client use a SQL Server alias to connect to the SQL Cluster, so SQL Server does not see a Virtual Server Name registered in SQL. When the Analysis Center install runs it queries SQL Server for all known instances of SQL Server using the SQL API. When you install Analysis Center on a Veritas Cluster Server, the SQL API only returns the local instances of SQL Server.
MSDTC Requirements
When SQL Server is installed on a cluster it automatically configures MSDTC for the cluster and for SQL Server support. Analysis Center requires a specific MSDTC configuration to function correctly.