none
SCCM Management Point and SQL Error 5436 and 5420 RRS feed

  • Question

  • Hi,

    I have a similar issue to the following thread

    http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/f9721f32-a5ef-4cec-934c-789d03a0e254/?ffpr=0

    Snapshot of mpcontrol.log:


    Attempting to register the SQL connection type for the configured SQL database.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:51:12 PM    3600 (0x0E10)
    Registered connection type for SQL Server 'SQLserver' and database 'SMS_PRD'.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:51:12 PM    3600 (0x0E10)
    MPStart(): RegisterSqlDatabaseConnectionType() returned 0x0    SMS_MP_CONTROL_MANAGER    6/02/2009 3:51:12 PM    3600 (0x0E10)
    Checking the current CLR Enabled configuration setting for the configured SQL Server hosting the database.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:51:12 PM    3600 (0x0E10)
    Getting the CLR Enabled value from the configured SQL database.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:51:12 PM    3600 (0x0E10)
    Attempting to connect to the configured SQL database.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:51:12 PM    3600 (0x0E10)
    *** [08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    *** [01000][233][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    *** Failed to connect to the SQL Server.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    Failed to get connection to the configured SQL database.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    Failed to connect to the configured SQL database.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    Failed to get the current CLR Enabled configuration setting for the configured SQL Server hosting the database.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    MPStart(): CheckSqlDatabaseClrEnabled() returned 0x800720d9    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    Waiting up to 300 seconds for the SMS Agent Host service to be running.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    Stopped waiting for the SMS Agent Host service to be running; error = 0x0.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    MPStart(): WaitOnSmsAgentHostRunning() returned 0x0    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    MPStart(): CreateThread() succeeded with id 0x1f34.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    SMS_MP_CONTROL_MANAGER successfully STARTED.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    ********************************************************************************    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    3600 (0x0E10)
    Configuration and Availability Monitor thread started.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    7988 (0x1F34)
    Initialized 'SMS Server Availability' performance instance => SMS Management Point.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    7988 (0x1F34)
    Received an MP registry key change notification.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    7988 (0x1F34)
    CMPControlManager::GetDnsServiceName(): DNS publishing is not enabled.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    7988 (0x1F34)
    Successfully handled registry changes.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    7988 (0x1F34)
    Received an MP registry key change notification.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    7988 (0x1F34)
    CMPControlManager::GetDnsServiceName(): DNS publishing is not enabled.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    7988 (0x1F34)
    Successfully handled registry changes.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:56:12 PM    7988 (0x1F34)
    Availability check in progress.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:57:12 PM    7988 (0x1F34)
    Availability check in progress.    SMS_MP_CONTROL_MANAGER    6/02/2009 3:57:42 PM    7988 (0x1F34)
    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error    SMS_MP_CONTROL_MANAGER    6/02/2009 3:57:43 PM    7988 (0x1F34)



    The error is SQL server does not exist or access denied. What I have checked:
    1. The SQLserver that is listed is the correct SQL server.
    2. The MP server is a local admin of the SQL server
    3. The MP server has the smsdbrole_MP in the SMS_PRD database on the SQL server
    4. I have corrected the ODBC info to point to the correct SQL server (as per the thread I linked above)
    Thank you in advance for your assistance.

    Friday, February 6, 2009 5:13 AM

Answers

  • waonline said:

    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error    SMS_MP_CONTROL_MANAGER    6/02/2009 3:57:43 PM    7988 (0x1F34)


    Hi,

    Besides the error you marked bold also take a look at the error I quoted. Can you please verify the health of the MP as well, for throubleshooting  the MP click the following link which provides you with the information:
    http://technet.microsoft.com/en-us/library/bb932118.aspx

    Also check the following logs:
    mpcontrol.log
    MP_GetAuth.log


    Regards, Jannes Alink | Please mark posts as Answered if appropriate.
    • Marked as answer by waonline Tuesday, February 10, 2009 11:09 PM
    Friday, February 6, 2009 8:00 AM

All replies

  • waonline said:

    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error    SMS_MP_CONTROL_MANAGER    6/02/2009 3:57:43 PM    7988 (0x1F34)


    Hi,

    Besides the error you marked bold also take a look at the error I quoted. Can you please verify the health of the MP as well, for throubleshooting  the MP click the following link which provides you with the information:
    http://technet.microsoft.com/en-us/library/bb932118.aspx

    Also check the following logs:
    mpcontrol.log
    MP_GetAuth.log


    Regards, Jannes Alink | Please mark posts as Answered if appropriate.
    • Marked as answer by waonline Tuesday, February 10, 2009 11:09 PM
    Friday, February 6, 2009 8:00 AM
  • Is the SQL server local or remote? Do you see any authentication errors in SQL server logs (-> SPN issue)?
    Friday, February 6, 2009 9:12 AM
    Moderator
  • To Jannes:

    Doing this "http://<ServerName>/sms_mp/.sms_aut?mplist" resulted in the following being displayed:

    This XML file does not appear to have any style information associated with it. The document tree is shown below.
         

    <HTML>

    <HEAD>
    <TITLE>ERROR</TITLE>
    </HEAD>
    <BODY>500 Internal Server Error</BODY>
    </HTML>

    Where as this link "http://<ServerName>/sms_mp/.sms_aut?mpcert" resulted in the following being displayed:

    This XML file does not appear to have any style information associated with it. The document tree is shown below.
         

    <MPCertificate>

    <Certificate>
    very long list of alpha-numerics
    </Certificate> Submit
    </MPCertificate>

    I assume the first result means there is a problem with the MP, the question is how do I fix it?

    Regards,

    WA
    Sunday, February 8, 2009 11:55 PM
  • To Torsten:

    The SQL server is remote. By SQL server logs, I assume you mean event viewer logs? I checked the SQL server, central site, and secondary site (MP) logs and did not find any authentication errors.

    Regarding the SPN, the SQL server services are running under Local System. Following a link found on one of the thread here, I found that the SPN is set only on the SQL server (through adsiedit and ldp search)

    Regards,

    WA
    Monday, February 9, 2009 12:06 AM
  • To Jannes:

    I just realised you asked me to check the MP_GetAuh.log. It contains the following errors:

    CMPDBConnection::Init(): IDBInitialize::Initialize() failed with 0x80004005

    AND

    MPDB ERROR - CONNECTION PARAMETERS
    SQL Server Name     : SQLSERVER
    SQL Database Name   : SMS_PRD
    Integrated Auth     : True

    MPDB ERROR - EXTENDED INFORMATION
    MPDB Method         : Init()
    MPDB Method HRESULT : 0x80004005
    Error Description   : [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
    OLEDB IID           : {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}
    ProgID              : Microsoft OLE DB Provider for SQL Server

    MPDB ERROR - INFORMATION FROM DRIVER
    Native Error no.  : 17
    Error State       : 1
    Class (Severity)  : 16

    Google - ing the first error led me to several links that I might try and follow to see if it will resolve the issue.

    Regards,

    WA

    Monday, February 9, 2009 1:57 AM
  • waonline said:

    The SQL server is remote. By SQL server logs, I assume you mean event viewer logs? I checked the SQL server, central site, and secondary site (MP) logs and did not find any authentication errors.


    It's in SQL Management Studio: Management -> SQL Server Logs (but only if SQL server is configured to log failed logins: properties of SQL server -> Security).
    Monday, February 9, 2009 7:00 AM
    Moderator
  • Issue is now resolved, I did not realise that named pipes is a requirement for the SQL server. This link helped me resolve the issue (by enabling named pipes for the SQL server)

    http://support.microsoft.com/kb/195566

    The errors are no longer showing and both mpcontrol and mpgetauth log files are happy.

    To Torsten:

    I checked the SQL log files and there are failed logins, most notably is the sccm central/primary site. I'll look into this a bit more and if it remains an issue I'll open another thread.

    Thank you.


    ps: since this is my first post for a thread, I have a stupid question. I have marked Jannes's post as helpful since it lead me to the resolution. Should I mark his post as the answer or should I mark this post as the answer?

    Again thank you Jannes and Torsten for your assistance.

    Regards,

    WA
    Tuesday, February 10, 2009 12:37 AM
  • waonline said:

    Should I mark his post as the answer or should I mark this post as the answer?


    You should mark his post as the answer.
    Tuesday, February 10, 2009 7:48 AM
    Moderator