Encrypt/Decrypt Sitecore Connection Strings

It's always good practice to encrypt connection strings for your Sitecore instance to keep safe from anonymous 😇 .
Since encryption and decryption are specific to each server, so we require to run encryption on every IIS server.
Like for CD server sometimes we require to encrypt Connection strings.

So let's start demo:
firstly open command prompt as administrator and run below command

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -pef "connectionStrings" "C:\websites\sxapoc\Website"

       that's it. Now check your connection string for selected Sitecore instance
it will look like this

now to decrypt run below command

         C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -pdf "connectionStrings" "C:\websites\sxapoc\Website"

@Note: Maybe the path will differ based on OS
either C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe
or C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe


Happy Sitecore !!!

Sitecore File Explorer access ?

Wanted to access files of sitecore instance, but not able to access physical files because that instance hosted on another Server/System?

Wanted to deploy files (includes: views/assets/dll/configs) on QA/UAT and you have access of Sitecore Instance CMS only?

Wanted to download for comparing files or upload your own files on QA/UAT quickly?

So these all you can do with Sitecore existing feature, where you can access file explorer via Instance URL:

instancename/sitecore/shell/default.aspx?xmlcontrol=FileExplorer