Welcome to part 7 in a series of posts which describe how to create a Microsoft Office Project Server 2007 Virtual PC image for demos and development work. Last time, we looked at how to configure SQL Server 2005. This time, we’ll look at how to install SQL Server 2005 Service Pack 1 (SP1).
Part 7: Installing SQL Server 2005 SP1
Download SQL Server 2005 SP1:
Filename: SQLServer2005SP1-KB913090-x86-ENU.exe
Download URL: http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc
Copy the SQLServer2005SP1-KB913090-x86-ENU.exe file into the VPC image and execute the file:
In the Welcome dialog box, click the Next button:
In the End User License Agreement dialog box, read the license agreement very carefully, select the I accept the licensing terms and conditions checkbox, then click the Next button:
In the Feature Selection dialog box, click the Next button:
In the Authentication Mode dialog box, select All instances: Windows Authentication, then click the Next button:
In the Ready to Install dialog box, click the Install button:
If the Pending Reboot Files Found dialog box appears, click the Yes button:
If the Locked Files Found dialog box appears, click the Continue button:
If the Computer Reboot Required dialog box appears, click the OK button:
When the component installations are complete, click the Next button:
In the Installation Complete dialog box, click the Finish button:
You should now have a fully-updated SQL Server 2005 installed inside your VPC image for storing Project Server 2007 data.
In Part 8, we’ll look at how to create the accounts necessary for Project Server operation.