I´m using the legacy LS for Postres SQL (SHIR) and the connection is working fine, with no issues until today. I need to update the linked service (MS recomend to do it until 31/10/2024) but I´m receiving an error while testing the connection for the new one.
Everythin is passing via an Self-Hosted Integration Runtime installed on a local virtual machine.
Here´s the LS legacy json running ok:
{
"name": "telemetria",
"type": "Microsoft.DataFactory/factories/linkedservices",
"properties": {
"type": "PostgreSql",
"typeProperties": {
"server": "abcdefgh.rds.amazonaws.com",
"database": "mydb",
"username": "myuser",
"encryptedCredential": "------------------"
},
"connectVia": {
"referenceName": "shir",
"type": "IntegrationRuntimeReference"
},
"annotations": []
}
}
I'm trying to create with the new connector, but the connection test it´s failing.
Code:
{
"name": "telemetria_new",
"type": "Microsoft.DataFactory/factories/linkedservices",
"properties": {
"annotations": [],
"type": "PostgreSqlV2",
"typeProperties": {
"server": "abcdefgh.rds.amazonaws.com",
"port": 5432,
"database": "mydb",
"username": "myuser",
"sslMode": 0,
"authenticationType": "Basic",
"encryptedCredential": "------------------"
},
"connectVia": {
"referenceName": "shir",
"type": "IntegrationRuntimeReference"
}
}
}
Info:
- Error code: 11402
- Details: The value of the property 'passwordmypassword;ssl mode' is invalid: 'Couldn't set passwordmypassword;ssl mode Parameter name: passwordmypassword;ssl mode'. Couldn't set passwordmypassword;ssl mode Parameter name: passwordmypassword;ssl mode The given key was not present in the dictionary.
- Additional info: the text 'mypassword' is the current password
I´m not the dba.
Connection from SelfHosted Integration Runtime is ok for that serve, database, user and password.
Can someone help me please?
Thanks in advance!