Microsoft SQL Server is required to host the App-V Management and Reporting databases. With the exception of very large deployments of App-V, SQL server can be collocated on the App-V Management Server (and on the Publishing server as well).
This recipe assumes that you have provisioned and domain-joined a server with the name APPV1, and that you have a valid licence to install Microsoft SQL Server 2008, 2008 R2, or 2012 at the Standard, Enterprise, Datacenter, or Developer Edition levels. Note that the Express edition is not supported.
Here are the fundamental steps involved in this recipe: