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

[bskemp01]

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?

[anat]

can you check same by creating  ODBC connection string

[bskemp01]

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