Thanks a lot the issue is resolved now. Dropping an recreating worked. It looks like its a sure mismatch of SID.

Now i have another issue.

SQLCMD is having Access denied error.

when i execute the SQLCMD using my credential, it works fine. but whjen i put the same command in a SQL job and run it, it fails with Access denied error.

can you please comment ton this as well?