I have a replication on between two remote servers. And because of the size of the tables, I need to have an alternative to using the insert (default) when applying a FULL-REFRESH. That alternative is specifying the LOADXIT parameter.
I´ve set the password file for the remote server, and when I run the ASNAPPLY and it calls the ASNLOAD, I get an error:
SQL1403 The username and/or password supplied is incorrect
This is when the ASNLOAD tries to get the remote Database Configuration without performing an Attach to the instance explicitly. But the user names and password from both servers match, and it seems that the remote server recognizes the remote connection as a different user. Do I need to have a distribution protocol such as LDAP configured?? or Can I do this using a normal NODE configuration and just changing the LOAD program?