Microsoft SQL Server can't connect API authorization

damthanhlong · March 2022

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.

Image: https://forum.xorux.com/uploads/editor/7i/pxwp14pvfdfe.png

Image: https://forum.xorux.com/uploads/editor/3f/bm8xtwlvd2a7.png

Long

damerva · March 2022

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 · March 2022

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

Image: https://forum.xorux.com/uploads/editor/0c/pryoa9591l9m.png

Image: https://forum.xorux.com/uploads/editor/1g/t8znj3veby8a.png

damerva · March 2022

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 · March 2022

Won

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

Microsoft SQL Server can't connect API authorization

Comments

Howdy, Stranger!

Categories

In this Discussion