CodersBarn.com
The ASP.NET Community Blog

SQL Server 2005 on Windows Server 2008

August 9, 2008 13:09 by agrace

I've covered the setting up of a SharePoint development machine in the past but I thought I might just add a few notes on setting it up on the new Windows Server 2008.

The main difference you'll notice is in the configuration of IIS7. You will need to enable the correct set of features before installing anthing else. You will install the tools in a specific order. The VM I built is a Workgroup machine for development and learning at home, so I can get away with using my MACHINENAME\Administrator account for everything. I am using VMWare Workstation version 6. I use NAT to access the Internet via my host machine.

SharePoint Server 2007 on IIS7

When installing SQL Server 2005, you can ignore VS 2005-related compatibility errors. However, there is one serious gotcha: you must install the KB 950636 hotfix before installing SQL Server 2005 (only applies to Web Server Edition). If you do not do this, the install will not work on Windows Server 2008. For more details, check Bill Staples' IIS blog.

I created a base VM with just the OS and latest patches. I configured IIS7 and relaxed the browser security settings. I set a maximum size for the VM to grow to dynamically and configured it in 2GB chunks. Then I defragged and ran the VMWare shrink.

At this point, I created a full clone on which I installed the following, in this order:

KB 950636
* SQL Server 2005
* SQL Server 2005 SP2
* Windows Updates
* VS 2008
* Windows Updates
* Office 2007 Enterprise
* Windows Updates

Finally, install SharePoint Server 2007 with SP1 and you should be good to go :-)

kick it on DotNetKicks.com   411ASP.NET


Comments

August 26. 2008 00:49

David Lundell, ILM MVP

Great article. Really appreciate the order of installs. Just one slight correction regarding the hotfix (950636) -- that only applies if you are using the web edition of windows server 2008, because SQL wasn't allowed to install on the web edition of windows server 2003.

David Lundell, ILM MVP

September 4. 2009 11:37

Alvaro Ramirez

I need to install SQL Server 2005 Express Edition on Windows Server 2008 Web Edition. Somebody told me it is not possible, but reading your blog I understand it is although you do not specify these particular versions. Is it possible?

Thanks

Alvaro Ramirez

September 4. 2009 12:15

agrace

It should be possible as far as I can see:

msdn.microsoft.com/.../ms143506(SQL.90).aspx

agrace

July 31. 2010 02:17

burlington low cost mls

I know this isn't exactly on topic, but I have a blog using the blogengine platform and I'm having problems with my comments displaying. Is there a setting I am forgetting? Maybe you could help me out? Thanks!

burlington low cost mls

July 31. 2010 06:51

chesapeake flat fee real estate

This is such a great resource that you are providing and you give it away for free. I love seeing websites that understand the value of providing a quality resource

chesapeake flat fee real estate

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading