-
Problem report
-
Resolution: Fixed
-
Trivial
-
None
-
None
-
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
