Yes it is working. Thanks a lot Leeland!

For linked server provider "MSDASQL" I have enabled only "Allow Inprocess" and it is working fine.... I wanted to check with you which ones you have enabled?

Thanks!