topic Re: Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [08S01] TDSConnectionFailed, ") in Data Movement & Streaming

Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [08S01] TDSConnectionFailed, ")

bskemp01 — Wed, 19 Mar 2025 22:43:16 GMT

I need some help with a MSSQL Data connection on Qlik Cloud. i have created a data connection to our MS SQL database and when i test the connection it is successful:

Now when i try to input code into the load editor to use that connection it fails and gives me this error:

***Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [08S01] TDSConnectionFailed, ")***

when i check the data connection to see if i could at least see the tables available it get this:

***WE HAVE THE SAME SETUP ON OUR CLIENT MANAGED SYSTEM AND THAT WORKS, SO I KNOW ITS NOT THE DATABASE CONNECTION***

i am not sure what is happening. can someone give some insight?

Re: Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [08S01] TDSConnectionFailed, ")

anat — Wed, 27 Dec 2023 15:45:13 GMT

can you check same by creating ODBC connection string

Re: Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [08S01] TDSConnectionFailed, ")

bskemp01 — Wed, 27 Dec 2023 16:01:32 GMT

ill be honest, im not sure how to accomplish this. i have the following(please correct me as im still new to this):

connection string values:

serverName: Server IP Address

Port: Port Number

databaseName: Name

then in the encrypted properties:

Username & Password

but i get this so i must be putting this in wrong