Microsoft SQL Server can't connect API authorization

damthanhlong

Dear All
I installed XORUX 7.30 by virtual appliance. I use GUI connect to MSSQL server but can't connect by API authorization.
The error as below, Please help us in this case. Many thank.


Long

damerva

Hello, have you gone through the installation process and installed the ODBC driver?
install documentation:
https://www.lpar2rrd.com/Microsoft_SQL_Server-performance-monitoring-install.php#MSSQLServer

Driver to install:
https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15

What you should see in the /etc/odbcinst.ini file:
[ODBC Driver <version number> for SQL Server]
Description=Microsoft ODBC Driver <version number> for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-<version number>.so.9.2
UsageCount=1

damthanhlong

Dear Damerva
We installed as link: https://www.lpar2rrd.com/Microsoft_SQL_Server-performance-monitoring-install.php#MSSQLServer
Dirver installed by virtual appliance

damerva

ok, I see now, the seemingly simple solution can be to open /etc/odbcinst.ini and manually rename [MSSQL] to for example [ODBC Driver 13 for SQL Server] as our script looks for this naming scheme [ODBC Driver * for SQL Server], can you try and do that?

damthanhlong

Won , Many thanks for your support.
Now, this case works well.