Problem Note 68415: A data-store test connection to the SQL server fails in SAS® Visual Investigator
 |  |  |  |
For SAS Visual Investigator in the Linux operating environment, a data-store test connection to the SQL server fails with the following error:
Connection Test Failed
Authentication failure while connecting to data store
This problem occurs when the SQL server database is configured with Microsoft Windows authentication.
When this problem occurs, the datahub log displays the following error:
datahub log:
2021-09-08 15:12:40.072 INFO 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] connectionTest(SQL Server): jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev: DataStoreConfig.ConnectionTesterProperties[enabled=true,performSocketConnectTest=true,connectTimeoutInSeconds=5]
2021-09-08 15:12:40.073 INFO 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] isReachable(ccl-007-w.zsp.sas.com:1433): timeout=5 sec, inet-address: ccl-007-w.zsp.sas.com/10.70.132.9:1433 (isUnresolved: false)
2021-09-08 15:12:40.074 INFO 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] Successfully established socket connection to ccl-007-w.zsp.sas.com:1433
2021-09-08 15:12:40.074 INFO 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] testJdbcConnection(SQL Server): jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev
2021-09-08 15:12:40.086 ERROR 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] Connection error while testing jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev: (state 28000, errorCode 18456)
2021-09-08 15:12:40.086 ERROR 25423 — [-auto-1-exec-87] c.s.fcs.datahub.datastore.DataStoreUtil : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] Authentication error (ccl-007-w.zsp.sas.com): jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev
2021-09-08 15:13:19.844 INFO 25423 — [auto-1-exec-101] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [7d7daa505c4f81f6] connectionTest(SQL Server): jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev: DataStoreConfig.ConnectionTesterProperties[enabled=true,performSocketConnectTest=true,connectTimeoutInSeconds=5]
2021-09-08 15:12:40.072 INFO 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] connectionTest(SQL Server): jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev: DataStoreConfig.ConnectionTesterProperties[enabled=true,performSocketConnectTest=true,connectTimeoutInSeconds=5]
2021-09-08 15:12:40.073 INFO 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] isReachable(ccl-007-w.zsp.sas.com:1433): timeout=5 sec, inet-address: ccl-007-w.zsp.sas.com/10.70.132.9:1433 (isUnresolved: false)
2021-09-08 15:12:40.074 INFO 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] Successfully established socket connection to ccl-007-w.zsp.sas.com:1433
2021-09-08 15:12:40.074 INFO 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] testJdbcConnection(SQL Server): jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev
2021-09-08 15:12:40.086 ERROR 25423 — [-auto-1-exec-87] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] Connection error while testing jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev: (state 28000, errorCode 18456)
2021-09-08 15:12:40.086 ERROR 25423 — [-auto-1-exec-87] c.s.fcs.datahub.datastore.DataStoreUtil : ibmino@@dev(aad1657a) [3fb14b6cb5e7c5ba] Authentication error (ccl-007-w.zsp.sas.com): jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev
2021-09-08 15:13:19.844 INFO 25423 — [auto-1-exec-101] c.s.f.d.d.management.ConnectionTester : ibmino@@dev(aad1657a) [7d7daa505c4f81f6] connectionTest(SQL Server): jdbc:sas:sqlserver://ccl-007-w.zsp.sas.com:1433;DatabaseName=fdasvidev: DataStoreConfig.ConnectionTesterProperties[enabled=true,performSocketConnectTest=true,connectTimeoutInSeconds=5]
To resolve this issue, you must add the AuthenticationMethod=ntlmjava parameter to the data-store connection properties, as shown below:
This parameter enables connections from Linux that use Windows authentication.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.7 | 10.7 | Viya | Viya |
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-10-28 15:03:24 |
| Date Created: | 2021-09-21 09:18:25 |