Click to See Complete Forum and Search --> : sharepoint BDC double hop problem


Gozzy82
02-25-2010, 11:43 AM
This is my setup:

Sharepoint on an server A
SQL server on server B
Also i have a sql server installation on my laptop C

I created a BDC from a database on my laptop for testing purposes which imports ok the problem seems to be the double hop problem.

I have been doing some research on this and it seems there are 2 ways to resolve this issue:

1) use kerberos authentication instead of NTLM
2) use <Property Name="AuthenticationMode" Type="System.String">RevertToSelf</Property> instead of <Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>

and give sql access to the moss server.

I am wondering if there are any other solutions to this problem also if you have a good article concerning the "double hop" problem please post them...

grts, Gozzy