Any idea of the sql statement to update the password? the ICM is anyway running MSQL 2005
That's not a good idea. All ICM integrators and admin users should understand the basics of how configuration changes are made in ICM. This is a complex path in order to ensure that the key component, the duplexed Call Router has changed the in-memory copy of the configuration. Changing the database (which one were you thinking of - Logger, AW?) using SQL Query Analyzer or any other native method is more than likely to totally mess up your system.
Study this diagram (from the 8.0 Serviceability Guide)
These are the paths to get to each CCX logs through CLI. They may be helpful if you are having issues accessing RTMT or downloading logs through it.
If you want to download them you have to prefix "file get " and you can add one of the options (re...