Event 5436 - Mangement Point not Accessible

I have a new 5436 issue related to the "500 - Internal Server Error."  This was not resolved with an un-install and re-install.  Here is our setup:

- Remote SQL 2008 failover cluster.

     -SCCM computer account is a member of the local administrator's group on each SQL node.

     -Dedicated SQL instance using a custom static port (SCCM would not even install until we changed the port from dynamic to static)

- SQL SPN registered to SQLServer:customport# domain\SQLserviceaccount (not domain\SCCMaccount)

- SQL SPN registered to SQLServer.domain.com:customport# domain\SQLserviceaccount (not domain\SCCMaccount)

- mpcontrol.log shows:

Attempting to register the SQL connection type for the configured SQL database.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.618+240><thread=5424 (0x1530)>
Registered connection type for SQL Server 'RSQLServer.domain.com' and database 'SCCM\CM_ROC'.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.618+240><thread=5424 (0x1530)>
MPStart(): RegisterSqlDatabaseConnectionType() returned 0x0  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.618+240><thread=5424 (0x1530)>
Checking the current CLR Enabled configuration setting for the configured SQL Server hosting the database.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.618+240><thread=5424 (0x1530)>
Getting the CLR Enabled value from the configured SQL database.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.618+240><thread=5424 (0x1530)>
Attempting to connect to the configured SQL database.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.618+240><thread=5424 (0x1530)>
Successfully connected to the configured SQL database.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.644+240><thread=5424 (0x1530)>
The configured SQL database has the CLR Enabled configuration setting set to 'On'.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.649+240><thread=5424 (0x1530)>

Any help is appreciated here.

September 19th, 2012 4:11pm

That part of the logfile does not contain any errors ...
Free Windows Admin Tool Kit Click here and download it now
September 19th, 2012 4:16pm

Yes.  It appears that we have a successful SQL connection, but I have no idea where else to look for the problem.  I have this in mpcontrol.log repeatedly but it isn't helpful to me:

