[FAQ]Encrypting SQL Server Connections in web.config

Author
APGvNext Sam
vNext Dev
  • Total Posts : 13240
  • Joined: 2001/05/23 00:00:00
  • Status: offline
2009/07/28 12:36:13 (permalink) Setup
0

Encrypting SQL Server Connections in web.config

If you wish to encrypt your connection string inside web.config, it is easy provided you are running in Full trust environment + Your AppPool identity is NOT Network Service (Network Service account doesn't have the ability to save config files).

Note: Most shared hosting environments are in Medium trust mode and therefore the files in this article won't work.

Step-by-step:
  1. Download the zip archive below, extract, and upload both files to your forum's root (~/);
  2. Browse to the page using your browser, and you will see if your connection is protected;
    1. if you see an error while loading this page, it means you are not running in Full Trust environment
  3. If not, click the "Toggle Encryption" button to encrypt your connection string;
  4. You will see whether your connection string is successfully encrypted right after you click the button.
Done!
connectionString

post edited by Samuel - 2013/02/01 17:19:46
#1

0 Replies Related Threads

    Jump to:
    © 2021 APG vNext Commercial Version 5.5