Saturday, April 19, 2008

BDC connection using SQLAuthentication to SQL Server (MOSS 2007)

I used many BDC editors, All of them didn't allow me to define connection to database using SQL Authentication. I found only way to do that update generated XML Defintion. to use SQL Authentication.Node need Modification:

<LobSystemInstances>
<LobSystemInstance Name="LOBSystemInstanceName">
<Properties>
<Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">PassThrough</Property>
<Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">SqlServer</Property> <Property Name="RdbConnection Data Source" Type="System.String">sqlInstance</Property>
<Property Name="RdbConnection Initial Catalog" Type="System.String">DataBase</Property>
<Property Name="rdbconnection Integrated Security" Type="System.Boolean">false</Property>
<Property Name="rdbconnection Password" Type="System.String">username</Property>
<Property Name="rdbconnection User ID" Type="System.String">password</Property>
</Properties>
</LobSystemInstance>


Property rdbconnection Integrated Security is true by default, and we need to add this attribute to allow us define SQL Authentication.

No comments: