ADF import ARM templates connection string failure

mustafa.ispir 21 Reputation points
2022-07-19T14:15:15.543+00:00

I have export a pipeline template (not export arm template) and try to import another adf and had a conneciton string fail.

I copied the connection string from this format ;

Server=tcp:XXX.database.windows.net,1433;Initial Catalog=<databasename>;Persist Security Info=False;User ID=<user>;Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

And i also try this format copied from linked services and append password

"connectionString": "integrated security=False;encrypt=True;connection timeout=30;data source=XXX.database.windows.net;initial catalog=dbname;user id=username"

Both of these solution does not work.

"message": "The document creation or update failed because the entity name 'Server=tcp:XXX.database.windows.net,1433;Initial Catalog=XXX;Persist Security Info=False;User ID=XXX;Password=XXX;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;' has invalid characters."

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.