Configuration and Availability Monitor thread started.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.656+240><thread=5500 (0x157C)>
Initialized 'SMS Server Availability' performance instance => SMS Management Point.~  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:15.669+240><thread=5500 (0x157C)>
SSL is not enabled.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:45.915+240><thread=5500 (0x157C)>
Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:52.482+240><thread=5500 (0x157C)>
~Sent summary record of SMS Management Point on ["Display=\\SCCMServer.domain.com\"]MSWNET:["SMS_SITE=ROC"]\\SCCMServer.domain.com\ to \\SCCMServer.domain.COM\SMS_ROC\inboxes\SiteStat.Box\01yz5dsm.SUM, Availability 1, 133062652 KB total disk space , 100251412 KB free disk space, installation state 0.  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:52.501+240><thread=5500 (0x157C)>
Successfully performed Management Point availability check against local computer.~  $$<SMS_MP_CONTROL_MANAGER><09-18-2012 17:17:52.502+240><thread=5500 (0x157C)>

Where else could the problem be?

September 19th, 2012 4:43pm

MPSetup.log contents posted here.  The installation was successful.

<09-18-2012 17:16:11> ====================================================================
<09-18-2012 17:16:11> SMSMP Setup Started....
<09-18-2012 17:16:11> Parameters: C:\Program Files\Microsoft Configuration Manager\bin\x64\rolesetup.exe /install /siteserver:ROC-ITB SMSMP 0
<09-18-2012 17:16:11> Installing Pre Reqs for SMSMP
<09-18-2012 17:16:11>         ======== Installing Pre Reqs for Role SMSMP ========
<09-18-2012 17:16:11> Found 2 Pre Reqs for Role SMSMP
<09-18-2012 17:16:11> Pre Req MSXML60 found.
<09-18-2012 17:16:11> No versions of MSXML60 are installed.  Would install new MSXML60.
<09-18-2012 17:16:11> Enabling MSI logging.  msxml6_x64.msi will log to C:\Program Files\Microsoft Configuration Manager\logs\msxml6_x64MSI.log
<09-18-2012 17:16:11> Installing C:\Program Files\Microsoft Configuration Manager\bin\x64\00000409\msxml6_x64.msi
<09-18-2012 17:16:13> msxml6_x64.msi exited with return code: 0
<09-18-2012 17:16:13> msxml6_x64.msi Installation was successful.
<09-18-2012 17:16:13> Pre Req SqlNativeClient found.
<09-18-2012 17:16:13> SqlNativeClient already installed (Product Code: {C79A7EAB-9D6F-4072-8A6D-F8F54957CD93}). Would not install again.
<09-18-2012 17:16:13> Pre Req SqlNativeClient is already installed. Skipping it.
<09-18-2012 17:16:13>         ======== Completed Installation of Pre Reqs for Role SMSMP ========
<09-18-2012 17:16:13> Installing the SMSMP
<09-18-2012 17:16:13> Passed OS version check.
<09-18-2012 17:16:13> IIS Service is installed.
<09-18-2012 17:16:13> No versions of SMSMP are installed.  Installing new SMSMP.
<09-18-2012 17:16:13> Enabling MSI logging.  mp.msi will log to C:\Program Files\Microsoft Configuration Manager\logs\mpMSI.log
<09-18-2012 17:16:13> Installing C:\Program Files\Microsoft Configuration Manager\bin\x64\mp.msi CCMINSTALLDIR="C:\Program Files\SMS_CCM" CCMSERVERDATAROOT="C:\Program Files\Microsoft Configuration Manager" USESMSPORTS=TRUE SMSPORTS=80 USESMSSSLPORTS=TRUE SMSSSLPORTS=443 USESMSSSL=TRUE SMSSSLSTATE=0 CCMENABLELOGGING=TRUE CCMLOGLEVEL=1 CCMLOGMAXSIZE=1000000 CCMLOGMAXHISTORY=1
<09-18-2012 17:17:08> mp.msi exited with return code: 0
<09-18-2012 17:17:08> Installation was successful.
<09-18-2012 17:17:08> ~RoleSetup().

Free Windows Admin Tool Kit Click here and download it now
September 21st, 2012 5:47pm

This thread - http://social.technet.microsoft.com/Forums/en/configmgrgeneral/thread/29841244-c597-4b3f-909e-ec7af70c57be - pointed me to this link - http://technet.microsoft.com/en-us/library/cc431377.aspx to configure WebDAV appropriately.  I have done so.

This thread - http://social.technet.microsoft.com/Forums/hu/configmgrsetup/thread/f9721f32-a5ef-4cec-934c-789d03a0e254 - mentioned checking the ODBC connection.  The "Test Connection" button succeeded.

September 21st, 2012 5:50pm

According to this thread - http://social.technet.microsoft.com/forums/en-us/configmgrsetup/thread/807F6A1C-970B-4991-848B-E4BCD91EEAF3 - I granted "Read" and "Read & Execute" permissions for the Everyone group on the \sms_mp file path.  There was no web.config file.

This thread - http://social.technet.microsoft.com/Forums/en-AU/configmgrgeneral/thread/29841244-c597-4b3f-909e-ec7af70c57be - mentions an MP Troubleshooter tool.  Is there an equivalent tool for SCCM 2012?

This thread - http://social.technet.microsoft.com/Forums/en/configmgrsetup/thread/f9721f32-a5ef-4cec-934c-789d03a0e254 - recommends checking that anonymous logon access is enabled for the \sms_mp virtual directory in IIS.  It is enabled.

Free Windows Admin Tool Kit Click here and download it now
September 21st, 2012 6:07pm

We have experienced connectivity issues when using a Cluster which was caused by the Native R2 client, replacing it with the 2008 native client resolved our issue. This may not help you though as all your logs seem fine, but I thought I would put it out there anyway. 
September 21st, 2012 7:45pm

Nobody's touching this with a 10-foot pole, are they?
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2012 6:33pm

First, does the install actually create the site database CM_ROC on the active node of your cluster?

Second, does the install create the IIS virtual directories on the primary?

October 3rd, 2012 1:44am

The database has been created and we do have the following virtual directories in IIS which should be related to SCCM:

/ccm_client

/ccm_incoming

/ccm_system

/ccm_system_windowsauth

/sms_dp_smspkg$

/sms_dp_smssig$

/sms_mp

/sms_mp_windowsauth

Free Windows Admin Tool Kit Click here and download it now
October 4th, 2012 3:16pm

Yes, I know this is an old post, but Im trying to clean them up. Did you solve this problem, if so what was the solution?

February 1st, 2015 8:21pm

Since no one has answer this post, I recommend opening  a support case with Microsoft Customer Support Services (CSS) as they can work with you to solve this problem.

Free Windows Admin Tool Kit Click here and download it now
June 27th, 2015 10:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics