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>
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
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?