I got the access to the remote server.

Need to run the following proc to get authenticated on remote machine.

EXEC sp_addlinkedsrvlogin 'your linked server name', 'false', 'Login id on the local...

EXEC sp_addlinkedserver

@server='DTTAX2',

@srvproduct='',

@provider='SQLOLEDB', ...