Hi I have SCCM 2007 sp2 servers on 64bit O/S. I have a sccm primary which has an sql 2005 sp3 database using and instance with the sql service account running as a domain user. The Management point is on a different server. The servers are all in the same domain. When I run the MPList test it fails with HTTP 500 error. The MP troubleshooter says Failed to retrieve the content in HTTP://<MPservername>:80/SMS_MP/.SMS_AUT?MPLIST. The remote server returned an eror (500) internal server Error. I have added the spn for the account which is running the the sql service i.e. setspn -A MSSQLSvc/<Primary server which has db>\<Instance Name>:1433 <domain\<username> The same has been done for the <primary server FQDN> This looks right when I do a setspn -L, but I'm not sure how I would go about testing the connection using the spn from the MP to the primary. On the Mpcontrol.log on the Management point, the info is much the same as the mp troubleshooter: Beginning periodic tasks. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) RetryWINSOperationIfNecessary: No need to retry. Returning. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) RetryDNSPublishingIfNecessary: No need to retry. Returning. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) Checking the current CLR Enabled configuration setting for the configured SQL Server hosting the database. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) Getting the CLR Enabled value from the configured SQL database. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) Attempting to connect to the configured SQL database. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) *** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) *** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) *** Failed to connect to the SQL Server. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) Failed to get connection to the configured SQL database. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) Failed to connect to the configured SQL database. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) Failed to get the current CLR Enabled configuration setting for the configured SQL Server hosting the database. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) Completed periodic tasks. SMS_MP_CONTROL_MANAGER 08/07/2011 16:25:39 4060 (0x0FDC) Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error SMS_MP_CONTROL_MANAGER 08/07/2011 16:26:08 4060 (0x0FDC) Http test request failed, status code is 500, 'Internal Server Error'. SMS_MP_CONTROL_MANAGER 08/07/2011 16:26:08 4060 (0x0FDC) Successfully performed Management Point availability check against local computer. SMS_MP_CONTROL_MANAGER 08/07/2011 16:26:08 4060 (0x0FDC) Call to HttpSendRequestSync failed for port 80 with an error code. SMS_MP_CONTROL_MANAGER 08/07/2011 16:26:08 4060 (0x0FDC) Http test request failed, error code is 12152. SMS_MP_CONTROL_MANAGER 08/07/2011 16:26:08 4060 (0x0FDC) It does look like a connection problem because it says nt authority\anonymous logon, but I guess this should be the sql server account The management point server is in the database role, smsdbrole_mp group Any help is much appreciated, ThanksJaz

Did you use the FQDN in the setspn command? Is the instance hosting the ConfigMgr DB actually listening on port 1433? Also, the setspn command-line you used above is incorrect: you can't specify both the instance name and the port number (it's one or the other). Also, specifying the instance name is only valid for SQL Server 2008 and SQL Server 2008 R2. http://msdn.microsoft.com/en-us/library/ms191153.aspxJason | http://myitforum.com/cs2/blogs/jsandys | Twitter @JasonSandys