trusted connection of membership\roles providers

lkeel · Post by **lkeel** » Mon 19 May 2008 17:21

I am trying to figure out the connection string to allow the asp.net membership\role providers connect using a trusted connection without having to supply a password. The problem is that my client will not allow and unencrypted password in the config file, so instead we have done trusted connection between the web server and the db server only for the tables that are needed. But when I do this, I get this error: 'password authentication failed for user....'. I have set the connection to be trusted for this login, but that doesn't seem to matter. Any help is appreciated.

Thanks,
Lee

Alexey.mdr · Post by **Alexey.mdr** » Wed 21 May 2008 08:57

Hello Lee,

If I'm correct you are still able to encrypt the connection strings section in the web.config.
If this is correct there's no need to establish a trusted connection (for the mentioned purpose) at all.
If you cannot encrypt the part of web.config please specify in details what do you mean by a trusted connection.
Hope this helps