when running KPI they clicked on the report button and it would get the following error. MICROSOFT[ODBC SQL SERVER DRIVER]TimeoutExpired.
this turned out to be casued by trend micro PCC 2006 the real time scan settings were set to block script viruses. uncheck that works fine.