Do not attach databases, except in dev - it's a special mode for dev only that does not exist in the full version of SQL (for very good reasons). You should ensure that production DB's are managed and controlled by SQL, which means it will store it where it wants.
You can also use this:
Simple SQL Connection String Creation[
^] to generate a connection string for you.