You are getting the below error message from the R3trans execution,
R3trans -d
This is R3trans version 6.26 (release 753 - 09.03.21 - 17:57:99).
unicode enabled version
2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'HOSTNAME' DBNAME = 'sid'"
R3trans finished (0012).
more trans.log
INFO: A known driver is being used: [SQL Server].
ODBC Driver chosen: SQL Server non-native
The ODBC based DBSL library must use a SQL Server Native Client
For more information please refer to SAP note 1082356
***LOG BY2=>sql error 0 performing CON
***LOG BY0=><message text not available>
2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'HOSTNAME' DBNAME = 'SID'"
Solution
The solution is shared in SAP Note 2748805 – Database error 102 Incorrect syntax near ‘,’.
The error is due to no ODBC driver installed on the application server so it uses the windows default ODBC driver: SQL Server non-native. This driver could let the connection open but it cannot support the monitoring function on DBACOCKPIT.
Download and install the ODBC driver on the application server-side.
- For Linux operating system:
- Follow steps in 1644499 – Database connectivity from Linux to SQL Server
- For Windows operating system:
- Use google, search for msodbcsql.msi. Alternatively, access to this Microsoft page, https://aka.ms/downloadmsodbcsql
