I figured out the problem. It is due to the service account is present in the "Deny logon locally" Group.

After exploring the possibilities of achieving it through excel, we decided to go for SSRS where this functinality can be achieved very easilty.

Thanks.