encrypt SQL connectionstring c# -


i created c# application (not asp webpage) connects sql 2005 server. in sourcecode password , userid sql-server coded plain text in connectionstring.

sqlconnection con = new sqlconnection(); con.connectionstring =           "data source=server1;"+          "initial catalog=mydatabase;"+          "integrated security=no;"+          "user id=admin;password=mypassword;"; con.open(); 

is there easy way encrypt password or whole connectionstring, other peoples disassemble tool not able see password?

thanks

you should store connection string in config file , encrypt section. see http://www.4guysfromrolla.com/articles/021506-1.aspx or http://msdn.microsoft.com/en-us/library/89211k9b%28vs.80%29.aspx.


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

node.js - How to abort query on demand using Neo4j drivers -