Azure MSSQL Server Database connection problem

[Skylark]

Hello,

In the project development system, we have defined a connection via the DBCON transaction code to access a non-SAP system at the database level.
The non-SAP system on the other end operates on Azure MS SQL Server database software.

When we attempted to access it by performing DBCON operations within the classic SAP application layer, the process terminated with the following error message.
In response to this error, we added the "MSSQL_SE=1" parameter, but the outcome remains unchanged, resulting in unsuccessful access.

Could not open connection XXXXXXX .
sql error 99 occured:
The DBSL library supports only connections to the SQL Server Database Engine with the Engine Edition = 3. #The target SQL Server Engine Edition is 5. #For more information please refer to the SAP note 2497147.

The explanation in SAP Note 2497147 titled 'SAP DBSL connectivity to Microsoft "SQL" or "SQL Server" branded products' seems to suggest that even with the addition of the "MSSQL_SE=1" parameter to the connection string, Azure is not supported. We would like to confirm that we have understood this correctly.

Azure SQL Server information

SELECT SERVERPROPERTY ('Edition')
“SQL Azure”
SELECT SERVERPROPERTY ('EditionID')
“1674378470”
SELECT SERVERPROPERTY ('EngineEdition')
“5”

Best Regards

[Sriram2009]

Hi

Have you check the SAP note 2497147.?

Regards

SS

[Skylark]

Dear Sriram,

I have reviewed SAP Note 2497147, but I am not entirely clear about the section regarding Azure. It appears that Azure is not supported as mentioned in the note. When we tried the "MSSQL_SE=1" parameter as suggested in the note, the result remained unchanged. I would like to know your valuable interpretation of the information in the note related to Azure.

The SAP Database Shared Library (DBSL) for Microsoft SQL Server was first developed over 20 years ago and it was developed to work specifically with the SQL Server application commonly referred to now as the SQL Server Database Engine. This could be called the mainstream, first version of SQL Server as all other applications with SQL or SQL Server in the name came later and a few are on a code base that is completely different. A short, incomplete list for illustrative purposes of these other SQL branded products that we don't support are: SQL Server Analysis Services; SQL Server Reporting Services; SQL Server Parallel Data Warehouse, Azure SQL Database, Azure SQL Database Managed Instance; Azure SQL Data Warehouse; etc.

Thakn you
Best Regards

[riccardo_cola · Accepted solution]

Hi,

Yes, you understood correctly.

SAP ABAP systems DBCON uses the Microsoft ODBC driver for Linux + the SAP Kernel database library (LIB_DBSL dbmssslib.so, part of SAPEXEDB package) to connect to other SAP/non-SAP systems database.

The SAP Kernel database library (LIB_DBSL dbmssslib.so) only supports connection to Microsoft SQL Server "Enterprise Edition" (IaaS), other database editions such as Developer, Express, Standard and databases such as Azure SQL and AWS databases are not supported by SAP.

SAP note 2497147 is SAP document relevant to your inquiry.

Best regards,
Riccardo

[Skylark · Accepted solution]

Dear Riccardo,

Thank you for your support.

Have a nice day.