User name not support to store in key vault in file system link with error "Failed to convert the value in 'userid' property to 'System.String' type"

Yu Dong 1 Reputation point Microsoft Employee
2022-05-03T07:47:16.91+00:00

The user name is not supported to store in the File system linked service with the error message “Failed to convert the value in 'userid' property to 'System.String' type. Please make sure the payload structure and value are correct.”.
198366-image.png

The test connection can be successful for the user name to store in the key vault with property “userName” in the SQL server link.
198350-image.png

The user name in some linked services supported to store in the key vault, but it is not supported in the file server link. If the user name is not supported to store in the key vault for the file system link, can it be added to the error message to avoid misunderstanding? As a feature request, can user name support to store in the key vault for the file system link?

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,184 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,120 questions
{count} votes