special character in connection string

Anu

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"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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul1y ago
Accepted answer
This is the infamous "Login failed for user sa" error!

URL encode the password before placing it in the web.config file
```
    
```
Tuhin Paul1y ago
This is due to the password encoding/escaping differences between Visual Studio debugging and the deployed environment.

Instead of using ab@lt|xy"z, try using the actual password ab<|xy"z and let .NET handle the encoding.