It's unclear whether you're trying to have multiple environments on a single server or separate servers for each environment. Best practice is to have separate servers for each.
If you have your environments on separate servers, you can set up ODBC DSN's on the servers that have the exact same name but point to the database for that environment. This makes it MUCH easier to move reports between environments using the Import Wizard because you don't have to manually change the Database Configuration after importing.
When you upload a report via the CMC or update it through Crystal, you should ALWAYS go to the properties of the report and check the Database Configuration to make sure that it's pointing to the correct connection. Also, if you're not using integrated security on your database, updating reports through Crystal will remove any password that has been set up in the configuration, so this is the only way to make sure that the password gets reset.
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.