There is no true active/active for SQL. You have one instance on one node, and another instance on the other. They're essentially two separate servers, so change the password on both as you would any normal server.