There are a lot of articles out there about using SSO with MOSS 2007 to allow a business
data catalog to connect to a sql server on the back end. The problem is that most
of them assume you want to use either the currently authenticated user or the application
pool account. If you want to connect using SQL Authentication, then you need to alter
your business data definition file and modify the connection portion to look like
this:
<LobSystemInstance Name="SMS_BG1Instance"> <Properties> <Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property> <Property Name="AuthenticationMode" Type="System.String">RdbCredentials</Property> <PropertyName="RdbConnection Data Source" Type="System.String">dbServer</Property> <Property Name="RdbConnection Initial Catalog" Type="System.String">dbName</Property> <Property Name="RdbConnection Pooling" Type="System.String">false</Property> <Property Name="SsoApplicationId" Type="System.String">SsoID</Property> <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> </Properties> </LobSystemInstance>Random Posts
Loading…