Funzjonali Eżempju: BDC ADF li jgħaqqad lill database SQL ma 'id-utent inkorporat u password

4 tweġibiet

I needed to wire up MOSS to a SQL database via BDC. For testing/POC purposes, I wanted to embed the SQL account user id and password in the ADF. Starting with din it-template (http://msdn2.microsoft.com/en-us/library/ms564221.aspx), I maħluqa b 'ADF li jgħaqqad għal SQL server partikolari istanza u zkuk fl ma' l-id utent speċifiku u password u muri f'dan snippet:

  <LobSystemInstances>
    <LobSystemInstance Isem="ClaimsInstance">
      <Properties>
        <Proprjetà Isem="AuthenticationMode" Tip="System.String">PassThrough</Proprjetà>
        <Proprjetà Isem="DatabaseAccessProvider" Tip="System.String">SqlServer</Proprjetà>
        <Proprjetà Isem="RdbConnection Data Sors" Tip="System.String">server attwali  attwali istanza</Proprjetà>
        <Proprjetà Isem="Catalog inizjali RdbConnection" Tip="System.String">katalogu inizjali nnifisha</Proprjetà>
        <Proprjetà Isem="RdbConnection Integrata Sigurtà" Tip="System.String">SSPI</Proprjetà>
        <Proprjetà Isem="RdbConnection ippuljar" Tip="System.String">falza</Proprjetà>

        <!-- Dawn huma l-valuri ewlenin: -->
        <Proprjetà Isem="User ID RdbConnection" Tip="System.String">aID ctual User</Proprjetà>
        <Proprjetà Isem="Password RdbConnection" Tip="System.String">attwali Password</Proprjetà>
        <Proprjetà Isem="Trusted_Connection RdbConnection" Tip="System.String">falza</Proprjetà>

      </Properties>
    </LobSystemInstance>
  </LobSystemInstances>

Mhuwiex l-aħjar prattika, but it’s useful for a quick and simple configuration for testing. This was surprisingly difficult to figure out. I never found a functional example with search keywords:

  • ADF userid integrati u password
  • ssodata id-utent u password ADF
  • ssodata id-utent u password ADF BDC
  • Sharepoint primer BDC
  • Sharepoint utent embed id u password ADF

</aħħar>

Abbona għall-blog tiegħi.

4 ħsibijiet dwar "Funzjonali Eżempju: BDC ADF li jgħaqqad lill database SQL ma 'id-utent inkorporat u password”

  1. Ebda isem

    I nikseb dan meta jippruvaw jiksbu aċċess għas-user ID u Password wiht

    A Metadata Exception was constructed in App Domain ‘/LM/W3SVC/1032898172/Root-2-128851566339311184’. It-test sħiħ eċċezzjoni hija: The LobSystemInstance Property ‘AuthenticationMode’ has a value that requires ‘Integrated Security’ fis-sekwenza konnessjoni

    Irrispondi ↓
  2. Jan D'Hondt

    Havie tħabtu ma setup konnessjoni LobsystemInstance wisq. Użati kummenti tiegħek biex jiċċekkjaw jekk kollox maħduma.
    My setting differs in that i have set ‘Integrated security’ biex foloz minflok SSPI
    and ‘rdbconnection Pooling’ li veru.

    Osservazzjoni tiegħi dwar Konnessjoni Ġbir: peress li l-string konnessjoni għal kwalunkwe utent ta 'dan BDC se jkun eżattament l-istess, l-istess konnessjoni se jintużaw aktar u aktar mill-ġdid u għalhekk jistgħu jinġabru flimkien b'mod effiċjenti mis-sistema. Ub'hekk overhead fuq in-naħa server sql. Jew hemm xi ħaġa I injorat?

    Irrispondi ↓
  3. Leo kiteb:
    X'inhu l-istanza ACUTAL u katalogu inizjali nnifisha? Raden tiegħi huwa katalogu inizjali attwali għandha tkun ir database. X'inhu eżempju attwali mbagħad? U jekk MS SQL tiegħi qed tuża twieqi awtentikazzjoni ? x'għandhom ikunu l-user ID u password f'dan il-każ? dominju utent imbagħad twieqi tiegħi log fuq il-password?
    Irrispondi ↓

Ħalli Irrispondi

Your email address mhux se jkun ippubblikat. Meħtieġa oqsma huma mmarkati *