Configuring SharePoint Server 2007 (Part: 4)

Part 4: 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 data tire server machine, then click the OK button; in this case, we’ve allocated 1000MB of memory to server, so the SQL Server memory was set to 500MB:

You should now have a fully-functional SQL Server 2005 installed inside datatire for storing SharePoint Server 2007 data.