Windows authenticated OLEDB data source

Applies to Infiniti v8.1 or later
 

Many data sources only support Windows Authentication (e.g. SQL server), which is supported by the inbuilt OLEDB data source provider.

To accesses a windows authenticated data source data source the identity of the application pool to which Intelledox belongs to must be set to a user who has access to the data source. When the data source is hit by Intelledox it will authenticate as this user. Application pool identities are configured in IIS.

Once IIS identify is configured the data source can be created in Director. Use a connection string similar to the following and ensure the ‘Use windows Authentication’ option is selected.

Provider=SQLOLEDB.1;Initial Catalog=CustomTableDB;DataSource=intelledox42;Trusted_Connection=Yes;

 

Related Articles

 

 

Keywords

 

windows authenticate oledb data source sql