Symptom
After upgrading to Microsoft ODBC Driver 18 for SQL Server version 18.7.1.1, SAP Business One cannot connect to SQL Server 2022. The following errors occur:
- ODBC trace error: [Microsoft][ODBC Driver 18 for SQL Server]Invalid value specified for connection string attribute ‘MultipleActiveResultSets’
- Installer error at Database Server Connection: Failed to connect to the database server
- SAP Business One client log error: Cannot connect to sbo common DB with DB user: B1_SBOCOMMON
Reproducing the issue
Prerequisites:
- SQL Server 2022 is installed
- Microsoft ODBC Driver 18 for SQL Server version 18.7.1.1 is installed.
Scenario for new installations:
- Install a new SQL Server 2022 instance.
- Update the Microsoft ODBC Driver to version 18.7.1.1.
-
Run the Setup Wizard.
- At the Database Server Connection step, attempt to register the SQL Server
Expected behavior:
The installer connects to the database server and the installation proceeds.
Actual behavior:
The installer displays the error: “Failed to connect to the database server.”
Scenario for existing installations:
- Update the Microsoft ODBC Driver on the workstation to version 18.7.1.1.
- Launch the SAP Business One client.
- Select a company and attempt to log on.
Expected behavior:
The SAP Business One client logs on successfully.
Actual behavior:
The client fails to connect with the ODBC error about the MultipleActiveResultSets attribute.
The client log shows Cannot connect to sbo common DB with DB user: B1_SBOCOMMON.
Solution
SAP intends to provide a feature package or patch to solve the symptom that is described in this SAP Note. The section References below lists the related feature package or patch once they become available. Be aware that References can only be confirmed at feature package or patch release date. SAP delivers feature packages or patches only for selected releases at its own discretion, based on the business impact and the complexity of implementation.
Workaround:
Uninstall Microsoft ODBC Driver 18 for SQL Server version 18.7.1.1 and install a previous compatible version of the driver e.g 18.6.1.1.