CODEWITHSUNDEEP
c#asp.net-web-api
Oscar Dominguez Navarrete
Oscar Dominguez Navarrete

Reputation: 477

Password with special characters in connectionString

I need to connect to my Dynamics CRM 365 on premise instance from an ASP NET application. My problem is that the account for connection has a password like: T,jL4O&vc%t;30

  <connectionStrings>
    <add name="CRM365" connectionString="AuthType=AD;Url=http://crm.xxx.com/CRM365; Domain=test; Username=test; Password=T,jL4O&vc%t;30" />
  </connectionStrings>

I have the following error: vc is not defined

Please help. Thanks

Upvotes: 21

Views: 54451

Answers (2)

kapsiR
kapsiR

Reputation: 3177

In this example I see two things:

  1. A & in xml should be escaped with &amp; (Good explanation in this answer)
  2. A ; in a connection string, you should wrap the password in single quotes

So this should work for you:

<connectionStrings>
    <add name="CRM365" connectionString="AuthType=AD;Url=http://crm.xxx.com/CRM365; Domain=test; Username=test; Password='T,jL4O&amp;vc%t;30'" />
</connectionStrings>

Edit (just tried it for myself):
Additionally, another variant is to use escaped double quotes: 

<connectionStrings>
    <add name="CRM365" connectionString="AuthType=AD;Url=http://crm.xxx.com/CRM365; Domain=test; Username=test; Password=&quot;T,jL4O&amp;vc%t;30&quot;" />
</connectionStrings>

Summary:
Use either password='T,jL4O&amp;vc%t;30'; or password=&quot;T,jL4O&amp;vc%t;30&quot;;

Upvotes: 38

Ijas
Ijas

Reputation: 403

I think you can set random password for connection string. Please remove ';' from password if ';' occurs then connectionstring will interpret as password completed 

<connectionStrings>
<add name="CRM365" connectionString="AuthType=AD;Url=http://crm.xxx.com/CRM365; Domain=test; Username=test; Password=T,jL4O&vc%t30" />

Upvotes: -3

Related Questions