During install it will allow you to set the database name but not the server in standalone mode. However the database is installed on the local sql server. See the following article for details:
The database instance is using the microsoft internal database server on the same server but its hidden. This article shows you how to unhide it so you can manipulate it.
If you have any tips, tricks, recommendations, warnings please email them to firstname.lastname@example.org and I will post them on this blog.
Are you a .NET Developer or Contractor interested in working with Sitecore or Dynamics CRM?
Apply for our Mentorship Program. If accepted, we will mentor you on Sitecore and provide you with project to help you build your skills and make some money at the same time. If you are interested send your resume with details on why you want to work with Sitecore or Dynamics CRM to: Chris Williams - email@example.com or Dennis Augustine - firstname.lastname@example.org We look forward to working with you to achieve your goals.