Mfano kazi: BDC ADF kwamba unajumuisha na database SQL na id iliyoingia mtumiaji na nywila

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 hii template (http://msdn2.microsoft.com/en-us/library/ms564221.aspx), Mimi umba ADF kwamba unajumuisha na hasa mfano SQL server na magogo katika na id maalum mtumiaji na nywila na inavyoonekana katika snippet hii:

  <LobSystemInstances>
    <LobSystemInstance Jina="ClaimsInstance">
      <Mali>
        <Mali Jina="AuthenticationMode" Aina="System.String">PassThrough</Mali>
        <Mali Jina="DatabaseAccessProvider" Aina="System.String">SqlServer</Mali>
        <Mali Jina="RdbConnection Takwimu Chanzo" Aina="System.String">server halisi  halisi mfano</Mali>
        <Mali Jina="RdbConnection Awali Catalog" Aina="System.String">halisi ya awali catalog</Mali>
        <Mali Jina="RdbConnection Integrated Usalama" Aina="System.String">SSPI</Mali>
        <Mali Jina="RdbConnection kuunganisha" Aina="System.String">uongo</Mali>

        <!-- Haya ni maadili muhimu: -->
        <Mali Jina="RdbConnection User ID" Aina="System.String">actual User ID</Mali>
        <Mali Jina="RdbConnection Siri" Aina="System.String">halisi cha Siri</Mali>
        <Mali Jina="RdbConnection Trusted_Connection" Aina="System.String">uongo</Mali>

      </Mali>
    </LobSystemInstance>
  </LobSystemInstances>

Si njia bora, 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 iliyoingia userid na password
  • embed user id na password katika ADF
  • embed user id na password katika ADF BDC
  • SharePoint BDC primer
  • SharePoint kupachika user id na password katika ADF

</mwisho>

Kujiunga na blog yangu.

4 mawazo juu ya "Mfano kazi: BDC ADF kwamba unajumuisha na database SQL na id iliyoingia mtumiaji na nywila

  1. Hakuna jina

    Mimi kupata hii wakati akijaribu kupata wiht user id na Password

    A Metadata Exception was constructed in App Domain ‘/LM/W3SVC/1032898172/Root-2-128851566339311184’. Nakala kamili isipokuwa ni: The LobSystemInstance Property ‘AuthenticationMode’ has a value that requires ‘Integrated Security’ katika kamba ya uhusiano

    Kujibu
  2. Jan D'Hondt

    Havie Jihadi pamoja na kuanzisha uhusiano LobsystemInstance pia. Kutumika maoni yako kuangalia kama kila kitu kazi.
    My setting differs in that i have set ‘Integrated security’ kwa uongo badala ya SSPI
    and ‘rdbconnection Pooling’ kwa kweli.

    Uchunguzi wangu kuhusu Connection kuunganisha: tangu kamba uhusiano kwa user yoyote ya BDC hii itakuwa sawa, uhusiano huo zitatumika tena na tena na hiyo inaweza kuwa ufanisi walichukua na mfumo. Hivyo kuokoa Rudia upande server SQL. Au kuna kitu mimi kupuuzwa?

    Kujibu
  3. Leo aliandika:
    Je, ni mfano acutal na halisi ya awali catalog? Nadhani yangu ni halisi ya awali catalog lazima database. Je, ni mfano halisi kisha? Na kama yangu MS SQL ni kutumia madirisha uthibitishaji ? nini itakuwa id mtumiaji na nywila katika kesi hii? uwanja mtumiaji basi yangu madirisha logi juu ya password?
    Kujibu

Kuondoka Reply

Anwani yako si kuchapishwa. Mashamba required ni alama *