How to Install SCCM 2007 with A Clustered SQL Server


In the past, there is no HA solution for SMS database, the only thing you can do is backup for any disaster. The good news is, for System Center Configuration Manager 2007 (SCCM 2007) now has an ability to support clustered SQL Server instance. Unfortunately, the documentation for how to install SCCM 2007 with clustered SQL Server is poor. Here is a walk through for how to install SCCM on clustered SQL server.

1. Install Windows 2003 Cluster

2. Install SQL 2000/2005 Cluster

3. By default, Windows will not register SQL Server virtual name in Active Directory, for successfully installing SCCM 2007 on Clustered SQL Server, you must register it. Go to step 4

4. Run setspn.exe (you can download it from Microsoft download center:http://www.microsoft.com/downloads/details.aspx?FamilyID=5fd831fd-ab77-46a3-9cfe-ff01d29e5c46&displaylang=en) utility as below:

setspn MSSQLSvc/SQLSERVER1:1433 

SQLSERVER1 is your SQL Server virtual name

setspn MSSQLSvc/SQLSERVER1.contoso.com:1433

SQLSERVER1.contoso.com is FQDN for SQL Server virtual name

5. Add computer account for installing SCCM 2007 to local administrators group on every SQL cluster node.

6. Add user account for installing SCCM 2007 to local administrators group on every SQL cluster node.

7. Restart computer for installing SCCM 2007, and logon with user account for setup

8. Launch SCCM 2007 installer, conduct a normal setup.

 

If you have any questions, please let me know.


Comments (5)

  1. tim@foolproof.net says:

    Excellent Post!  I was getting a Short Filename (8.3) error during the PreReq check.  Followed this procedure (specifically steps 5 & 6) and was able to successfully install.  Thank you for the information!

  2. dennisd567 says:

    Also Note; you MUST enable Kerberos on the Cluster or the SMS backups will not work

  3. friendm says:

    Hi,

    I am not that familar with SQL. I am trying to create a stand-alone test bench for runing SCCM 2007 R2. I have the install almost to the end of install when I get this message "You have indicated that SQL Server (Name) is version 2005 but setup has detected that it is actually version 520.1995460328" where the install stops. I know that I installed SQL 2005 sp3. Could you please tell me what I have done wrong? Or what I have to do to fix it? I have looked for information on this but still have not found amything. Thanks again.

  4. jcrueter says:

    Hi friendm,

    I just experienced the same behaviour while trying to install on SQL server 2008 R2: "You have indicated that SQL Server (Name) is version 2005 but setup has detected that it is actually version …". After Googling around for a while, and not having found a solution, I retried the setup and all of a sudden in worked. Beats me…