Tuesday, May 04, 2010 8:40 AM
I want to use a SQL Cluster (2008 SP1) as DB Server, but the SCSM setup does not accept the virtual Server name.
Setup says: "SQL Server 2008 SP1 was not found" and i can not select the instance name
Is it possible to use a SQL Cluster for DB hosting?
Tuesday, May 04, 2010 9:17 AMModerator
We are using a SQL cluster to host our SCSM databases, so it should be possible. If you enter the physical machines (nodes) as the SQL server in the setup, does it give you an error aswell?
Tuesday, May 04, 2010 9:25 AM
Installed is SQL 2008 Ent Sp1 CU7 (10.00.2766)
There is no problem with other DBs on the Cluster (SCCM / Report Server etc)
Tuesday, May 04, 2010 10:30 AM
Found this in the log
12:28:52:Collecting SQL instances on server CLSSQLI01
12:28:52:Connecting to SQL server 2008 On CLSSQLI01.de.eu.dom.com
12:28:52:Error:GetSqlInstanceList(), Exception Type: System.Management.ManagementException, Exception Message: Invalid class
12:28:52:StackTrace: at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at Microsoft.SystemCenter.Essentials.SetupFramework.HelperClasses.SetupValidationHelpers.GetSqlInstanceList(String sqlServerName)
We did not used the default instance name !!!
Tuesday, May 04, 2010 12:13 PMModerator
So when enumerating the instances, it fails... What are the names of all instances on that SQL cluster? Are there any instances with special characters or something in the name? Is the local firewall turned off or exceptions made?
Tuesday, May 04, 2010 12:27 PM
Firewall is open on these ports (other services are already running against the cluster / remote admin is also working)
Also UNC to the clusterstorge is possible (like CLSSQLI01\P$)
Realservername (Clusternodes): DEUDUSSQL05 / DEUDUSSQL06 (both 2008 R2 Ent)
InstanceName: CLSSQLI01 (no other instances - same as Servername)
Thursday, May 06, 2010 6:49 AM
found the problem
WMI in the Cluster Nodes were not correct:
C:\Program Files (x86)\Microsoft SQL Server\100\Shared>mofcomp sqlmgmproviderxpsp2up.mof
Microsoft (R) MOF Compiler Version 6.1.7600.16385
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: sqlmgmproviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository...
- Marked As Answer by Bechtle AG Thursday, May 06, 2010 6:49 AM