Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
SCSM 2010 and SQL Cluster

Answered SCSM 2010 and SQL Cluster

  • Tuesday, May 04, 2010 8:40 AM
     
     
    Sign In to Vote
    0

    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?

     

All Replies

  • Tuesday, May 04, 2010 9:17 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    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?

    //Anders

     
  • Tuesday, May 04, 2010 9:25 AM
     
     
    Sign In to Vote
    0

    Same Error.

    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
     
     
    Sign In to Vote
    0

    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 System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()

       at Microsoft.SystemCenter.Essentials.SetupFramework.HelperClasses.SetupValidationHelpers.GetSqlInstanceList(String sqlServerName)



    We did not used the default instance name !!!

     

     
  • Tuesday, May 04, 2010 12:13 PM
    Moderator
     
     
    Sign In to Vote
    0

    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?

    //Anders

     
  • Tuesday, May 04, 2010 12:27 PM
     
     
    Sign In to Vote
    0

    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$)

    Servername: CLSSQLI01

    Realservername (Clusternodes): DEUDUSSQL05 / DEUDUSSQL06 (both 2008 R2 Ent)

    InstanceName: CLSSQLI01 (no other instances - same as Servername)

     
  • Thursday, May 06, 2010 6:49 AM
     
     Answered
    Sign In to Vote
    0

    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...

    Done!

     

    Fixed it

     

    • Marked As Answer by Bechtle AG Thursday, May 06, 2010 6:49 AM
    •