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.
This might not be a sure shot solution but it worked for me.