Here is the error we are experiencing:
MPDB ERROR - CONNECTION PARAMERTERS
SQL Server Name : ms-air01-sc01.****.*****.****\CONFIGMGRSEC
SQL Database Name : CM_JF1
Intergrated Auh : True
MPDB ERROR - EXTENDED INFORMATION
MPDB Method : GetNextRow ()
MPDB Method HRESULTS : 0x80040401
Error Description : Null
OLEDB IID : Null
ProgID : Null
MPDB ERROR - INFORMATION FROM DRIVER
Null
=======================
SQL Express 2008 R2 is installed locally
Primary Site computer (and local Site Server comptuer) have Admin Privilidges on the Secondary Site.