How to install Office Sharepoint Server 2007 on a member server By Mariette Knap Office Sharepoint Server 2007, member server On a default SBS 2003 installation you will get Windows Sharepoint Services 2.0 for free. In this document we will install a Windows 2003 R2 member server and on that server we will install Office Sharepoint Server 2007. This is effectively a 'standalone' installation of Sharepoint Server 2007 and therefor not an installation in a web farm. Table of contents How to install Office Sharepoint Server 2007 on a member server Create a computer account and join the server to the SBS network Configure the server as a Web server Install and configure the Microsoft .NET Framework version 3.0 Configure IIS 6.0 Install and configure Office SharePoint Server 2007 with Microsoft SQL Server 2005 Express Edition This document assumes that you already have installed the Windows 2003 member. We will join this server to the excisting SBS lan and make it a web server that will hold Sharepoint Server 2007. Create a computer account and join the server to the SBS network From the start menu start the SBS Server Manager. Click on the hive 'Server Computers' and then click on the right side of the window on 'Set Up Server Computers'. Click 'Next'. Fill in a name for your new member server. We set our member server to a static IP address. The address we use is within the default exclusions in the DHCP settings. If you want to use another IP address you must make sure it is excluded from the scope of your DHCP server. Click 'Next'. The wizard is ready. Click 'Finish' to exit the wizard. Finally the wizard show you the URL you should use to join the member server to the SBS domain. Click 'OK' to close the window. On the member server start Internet Explorer. In the address bar type the address as it was given to you when you run the Add Server wizard on the SBS 2003 server. Click 'Connect to the network now'. Fill in the Administrator and password from the admin account on your SBS and click 'Next'. There is the server listed that we previously added with the 'Add Server wizard' on the SBS. Highlight the 'SHAREPOINT' server and click 'Next'. Click 'Finish'. Let it run and it will automatically boot your member server several times. Configure the server as a Web server We assume that you already have installed a Windows 2003 server. This server is not yet joined to the domain, we do that later. A default installation of Windows 2003 Server does not include that IIS is installed so that needs to be added. Start add/remove programs from the Control Panel. If it is not already started please start 'Manage your server' from the Start menu. Choose 'Add or remove a role'. Click 'Next'. Select 'Application server' and click 'Next'. Select 'Enable ASP.Net' and click 'Next'. A summary is presented, click 'Next'. Click 'Next'. Setup is working... Click 'Finish'. You are now back in the main 'Manage Your Server' window and as you can see my server has the 'Application server' role added. Install and configure the Microsoft .NET Framework version 3.0 If .Net 2.0 is not installed already you need install that before installing .Net 3.0. Microsoft .Net 2.0 can found on your installation media of Windows 2003 server or you can download it here. You can check Add/Remove programs to see if .Net 2.0 is installed. Download Microsoft .Net Framework version 3.0 here. The .NET Framework version 3.0 download contains the Windows Workflow Foundation technology, which is required by workflow features. Install .Net 3.0 from the download. Choose your options and click 'Next'. The installer runs in the background but we can click in the cloud to activate the details. The installer is working... It may seems a bit confusing but during the installation the installer will try to connect to the internet and download updates. Just ignore that and let the installer run. It may take awhile before it is completed. The installer is finished, click Exit. Configure IIS 6.0 You need to check if .Net 2.0 is enabled in the Web Service Extensions in IIS manager. Start IIS Manager from the Administrative tools in the Start Menu. If it is set to 'Prohibited' you need to click on the button 'Allow'. It does not prompt that it was successful but the result should be like in the below screen shot. Install and configure Office SharePoint Server 2007 with Microsoft SQL Server 2005 Express Edition Insert your Office Sharepoint Server 2007 CD and enter your product key. Once you have entered the product key it will be automatically validated and if it is correct you can click 'Continue'. Accept the Terms and click Continue. On our server we choose 'Basic' as our installation routine. This means all components will be installed on this server and it will use a SQL Server Express database. Remember that a SQL Server Express database is limited to one CPU, one gigabyte (GB) memory limit for the buffer pool and databases have a 4 GB maximum size. You cannot convert a Basic installation to an Advanced installation. If you have already installed a SQL 2005 instance somewhere else on your network and you want to use that instance you MUST choose 'Advanced' but that subject is not included in this article. For now click 'Basic'. The installer has started. Get some coffee and relax! Click 'Close'. The Configuration wizard will now start. The configuration wizard is started, click 'Next'. The installed warns you that some services need to be restarted. Click 'Yes' to accept this. As you see during the time that wizard runs it configure the 'Configuration database'. If you ever need to reinstall Sharepoint it will fail if it sees an old Configuration Database. A solution is to uninstall the old SQL Express instance and create a blank new instance but you can also run 'psconfig -cmd configdb -create -database '. The installer is finished and gives us some important information we should read and use when we browse to our Sharepoint site for the first time. Click 'Finish'.