Welcome to part 6 in a series of posts which describe how to create a Microsoft Office SharePoint Server 2007 (MOSS 2007) Virtual PC image for demos and development work. Last time, we looked at how to install SQL Server 2005 inside our VPC image. This time, we’ll look at how to configure SQL Server 2005 inside the virtual machine for storing our MOSS 2007 data.
Part 6: Configuring SQL Server 2005
Select Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration:
On the SQL Server 2005 Surface Area Configuration screen, click the Surface Area Configuration for Services and Connections link:
In the left pane, expand MSSQLSERVER, expand Database Engine, then select Remote Connections:
In the right pane, select the Local and remote connections option, select the Using TCP/IP and named pipes option, then click the Apply button:
In the Connection Settings Change Alert dialog box, click the OK button:
Click the OK button to close the SQL Server 2005 Surface Area Configuration screen:
Select Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio:
In the Connect to Server dialog box, leave the default settings and click the Connect button:
In the Microsoft SQL Server Management Studio window, right-click on the server name in the left pane, then select Properties:
In the Server Properties dialog box, select Memory in the left pane:
In the right pane, adjust the Maximum server memory to a value which is half of the memory allocated to your virtual machine, then click the OK button; in this case, we’ve allocated 1000MB of memory to the virtual machine, so the SQL Server memory was set to 500MB:
You should now have a fully-functional SQL Server 2005 installed inside your VPC image for storing MOSS data.
In Part 7, we’ll look at how to install SQL Server 2005 Service Pack 1 (SP1).