There are a number of options that you can use when you define your connection settings in your BDC ADF file:
The authentication methods are:
RevertToSelf
Simply uses the application pool account (reverts back to this account) to access the database.
1: <Properties>
2: <Property Name="AuthenticationMode" Type="System.String">RevertToSelf</Property>
3: <Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>
4: <Property Name="RdbConnection Data Source" Type="System.String">servername</Property>
5: <Property Name="RdbConnection Initial Catalog" Type="System.String">databasename</Property>
6: <Property Name="RdbConnection Integrated Security" Type="System.String">SSPI</Property>
7: <Property Name="RdbConnection Pooling" Type="System.String">false</Property>
8: </Properties>
PassThrough
Passes the credentials of the calling user, this will only work on a single server install or on a farm if Kerberos is enabled.
1: <Properties>
2: <Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>
3: <Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>
4: <Property Name="RdbConnection Data Source" Type="System.String">servername</Property>
5: <Property Name="RdbConnection Initial Catalog" Type="System.String">databasename</Property>
6: <Property Name="RdbConnection Integrated Security" Type="System.String">SSPI</Property>
7: <Property Name="RdbConnection Pooling" Type="System.String">false</Property>
8: </Properties>
SQL Authentication
It is still possible to use SQL Server Authentication, the following example uses the RdbConnection properties for this:
1: <Properties>
2: <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">
3: RevertToSelf</Property>
4: <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">
5: SqlServer</Property>
6: <Property Name="RdbConnection Data Source" Type="System.String">servername</Property>
7: <Property Name="RdbConnection Initial Catalog" Type="System.String">databasename</Property>
8: <Property Name="RdbConnection Integrated Security" Type="System.String">false</Property>
9: <Property Name="RdbConnection User ID" Type="System.String">username</Property>
10: <Property Name="RdbConnection Password" Type="System.String">password</Property>
11: </Properties>
12:
Single Sign On
If your using SSO, this is also supported:
1: <Properties>
2: <Property Name="AuthenticationMode" Type="System.String">RdbCredentials</Property>
3: <Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>
4: <Property Name="RdbConnection Data Source" Type="System.String">servername</Property>
5: <Property Name="RdbConnection Initial Catalog" Type="System.String">databasename</Property>
6: <Property Name="RdbConnection Integrated Security" Type="System.String">false</Property>
7: <Property Name="RdbConnection Pooling" Type="System.String">true</Property>
8: <Property Name="SsoApplicationId" Type="System.String">SSO Application you created</Property>
9: <Property Name="SsoProviderImplementation" Type="System.String">Microsoft.SharePoint.Portal.SingleSignon.SpsSsoProvider,
Microsoft.SharePoint.Portal.SingleSignon, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Property>
10: </Properties>
The MSDN documentation can be found here.