Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-25324

MSSQL ODBC driver special password syntax required

XMLWordPrintable

    • S24-W40/41, S24-W42/43, S24-W44/45
    • 0.5

      Response from customer:
      Before upgrade to 6.4.19 - yes it worked when you entered the password directly with braces and a semi colon. Also worked if the macro for the password was updated with the braces around it and a semi colon. With just the password in the ui (without braces and a semi colon) it would fail with integrated authentication.

      After upgrade to 6.4.19 - correct the workaround (entering password field with braces and a semi colon at the end) or leaving the password field without modification both fail with Integrated authentication failure

      Think i mentioned below but if not - isql behaves similar that if I add a semicolon at the end it works (with special character wrapped in braces).

      as_vzfxfb@pwcppvwzbx001:~$ isql -v -k 'Driver=FreeTDS;Server=XXX;Port=1433;Database=FlexNet;TrustServerCertificate=yes;TrustServerCertificate=yes;UID=pwc\svc_mfg_app_mon;PWD={Zj;Fp&f`2BjWIX|YhWC9*PS!$c0obJR5}'
      [S1000][FreeTDS][SQL Server]Unable to connect to data source
      [37000][FreeTDS][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
      [ISQL]ERROR: Could not SQLDriverConnect
      
      
      as_vzfxfb@pwcppvwzbx001:~$ isql -v -k 'Driver=FreeTDS;Server=XXX;Port=1433;Database=FlexNet;TrustServerCertificate=yes;TrustServerCertificate=yes;UID=pwc\svc_mfg_app_mon;PWD={Zj;Fp&f`2BjWIX|YhWC9*PS!$c0obJR5};'
      +---------------------------------------+
      | Connected!                            |
      |                                       |
      | sql-statement                         |
      | help [tablename]                      |
      | quit                                  |
      |                                       |
      +---------------------------------------+
      SQL> quit

       

       

            sboidenko Sergejs Boidenko
            sboidenko Sergejs Boidenko
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: