SAP BW DB Connect Datasource

Hi Experts,

How does DB Connect datasource with different db User Names in each Dev, Qa, Prd be handled during transport movement.

Ex: I have BW Dev Connected to DB connect X Dev, BW QA is connected to DB Connect X Prd with different user and password..now after maintaning source system change after transport in BW Qa, my transport still fails in BW Qa with transformation with BD Connect X Dev not assigned..Is there any anything I need to consider for the different user name password.

Thanks,

Siv