Kuv xav tau los hlau tuaj NTXHUAB rau ib SQL database ntawm BDC. Rau kev tshuaj ntsuam txog/POC, Kuv xav mus embed rau SQL tus account neeg tus id thiab lo lus zais rau hauv cov ADF. Pib nrog no template (http://msdn2.microsoft.com/en-us/library/ms564221.aspx), Kuv tsim ib ADF connects rau ib tug SQL neeg rau zaub mov lom thiab logs tau maub ib hais neeg tus id thiab lo lus zais thiab qhia hauv no snippet:
<LobSystemInstances> <LobSystemInstance Lub npe="ClaimsInstance"> <Khoom> <Khoom Lub npe="AuthenticationMode" Hom="System.String">PassThrough</Khoom> <Khoom Lub npe="DatabaseAccessProvider" Hom="System.String">SqlServer</Khoom> <Khoom Lub npe="RdbConnection tej ntaub ntawv tau qhov twg los" Hom="System.String">serveractual txoos lom</Khoom> <Khoom Lub npe="RdbConnection thaum Catalog" Hom="System.String">nqi pib catalog</Khoom> <Khoom Lub npe="RdbConnection kev ruaj ntseg" Hom="System.String">SSPI</Khoom> <Khoom Lub npe="RdbConnection Pooling" Hom="System.String">tsis tseeb</Khoom> <!-- Cov no yog cov tseem ceeb hauv qhov tseem ceeb: --> <Khoom Lub npe="Cov neeg siv RdbConnection ID" Hom="System.String">ib tugctual neeg ID</Khoom> <Khoom Lub npe="RdbConnection Password" Hom="System.String">txoos Password</Khoom> <Khoom Lub npe="RdbConnection Trusted_Connection" Hom="System.String">tsis tseeb</Khoom> </Khoom> </LobSystemInstance> </LobSystemInstances>
Nws tseem tsis tau muaj kev xyaum zoo tshaj, tiam sis nws tseem pab tau rau ib txoj kev sai thiab yooj yim configuration kev soj ntsuam. Qhov no kuj ceeb tias yooj yim paub. Kuv yeej tsis pom ib tug piv txwv tej qhov chaw uas nrhiav keywords:
- adf kev userid thiab lo lus zais
- embed neeg tus id thiab lo lus zais rau hauv adf
- embed neeg tus id thiab lo lus zais rau hauv adf bdc
- sharepoint bdc primer
- sharepoint embed neeg tus id thiab lo lus zais rau hauv adf
</kawg>
Kuv txais tau qhov no thaum uas ua tau rau hauv koj tsev neeg tus id thiab lo lus zais
Ib Metadata kos yog ua lub tsev nyob rau sau App '/ LM/W3SVC/1032898172/cag-2-128851566339311184'. Yog cov kos tag nrho cov ntawv nyeem: Cov cuab yeej LobSystemInstance ' AuthenticationMode’ muaj ib tug nqi hais tias yuav tsum ' Integrated Security’ nyob rau hauv cov kev twb kev txuas hlua
Havie struggled LobsystemInstance kev twb kev txuas teeb uas muaj ib yam nkaus thiab. Siv cov lus koj los saib seb puas yog hais tias txhua yam ua haujlwm.
Kuv qhov raws rau qhov hais tias kuv tau teem ' kev ruaj ntseg’ yuav tsis tseeb tsis SSPI
thiab ' rdbconnection Pooling’ yuav muaj tseeb.
Kuv soj txog Pooling kev twb kev txuas: vim txoj kev twb kev txuas hlua rau lwm tus neeg siv ntawm no BDC yuav xyov zoo li qub, kev twb kev txuas ib yam yuav siv tau tsiv thiab thiaj li yuav tau nraaj pooled ntawm lub cev. Yog li txuag overhead sql neeg rau zaub mov sab. Los puas muaj tej yam kuv overlooked?