>Is there a place to indicate where we would like the database to be stored?

In SSMS you can set the location from the 'General' page if the New Database form. I think the other managers are similar.
HTH,
Viv