Escaping = in a sql connection string

Viewed 2233

I have a SQL Server 2016 connection string like the following:

<instance name="ConnectionString" value="Data Source=database1;Initial Catalog=Nis_Dashboard;Persist Security Info=True;User ID=mysqlacct;Password=cPrVRY=whYix;" />

My issue is that (as you can see above), there is a '=' in the password. I believe this is causing connection string to break. Is there a way that I can escape the '='? I tried using '==' and '\=' but that didn't seem to work.

0 Answers
Related