locked
Secondary Site Installation and Primary Site Database on SQL Cluster RRS feed

  • Question

  • Hello,

    Our infrastructure:

    • 1x SCCM 2012 SP1 CU1 - Stand alone primary site Server (MP / RSP / DP / SMS Provider)
    • 1x Remote Cluster SQL Database Server 2008 R2 SP2
    • Dedicated instance, fixed port ...

    All SCCM Clients using PMP in secondary site server got the following issue on SMS_CCM\Logs\ClientAuth.log

    And on every secondary site clients we got in CcmMessaging:

    It seems that our Secondary Site is not well configured.. we set a static port on our Primary site database instance...

    RCMctrl.log from secondary site server:

    • ERROR: Exception message: [Login failed for user 'EU\SecondarySiteServer$'.~~OLE DB provider "SQLNCLI11" for linked server "PrimaryDatabaseServer\SCCM" returned message "Invalid connection string attribute".]

    Same as..

    Any ideas ?


    Thursday, April 25, 2013 3:40 PM

Answers

  • We re-install the secondary site and everything is working fine now..

    And this time, login for the secondary site server has been created on primary site database...



    Thursday, April 25, 2013 6:51 PM