On doing that system prompted me that my domain password has expired and must be changed.
So I changed the password and then when I ran the report in AX again it executed successfully.
So in this case, the domain password was expired which resulted in SSSR report execution error.
To turn on the ability to restore previous version of files
This might not be a sure shot solution but it worked for me.