Hello I am getting the following errors in my MPCONTROL.LOG file: Beginning periodic tasks.RetryWINSOperationIfNecessary: No need to retry. Returning.RetryDNSPublishingIfNecessary: No need to retry. Returning.Checking the current CLR Enabled configuration setting for the configured SQL Server hosting the database.Getting the CLR Enabled value from the configured SQL database.Attempting to connect to the configured SQL database.*** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.*** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.*** Failed to connect to the SQL ServerFailed to get connection to the configured SQL database.Failed to connect to the configured SQL database. Failed to get the current CLR Enabled configuration setting for the configured SQL Server hosting the database.Completed periodic tasks.Call to HttpSendRequestSync failed for port 82 with status code 500, text: Internal Server ErrorHttp test request failed, status code is 500, 'Internal Server Error'.Successfully performed Management Point availability check against local computer.Call to HttpSendRequestSync failed for port 82 with status code 500, text: Internal Server ErrorHttp test request failed, status code is 500, 'Internal Server Error'.STATMSG: ID=5436 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_MP_CONTROL_MANAGER" SYS=BCAPP2 SITE=BC1 PID=4492 TID=5304GMTDATE=Tue Apr 29 22:26:00.683 2008 ISTR0="500" ISTR1="Internal Server Error" ISTR2="" ISTR3="" ISTR4="" ISTR5=""ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0Successfully performed Management Point availability check against local computer. Call to HttpSendRequestSync failed for port 82 with status code 500, text: Internal Server Error Http test request failed, status code is 500, 'Internal Server Error'.Successfully performed Management Point availability check against local computer. Call to HttpSendRequestSync failed for port 82 with status code 500, text: Internal Server Error Http test request failed, status code is 500, 'Internal Server Error'. Successfully performed Management Point availability check against local computer. Call to HttpSendRequestSync failed for port 82 with status code 500, text: Internal Server Error Http test request failed, status code is 500, 'Internal Server Error'. Successfully performed Management Point availability check against local computer. Call to HttpSendRequestSync failed for port 82 with status code 500, text: Internal Server Error Http test request failed, status code is 500, 'Internal Server Error'. Successfully performed Management Point availability check against local computer Your help is greatly appreciated

Are your SQL server and management point installed on the same machine? It seems like a permission issue (SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.). Make sure that your SCCM service account (i.e. the computer account) is member of the local admins group on the sql box.

My apologizes. I didn't provide any information on the setup. Computer A: Windows 2003 with SP2, SCCM installed Computer B: Windows 2003 with SP2, MS SQL Server 2005. Computer A is a member of the local admins group on Computer B. Computer A:Event ID: 6700 Error Source: SMS_WSUS_SYNC_MANAGER SMS_WSUS_SYNC_MANAGER on computerComputerA reported: SMS WSUS Sync Manager error. Message: Failed to connect to site source. CSiteSource error: 2. Source: CWSyncMgr:rocessSiteNotifications. The operating system reported error 2147500037: Unspecified error Event ID: 5436 Error Source: SMS_MP_CONTROL_MANAGER SMS_MP_CONTROL_MANAGER on computer BCAPP2 reported: MP Control Manager detected management point is not responding to HTTP requests. The HTTP status code and text is 500, Internal Server Error. 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 SMS 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. Possible cause: Internet Information Services (IIS) isn't configured to listen on the ports over which SMS is configured to communicate. Solution: Verify that the designated Web Site is configured to use the same ports which SMS 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. Possible cause: The SMS ISAPI Application Identity does not have the requisite logon privileges. Solution: Verify that the account that the SMS ISAPI is configured to run under has not been denied batch logon rights through group policy. For more information, refer to Microsoft Knowledge Base article 838891. Computer B: Event ID: 18456 Source: MSSQLSERVER Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: ComputerA]

Has the firewall been configured for these roles?

Windows firewall is turned OFF on both servers and all traffic between the 2 servers is confined within in the LAN and domain.

Hi, Please verify that TCP/IP is enabled within SQL server: SQL Server Configuration Manager / SQL Server 2005 Network Configuration / Protocols for MSSQLSERVER / TCP/IP and "Enable." Regards, Jannes Alink

Yes, this is indeed enabled. As well as Named Pipes. Any other ideas?

Hi, Can you check that the security settings are set to Anonymous Access instead of Windows Authentication on the virtual directory SMS_MP in IIS? Regards, Jannes Alink

Hi Jannes Yes, this was set to Anonymous Access.

Is the SPN set? http://technet.microsoft.com/en-us/library/bb735885.aspx

Any luck with this one as I am experiencing the same issue Have done setspn mssql/server:1433 DOMAIN\serviceaccount Still to no avail

I re-created the database connections between the SCCM server and my SQL server. This solved the problem for me as I had changed the password and it was using a domain account. I hope that helps you.

Could you provide more detail. What is involved in resetting the database connections between a sql server and sccm server(s). Is this an ODBC thing? I'll search that phrase, but if you could provide more info, I would appreciate it. Thanks, Michael

Hi Michael In my particular setup I have SCCM installed on one server and MS SQL installed on a separate server. I had to create an ODBC connection (System DSN) from SCCM to the SQL server, which is obviously needed. As well, I had to enable the protocol to be used on the SQL server. For testing I enabled both TCP/IP and Name Pipes. Hope that helps.

How do you re-establish conncetions between the SCCM site and SQL database if they are on the same machine.

I am running into this issue. Out SQL database resides in another location. I've verified anonymous access as well as SPN. I've gone as far as deleting the ODBC and re-creating it. We are seeing some SQL connections from the server but still are receiving errors in regards to ANONYMOUS LOGON.Any help would be GREATLY appreciated.

Jason,You might be better off creating a new thread referring to this one. Anyway please see if any of these links helps you with your issue.http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/764e658a-8619-4079-9227-4c1516af388a/http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/b62bde6a-7cf9-443f-b0a0-827dcfa52be0/http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/01fee6c5-3c7d-4029-83e6-a72295c2dbd6/http://support.microsoft.com/kb/839569In short you can add anonymous login to the SQL server, although it is not best practice.

Sorry for replying so late on an older thread, but I see there's not yet an answer marked.I was able to resolve this issue by configuring the IIS properties of the SMS_MP virtual directory to NOT require SSL.Steps for IIS 6http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/485ec9b6-d768-4d43-a2b4-ddcec0eddbf8Steps for IIS 7http://www.jppinto.com/index.php/2009/04/automatically-redirect-http-requests-to-https-iis-7/

I Know this Issue, you have only to change the application pool in the IIs for MP from local service to your sccm admin account