I think I found the issue (not the solution)

odbc does not store sql login information (UID & PWD), and user needs to supply uid and pwd while using the odbc.

Only windows authentication works when PerfMon uses odbc to store data in SQL server

I think I cannot send Perfmon data to a different domain sql server since I cannot use windows authentication in this case.

I need to find out some workaround