Anu

Anu

  • 1.5k
  • 197
  • 8.7k

special character in connection string

Oct 14 2024 2:22 PM

Hi,

In the sql database for the login user sa, we have a password like  ab<|xy"z So in the web.config file I used ab@lt|xy&quot;z  and it works fine when debugging in the visual studio. But after deployment of the .net web application, when tried to login from the application  it started throwing error  'Login failed for user sa' . Also I tried RsaProtectedConfigurationProvider for encrypting the connection string , but gettiing the same error. Please suggest a way for getting this issue resolved


Answers (2)