I've tried it with every AuthenticationMode! But no one seems to work correctly in my case. I thought that PassThrough should work with a preset User ID and password. This would be enough for the moment, but even this doesn't work!!
With WindowsCredentials I get the following error:
The Property with name 'SsoApplicationId' is missing on the LobSystemInstance.
SsoApplicationId I tried to set this with the SharePoint SSO but I've no such services. How can I set this just for the current WindowsCredentials (of the current Sharepoint user)
With RevertToSelf I get the following error:
"An error occurred while retrieving data from MyLOBInstance. Administrators, see the server log for more information."
The server log contained no useful information for me.
With PassTrough I get the following error:
"Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <local machine>]"
Why are the lines
<Property Name="RdbConnection User ID" Type="System.String">MyDomain\Administrator</Property>
<Property Name="RdbConnection Password" Type="System.String">mYpAssWoRd</Property>
being ignored
Everything (MOSS, SQLServer,...) is on a single machine, so I don't need to activate Kerberos, do I
<LobSystemInstance Name="SEPInstance1207">
<Properties>
<Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">SqlServer</Property>
<Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">PassThrough</Property>
<Property Name="RdbConnection Data Source" Type="System.String">MyDBServer</Property>
<Property Name="RdbConnection Initial Catalog" Type="System.String">MyDataBase</Property>
<Property Name="RdbConnection Integrated Security" Type="System.String">TRUE</Property>
<Property Name="RdbConnection User ID" Type="System.String">MyDomain\Administrator</Property>
<Property Name="RdbConnection Password" Type="System.String">mYpAssWoRd</Property>
<Property Name="RdbConnection Pooling" Type="System.String">False</Property>
</Properties>
</LobSystemInstance>
PassThrough authentication fails: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
Romantic_touch
Hi,
Try to remove/change the line about Integrated Security
<Property Name="RdbConnection Integrated Security" Type="System.String">TRUE</Property>
Regards,
Joran Markx
MarnieV
The reason why it is failing with "NT Authority\network service" is because you have the web application running under that account. If you want to use a SQL account you will need to set up Single Sign On (SSO). If this is the method you would like to use write back and I will walk you through or provide you a web address that details the procedure. If you want to use reverttoself or passthrough (which I have not used yet, but is the easiest), you will need to change the account you are running Sharepoint under in IIS to a domain account so it can impersonate properly. From what I understand you can do this with the default NTML authentication. Out of curiousity, where have you seen the properties for Rdbconnection User ID and Password detailed because I have never seen an example of that.
xecoy
Thanks for your answer. Removing/changing doesn't fix my problem.
But it seems that no table cols with data type uniqueidentifier are allowed as a primary key in a BDC file! Changing the primary key's data type solved partially my problem
John Cronan
I was wrong in that you can not do passthrough with NTML you have to do it with Kerberos when the SQL data source is located on another system.
PDADev
Misleading error, don't you think.
Success!