Creating a development workstation for MOSS 2007 – Win 2008 R2, SqlServer 2008
Monday, 9 November 2009
Starting working on a new mission with MOSS 2007, I’ve setup a new development workstation.
I wanted to start with the latest products available at Redmond:
- Windows Server 2008 R2
- Sql Server 2008
- Visual Studio 2008
- Moss 2007 & Office 2007
with everything in 64 bits.
I thought it would be a no brainer, but it seems that Windows Server 2008 R2 broke a lot of backward compatibility, and that I needed to apply service packs to every product I wanted to install. Here is the process I’ve followed.
Install Windows Server 2008 R2
Nothing special here – you can even download a full evaluation version (for 180 days).
I’ve then followed the instructions here to transform this server os to a fully functional workstation os, including Windows 7 look & feel.
I then installed Office 2007.
Install Visual Studio 2008
The Visual Studio 2008 installer had an error saying that .Net 3.5 SP1 must be installed via the server roles. In fact you have to use the role “Application Server” :
- open Server Manager
- Roles –> Add new role –> application server, then add .Net 3.5 SP1
- I also added Web Server role to install IIS
After a restart, everything was fine and Visual Studio 2008 was installed perfectly.
In order to install Sql Server 2008, Visual Studio 2008 SP1 is needed (otherwise Sql Server setup will prompt for an error). Download and install it from here.
Install Sql Server 2008
When I tried to install SqlServer 2008, I was prompted with a compatibility alert. It appeared that I needed to install SqlServer 2008 SP1. To do so:
- download Sql Server 2008 SP1
- install SP1 first – YES, apply the patch before the product! In fact it places files that will be used by the installer later
- install Sql Server 2008
- install SP1 again – this time it will apply the patch successfully
Install Moss 2007
Again, when I tried to install MOSS 2007 i was prompted with a compatibility alert.
To install MOSS 2007 on Windows Server 2008, 2 services packs are needed:
- Windows SharePoint Services 3.0 Service Pack 2 (SP2)
- The 2007 Microsoft Office Servers Service Pack 2
Following the guides found here and here, I’ve extracted the services packs in the Updates directory (creating a “slipstreamed” install), and Shazam, everything installed smoothly.
Remember to select the “Complete” installation, not the Stand-Alone one, if you want to use SqlServer 2008 as the sharepoint database.
