Symptoms

• In Processing server monitor we can see the Processing in restart status for a long time with no change.
• In Application logs there are multiple errors reading:
  Requested operation requires an OLE DB Session object, which is not supported by the current provider

Cause

The issue appears when the level of TLS on servers is increased (by restricting lower levels on servers or requiring higher values from SQL) the SQL Native driver will not work.

Resolution

First, check if the issue is really in connection to the DB by doing the following:

1. Open Notepad.
2. Save the file as 'Connectivity Test.udl' and file type as 'All Files'.
3. Open the saved file.
4. Select Microsoft OLE DB Provider for SQL Server as the provider.
5. Provide server connection and authentication details
6. Test the connection.

Using SQL 11 Native test connection will fail.

Use SQLOLEDB18 and it works.

Once the rootcause is confirmed you can resolve the issue with some manual adjustment to the DB connection config file. First, navigate to C:\inetpub\wwwroot\FlexiCapture12\Server and adjust web.config in the below snippet:

<connectionStrings><add name="FlexiCapture12ConnectionString" connectionString="Provider=SQLNCLI11;Data Source=(local)\SQLEXPRESS_TEST;Initial Catalog=CATALOG;Trusted_Connection=yes" /></connectionStrings>

to this (change Provider value)

<connectionStrings><add name="FlexiCapture12ConnectionString" connectionString="Provider=SQLOLEDB18;Data Source=(local)\SQLEXPRESS_TEST;Initial Catalog=CATALOG;Trusted_Connection=yes" /></connectionStrings>