System Center Configuration Management with Remote SQL installations
So, for the ones that want to install System Center Configuration Management with a Remote SQL box...here are some things you HAVE to consider when installing Config Manager along with a Remote SQL server.
You will get to the following error:
Setup Fails to Install SMS Provider Components
When using the Configuration Manager Setup Wizard to install a sccmshortname primary site, setup may fail when attempting to install SMS Provider components and display an error dialog. When the SMS Provider installation error dialog is closed, the Configuration Manager Setup Wizard exits automatically. The ConfigMgrSetup.log file may also record an entry similar to:
<date time>CompileMOFFile: Failed to compile MOF <install dir\i386\smsRprt.mof, error -2147217407
Read - Jeff Gilbert's post (Nice seeing this post after discussing my issues during the install! Thanks Jeff!!)
Now...read it again!
There are a few things to note about how to determine what port an instance of SQL 2005 is running so you ensure getting the listening port correct. From your SQL 2005 box, open the SQL Server Configuration Manger and go to the SQL Server 2005 Network Configuration and find the instance you are wanting to run your SCCM Database under and then click on the TCP/IP for that instance. On the IP Address tab you will see the TCP Port for that instance. That is the value you want to run the
Setspn -A MSSQLSvc/<SQL Server name>:1433 <domain>\<user>
command under. Also, use the Domain User that the instance is running as...not the SCCM user.
I was told to run the command to the FQDN only for the server.
The other things I did to help was Open up AD for Users and computers and find the Domain Account that you used in the SetSPN command and go to the Delegation Tab. Change the items to Trust this user for Delegation to any server (Keberos only) and do the same for the Computer account on which SCCM is installed.
Once you do that...the setup should get passed the smsRrpt.mof section.