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
Post a Comment