How to escape a semicolon in a password in an Azure Release pipeline variable

Question

I have a blazor web application that accesses an SQL Server database. The connection string is stored in an Azure Devops Release pipeline variable. As the password contains a semicolon, I get an error "Format of the initialization string does not conform to specification..." I know that the problem should be resolved by using single quotation marks around the password, and this would work if e.g. I had the connection string in a config file. But as it is in the variable, the login just fails, as the quotation marks are probably seen as parts of the password. I don't use YAML definition. The connection string has the following format:

Data Source=23.123.34.121;Initial Catalog=DBNAME;UID=Username;Password=Pass;word;Connect Timeout=15;MultipleActiveResultSets=true;

I tried using double-quotes, or two single quotes. Nothing helps.
Is there any way to make it work?

Answer 1

Thanks! Since your query is more inclined towards Azure DevOps suggest you to post your query here for experts answer: https://developercommunity.visualstudio.com/VisualStudio