none
Проблема с MP RRS feed

  • Вопрос

  • Добрый день.

    Сталкнулся с такой ошибкой Management Point:

    MP находится на Secondary Site - подключаемся соответсвенно к базе Primary Site.

    Ошибка :

    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.

    В группу Site to Site машины добавлены, подключение к БД проходит.

    http://ServerName/SMS_MP/.sms_aut?MPcert - открывается

    http://ServerName/SMS_MP/.sms_aut?MPLIST - не открывается

    Ошибка в Troubleshooter:

    12 ноября 2012 г. 6:33

Ответы

  • >>Error Description   : [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.<<

    >>В группу Site to Site машины добавлены, <<

    Вы после добавления не ребутили?

    Также проверьте права этой вторички на SQL, попробуйте подключиться и посмотреть/выдать права по аналогии с другим secondary сайтом,

    Порты не заблокированы ?

    UDP порт 1434, если не ошибаюсь в документации про это не сказано.

    Также посмотрите http://www.danrichings.com/?p=149


    12 ноября 2012 г. 12:04
    Отвечающий

Все ответы

  • Добрый день,

    Дополнительно посмотрите mpcontrol.log на наличие ошибок SQL

    также посмотрите mp_getauth.log на вторичке

    12 ноября 2012 г. 7:29
    Отвечающий
  • В чем может быть причина, вроде бы все насроено верно. Есть идентичный Seconary Site - который работает корректно.

    http://ServerName/SMS_MP/.sms_aut?MPLIST - на нем открывается без проблем.

    mpcontrol.log :

    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:03:22.398 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Http test request failed, status code is 500, 'Internal Server Error'.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:03:22.398 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    STATMSG: ID=5436 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_MP_CONTROL_MANAGER" SYS=SecondaryServerName SITE=S38 PID=3556 TID=5560 GMTDATE=Mon Nov 12 07:03:22.398 2012 ISTR0="500" ISTR1="Internal Server Error" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:03:22.398 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Successfully performed Management Point availability check against local computer.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:03:22.398 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:08:23.897 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Http test request failed, status code is 500, 'Internal Server Error'.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:08:23.897 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Successfully performed Management Point availability check against local computer.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:08:23.897 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:13:23.134 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Http test request failed, status code is 500, 'Internal Server Error'.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:13:23.134 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Successfully performed Management Point availability check against local computer.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:13:23.134 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:18:24.166 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Http test request failed, status code is 500, 'Internal Server Error'.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:18:24.166 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Successfully performed Management Point availability check against local computer.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:18:24.166 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:23:23.793 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Http test request failed, status code is 500, 'Internal Server Error'.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:23:23.793 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Successfully performed Management Point availability check against local computer.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:23:23.793 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Beginning periodic tasks.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:24:48.438 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    RetryWINSOperationIfNecessary: No need to retry. Returning.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:24:48.438 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    RetryDNSPublishingIfNecessary: No need to retry. Returning.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:24:48.438 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Checking the current CLR Enabled configuration setting for the configured SQL Server hosting the database.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:24:48.438 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Getting the CLR Enabled value from the configured SQL database.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:24:48.438 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Attempting to connect to the configured SQL database.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:24:48.438 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:27:22.237 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Http test request failed, status code is 500, 'Internal Server Error'.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:27:22.237 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Successfully performed Management Point availability check against local computer.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:27:22.237 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    *** [08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:29:50.468 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    *** [01000][67][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:29:50.468 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    *** Failed to connect to the SQL Server.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:29:50.468 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Failed to get connection to the configured SQL database.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:29:50.468 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Failed to connect to the configured SQL database.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:29:50.468 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Failed to get the current CLR Enabled configuration setting for the configured SQL Server hosting the database.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:29:50.468 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Completed periodic tasks.  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:29:50.468 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:33:23.952 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Http test request failed, status code is 500, 'Internal Server Error'.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:33:23.952 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>
    Successfully performed Management Point availability check against local computer.~  $$<SMS_MP_CONTROL_MANAGER><Mon Nov 12 13:33:23.952 2012 N. Central Asia Standard Time><thread=5560 (0x15B8)>

    mp_getauth.log - соответственно ошибки подключения

    MPDB ERROR - CONNECTION PARAMETERS
    SQL Server Name     : ***\***

    SQL Database Name   : SMS_***
    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

    12 ноября 2012 г. 7:47
  • >>Error Description   : [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.<<

    >>В группу Site to Site машины добавлены, <<

    Вы после добавления не ребутили?

    Также проверьте права этой вторички на SQL, попробуйте подключиться и посмотреть/выдать права по аналогии с другим secondary сайтом,

    Порты не заблокированы ?

    UDP порт 1434, если не ошибаюсь в документации про это не сказано.

    Также посмотрите http://www.danrichings.com/?p=149


    12 ноября 2012 г. 12:04
    Отвечающий