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

You can set Server default DB locations thrue SSMS in the Server properties, Database Settings page. For particular new database created in SSMS you can specify location in the New Database dialog, General page. The CREATE DATABASE statement has FILENAME clause for that.