We are about to use DPAPI to encrypt the connection string in our ASP.NET web config file. But I am confused between using RSA or DPAPI for our web cluster (farm). The following MSDN links clearly say that we need to use RSA provider if we want to deploy ASP.NET apps on a web farm.
http://msdn.microsoft.com/en-us/library/ms998280.aspx
http://msdn.microsoft.com/en-us/library/ms998283.aspx
But I do not understand what the issue could be with using DPAPI across all machines in my web farm. I essentially can perform the same operation on all servers and create a new "encrpyted connection string" on each machine. Why would this not work?