Virtual Machine Preparation Note: Microsoft virtual machine file extensions are used here, but this does not mean you need to use Microsoft Virtual Server. You can in fact, use any virtual machine technology. Microsoft extensions are only used as examples here. In addition, a 32-bit installation is discussed here, but you can use this same procedure to create a 64-bit virtual appliance.
1. Begin by preparing a new virtual machine running Windows Server 2003 R2, Enterprise Edition. Make sure it is up to date in terms of software updates. You should also install Internet Explorer 7 since it is the latest version of the browser. In addition, this machine should have the following characteristics:
2. Once the new disks have been made, attach them to the new virtual machines your virtual machine management console.
3. Launch SQLSource, personalize it and configure the network card.
4. Keep the machine in a workgroup in order to make it transportable from one environment to another.
5. Launch Computer Management and go to Disk Manager. Create the signature on the two new disks but do not convert them. Both disks should be Basic disks. Format both disks with NTFS and give them the following properties:
a. 100 GB Disk Name: Data
b. 100 GB Disk Letter: D
c. 25 GB Disk Name: Logs
d. 25 GB Disk Letter: E
6. Add two disks to the machine and create the D:SQLData and the E:SQLLogs folders.
7. If you will be installing SQL Server Reporting tools, then you must install Internet Information Services (IIS) on the server. Use the default settings and include ASP.NET.