SOLVED Management point encountered an error when connecting to SQL Server

[Israel Chavez]

So cam this morning and noticed that ccmservice on the server was stopped. I went ahead and looked and the windows logs and I have multiple errors. Once I start the service, everything "seems" to go back to normal but I still have issues installing the sccm client on new computer.

Thanks,


--------
On 3/28/2016 8:23:22 AM, component SMS_AWEBSVC_CONTROL_MANAGER on computer EPWU-SCCM.epwu.org reported: Application Web Service Control Manager detected AWEBSVC is not responding to HTTP requests. The http status code and text is 401, Unauthorized.

Possible cause: Internet Information Services (IIS) isn't configured to listen on the ports over which AWEBSVC is configured to communicate.
Solution: Verify that the designated Web Site is configured to use the same ports which AWEBSVC is configured to use.

Possible cause: The designated Web Site is disabled in IIS.
Solution: Verify that the designated Web Site is enabled, and functioning properly.
----------
On 3/28/2016 7:58:30 AM, component SMS_MP_CONTROL_MANAGER on computer EPWU-SCCM.epwu.org reported: MP Control Manager detected management point is not responding to HTTP requests. The HTTP status code and text is 404, Not Found.

Possible cause: Management point encountered an error when connecting to SQL Server.
Solution: Verify that the SQL Server is properly configured to allow Management Point access. Verify that management point computer account or the Management Point Database Connection Account is a member of Management Point Role (msdbrole_MP) in the SQL Server database.

Possible cause: The SQL Server Service Principal Names (SPNs) are not registered correctly in Active Directory
Solution: Ensure SQL Server SPNs are correctly registered. Review Q829868.

 

[Prajwal Desai]

Access the below link on the server where you installed the application catalog and let me know what is the result. (replace localhost with server name)
http://localhost/CMApplicationCatalogSvc/applicationofferService.svc

 

[Israel Chavez]

I get nothing! Page can't be displayed

 

[Prajwal Desai]

okay, my guess is if you uninstall and re-install IIS it should fix the issue. Can you give a try ?.

 

[Israel Chavez]

Ok, will try that. Hopefully this works, if not then will have to start from scratch again!!

 

[Israel Chavez]

---> Unable to connect to WMI (root\ccm) on remote machine "810-SCCM", error = 0x8004100e. SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:56 AM 2364 (0x093C)
---> Creating \ VerifyingCopying existence of destination directory \\810-SCCM\admin$\ccmsetup. SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:56 AM 2364 (0x093C)
---> Copying client files to \\810-SCCM\admin$\ccmsetup. SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:56 AM 2364 (0x093C)
---> Copying file "C:\Program Files\Microsoft Configuration Manager\bin\I386\MobileClient.tcf" to "MobileClient.tcf" SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:56 AM 2364 (0x093C)
---> Copying file "C:\Program Files\Microsoft Configuration Manager\bin\I386\ccmsetup.exe" to "ccmsetup.exe" SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:56 AM 2364 (0x093C)
---> Updated service "ccmsetup" on machine "810-SCCM". SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:56 AM 2364 (0x093C)
---> Started service "ccmsetup" on machine "810-SCCM". SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:57 AM 2364 (0x093C)
---> Deleting SMS Client Install Lock File '\\810-SCCM\admin$\SMSClientInstall.EPW' SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:57 AM 2364 (0x093C)
Execute query exec [sp_CP_SetLastErrorCode] 2097153157, 0 SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:57 AM 2364 (0x093C)
---> Completed request "2097153157", machine name "810-SCCM". SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:57 AM 2364 (0x093C)
Deleted request "2097153157", machine name "810-SCCM" SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:57 AM 2364 (0x093C)
Execute query exec [sp_CP_SetPushRequestMachineStatus] 2097153157, 4 SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:57 AM 2364 (0x093C)
Execute query exec [sp_CP_SetLatest] 2097153157, N'03/29/2016 16:31:57', 13 SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:57 AM 2364 (0x093C)
<======End request: "2097153157", machine name: "810-SCCM". SMS_CLIENT_CONFIG_MANAGER 3/29/2016 10:31:57 AM 2364 (0x093C)

 

[Israel Chavez]

I had to redo the whole server and now it is working. Go figures. Should have done that a long time ago1

 

[Prajwal Desai]

Thank you. Marking the thread as Solved.