Add SQLServer to the VPC

Today I add the next section in my series to create a SharePoint VPC. In this blogitem we add SQLServer to the VPC to make it run as a database server.

Run SQL Server Setup from your installation media.

Accept the User License Agreement and click Next to continue

Click Install to install the Prerequisites.

After the Prerequisites are installed click Next to continue.

The system is checked for its configuration.

Click Next to continue on the Welcome screen.

Click Next to continue.

Enter name and company and click Next to continue.

I installed all services except for teh Integration Services. If you think you will be needing the Integration Services later on add this checkbox. Click Next to continue or Advanced for more options.

One think I prefer to do is adding the complete documentation and sample databases. This may bloat your VPC but can be very useful if you are going to develop some projects on the VPC providing you the available documentation. Click Next to continue.

Click Next to continue to create the default instance.

Next you enter the user information from the SQLSVC account you created earlier in one of the previous steps. Click Next to continue

Select Windows Authentication Mode and click Next to continue.

Leave the collation settings to default and click Next to continue.

Select Install the default configuration and click Details to show the details.

Click Close to continue.

In the VPC for performance reasons deselect both checkboxes and click Next to continue.

Click Install to continue on the Ready to Install dialog.

Click Next to continue when the Setup Progress dialog is completed.

Done, you can check the summary log and click Finish to continue.

Your VPC is now prepared to be used as database server. In the next two steps we will configure SQL Server and install SQLServer SP2.

To be continued...