ADF import ARM templates connection string failure
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."