locked
The ConfigMgr console could not connect to the ConfigMgr site database. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I did a transfer of the site database using the procedure http://technet.microsoft.com/en-us/library/bb680707.aspx

    It all seemed succesfull but then I can no longer connect to the database giving this failure

    The ConfigMgr console could not connect to the ConfigMgr site database. Verify that this computer has network connectivity to the SMS Provider computer and that your user account has Remote Activation permissions on both the ConfigMgr site server and SMS Provider computers. For more information, see "How to Configure DCOM Permissions for Configuration Manager Console Connections" in ConfigMgr Help.

    Wednesday, August 18, 2010 12:47 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have found the problem is due to orphaned SQL logins..

    When you transfer the site database new SQL logins are created.. the login for the primary site server had no user  mapping to the sccm database..

    I have configured this using the old database as the example...

    This can be considered a bug in the transfer of sql using sccm setup..

    • Proposed as answer by Sherry Kissinger Wednesday, August 18, 2010 2:01 PM
    • Marked as answer by LA1976 Wednesday, August 18, 2010 2:30 PM
    Wednesday, August 18, 2010 1:34 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I see this error in the site databas server application log

    Login failed for user 'domain\Siteserver$'. Reason: Failed to open the explicitly specified database.

    Wednesday, August 18, 2010 1:05 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I have found the problem is due to orphaned SQL logins..

    When you transfer the site database new SQL logins are created.. the login for the primary site server had no user  mapping to the sccm database..

    I have configured this using the old database as the example...

    This can be considered a bug in the transfer of sql using sccm setup..

    • Proposed as answer by Sherry Kissinger Wednesday, August 18, 2010 2:01 PM
    • Marked as answer by LA1976 Wednesday, August 18, 2010 2:30 PM
    Wednesday, August 18, 2010 1:34 PM