Sign in
Microsoft.com
 
System Center Configuration Manager TechCenter
 
 
 
System Center Configuration Manager TechCenter > System Center Configuration Manager Forums > Configuration Manager Setup/Deployment > SQL Cluster name not showing up in Site Systems
Ask a questionAsk a question
Search Forums:
 

AnswerSQL Cluster name not showing up in Site Systems

  • Tuesday, November 03, 2009 3:08 PMLucid Renegade Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I'm installing SCCM 2007 with the database on a remote SQL Server 2005 cluster.  After the install, I check Site Systems and both SQL nodes show up, but not the virtual cluster name.  My understanding is that that should be there as well.  The SCCM server computer account is a member of Administrators on both SQL nodes.  I think my SPNs are set right (obscured real names for security reasons):

    Registered ServicePrincipalNames for CN=SQLServerService,OU=MYOU,DC=my,DC=domain,DC=com:
            MSSQLSvc/SQLClusterName.my.domain.com
            MSSQLSvc/SQLClusterName
            MSSQLSvc/SQLClusterName:1433
            MSSQLSvc/SQLClusterName.my.domain.com:1433

    Running "select auth_scheme from sys.dm_exec_connections where session_id=@@spid" against the database returns KERBEROS, as it should. 

    I've rebooted the SCCM server, which didn't make a difference.  In the SMS_SITE_COMPONENT_MANAGER log, I'm seeing 1037, 1057 and 578 errors about not being able to access the two cluster nodes.

    Thanks
     

Answers

All Replies