Configure SQL Server to be used in the VPC

Today I add the next section in my series to create a SharePoint VPC. In this blogitem we configure SQLServer to be used in the VPC to make it run smoothly as can be.

In the SQL Server 2005 Surface Area Configuration Dialog click the Surface Area Configuration for Services and Connections link

Select Service from the tree on you left hand and make sure the Startup type is set to Automatic. Click Apply.

Next select Remote Connections and configure that to be Local and remote using TCP/IP and named pipes as we may need both in future. Click OK.

You will get the notification that your changes only will take effect until you restart you Database Engine service. Hit the button to remove the dialog.

Progress....

Connect to the server using Windows Authentication.

Right click the server node and select Properties from the context menu.

Select the Memory page to change the amount of server memory.

Change the amount of memory to half the amount of memory you used for your VPC and click OK.

Your SQL Server is now configured for using in your VPC. In the next step we will install SQL Server SP2.

To be continued...