Do I need to create the database beforehand?
No. If you select Microsoft SQL Server Express, the database will be added automatically. If you select Microsoft SQL Server, the database user should have permissions to create a database or you would need to create the database manually.
What if I check Windows Authentication for SQL Server connection?
You need to make sure that the account that runs the ASPNET process has the appropriate permissions to the database.