Invalid linked service properties provided. The length of argument 'password' exceeds its limit of '128'.

Hi @Lorence Xevier Lakra
This error happens because the password field in the linked service has a maximum limit of 128 characters, and in your case the full connection string (including password and other parameters) is being passed instead of just the password value.

In Azure Data Factory / Synapse linked service, you should not paste the full connection string into the password field. Instead:

• Enter only the actual SQL password in the password field
• Provide the rest of the values (server, database, etc.) in their respective fields

If you prefer to use a full connection string, then use the connection string authentication option instead of individual fields.

Also, since you are using Azure Key Vault, make sure:

• The secret contains only the password (not the full connection string)
• The secret value length is within the supported limit

If you can share how you configured the linked service (without sensitive details), I can guide you further.

Thanks.