This should not be a problem at all. Once you reset it on the SQL server, simply go hit Edit on the Events Configuration tab under View Configuration menu. This will let you update the new password in View.
-vTimD
http://www.vtimd.com
If you found this or any other answer useful please consider the use of the Helpful or Correct buttons to award points.