Unable to connect to MSSQL server

Sergii_Skybenko
Sergii_Skybenko
in LPAR2RRD
I have configured MSSQL connection in WEB. LPAR2RRD version 7.30
Below is an output from check script /home/lpar2rrd/lpar2rrd/load_sqlserver.sh 
I am able to connect to DB with another tool like mssql-cli.
What is wrong or missed in my setup?

Image environment is set
Start SOESB Data Fetch



sqlserver-json2rrd.pl : push data to rrd, Mon Mar 28 17:35:34 +04 2022
RRDp    version   : 1.4008
RRDtool version   : 1.4.8
sqlserver-json2rrd.pl : status , Mon Mar 28 17:35:34 +04 2022
oracleDB-json2db.pl             : db, Mon Mar 28 17:35:34 +04 2022
An error occured in lpar2rrd, check /home/lpar2rrd/lpar2rrd/logs/error.log-sqlserver and output of load_sqlserver.sh

$ tail -6 /home/lpar2rrd/lpar2rrd/logs/error.log-sqlserver

[Mon Mar 28 17:35:34 2022] sqlserver-db2json.pl: [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (SQL-HYT00) [state was HYT00 now 08001]
[Mon Mar 28 17:35:34 2022] sqlserver-db2json.pl: [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x102 (SQL-08001)
[Mon Mar 28 17:35:34 2022] sqlserver-db2json.pl: [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (SQL-08001) [state was 08001 now 01S00]
[Mon Mar 28 17:35:34 2022] sqlserver-db2json.pl: [Microsoft][ODBC Driver 18 for SQL Server]Invalid connection string attribute (SQL-01S00) at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 374.
[Mon Mar 28 17:35:34 2022] sqlserver-json2rrd.pl: Use of uninitialized value $file in concatenation (.) or string at /home/lpar2rrd/lpar2rrd/bin/sqlserver-json2rrd.pl line 89.
[Mon Mar 28 17:35:34 2022] sqlserver-json2rrd.pl: Perf file for SOESB doesn't exist  at /home/lpar2rrd/lpar2rrd/bin/sqlserver-json2rrd.pl line 93.
date end all      : Mon Mar 28 17:35:34 +04 2022

Comments

  • damerva
    damerva
    Hello, can you please try connection test that is in the configuration form where you set up the monitoring and send us a screeshot of the output?
  • Sergii_Skybenko
    Sergii_Skybenko
    Hello, Damerva

    Please find below
    [lpar2rrd@xorux02 etc]$ perl /home/lpar2rrd/lpar2rrd/bin/conntest.pl 172.30.174.96 1433
    Connection to "172.30.174.96" on port "1433" is ok


  • Sergii_Skybenko
    Sergii_Skybenko
    Any idea how to solve my question?
  • damerva
    damerva
    Does this happen every time you test connection or does it sometimes go through?
  • Sergii_Skybenko
    Sergii_Skybenko
    It happens every time when I test a connection.
  • damerva
    damerva
    We looked at this closely and are you sure the IP address is correct?

    connection test you sent us output of was done to 172.30.174.96:1433
    and the one entered into web form is 172.130.174.96:1433



  • Sergii_Skybenko
    Sergii_Skybenko
    It was so easy!
    Many thanks. It was my mistake!
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Categories

In this Discussion