Finally got it.I changed connection manager from sql authentication to windows authentication and gave the user admin roles.Did use any configurations now.Thanks all for the help.

Thanks,

Mahesh