Another great use for CONTEXT_INFO is auditing actions. Most web/windows applications create a helper class that manages opening a connection to the database. You can augment...
I also came across this cryptic issue whereas when "Configure Report Server", the Database Setup Task would fail on "Setting Connection Info for Reporting Server". I reset the Credentials...