Qliksense Microsoft sql server connectivity issue

[Karan0709]

Hi Guys,

I am trying to connect qliksense with the AWS RDS SQL DB the cloud team did their job of adding the security rules etc. I am able to communicate to the db from my QS dev server 10.209.192.30 via powershell(to test) with below script which also listed the tablenames but not able to create connection in qliksense.

it shows "Connection failed: please check the values of username, password, host and other properties. I was able to login to the DB on 10.209.64.140 with the same username and password. 

Powershell script: 

$server = "glonnopdbqax01.cnrdvfewbvrj.eu-west-1.rds.amazonaws.com,1431"

$user = "admin"

$pwd = "*****"

$dbName = "NetOpSandbox" # <--- Put the name from Step 1 here

# Updated Connection String with 'Database' parameter

$connString = "Server=$server;Database=$dbName;User ID=$user;Password=$pwd;Encrypt=True;TrustServerCertificate=True;"

$conn = New-Object System.Data.SqlClient.SqlConnection($connString)

try {

$conn.Open()

Write-Host "Successfully connected to database: $dbName" -ForegroundColor Green

# Example: List the first 5 tables in this database

$cmd = $conn.CreateCommand()

$cmd.CommandText = "SELECT TOP 5 TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'"

$tableReader = $cmd.ExecuteReader()

Write-Host "--- Tables Found ---" -ForegroundColor Cyan

while ($tableReader.Read()) {

Write-Host " > $($tableReader['TABLE_NAME'])"

}

$tableReader.Close()

$conn.Close()

}

catch {

Write-Error "Failed to connect to $dbName. Error: $($_.Exception.Message)"

}

//////////

I am using qliksense november 2024 patch 19 - 14.212.30 Not sure what exactly is the issue can please someone help me I am attaching the screenshots of connection and I also tried with all combination encrypt, trust server certificate etc still the same error. Is it the driver or patch issue. 

Any help will be highly appreciated.

[chriscammers]

Your parameters on the powershell and the Qlik Connector are different, try clicking the check box on the Trust Server Certificate option.