OK I tried to setup on both the server in same domain, still it gives me same error.

Anybody has tried to store perfmon data into remote SQL server using odbc (and sql login)?