Monday, November 23, 2009

SQL Server 2008 Express Edition

Since I'm going to be studying for an ADO.NET test soon, I figured I would need an instance of SQL Server on my home computer.

I went to Microsoft.com to download the free SQL Server 2008 Express Edition. I've used SQL Server 2005 in the past, but really haven't worked with 2008 yet.

I was presented with the following options:





I went to install "Runtime with Management Tools", since I have no need for reporting. I definitely need the runtime, and the SQL Server Management Studio that I worked with in SQL Server 2005 was pretty cool.

When I began the install process (they have a Web Installer now), I started getting an error message:





Turned out the problem was the the instance of SQL Server 2005 that was installed (probably as one of the options that I chose, though I can't recall) as part of my Visual Studio .NET 2008 Installation.

I went into Control Panel and uninstalled SQL Server 2005 Express Edition, and all of its dependencies (pretty much every program that started with the name "SQL Server"). I figured I'd uninstall the dependencies first, and finally SQL Server 2005 Express Edition last.

Turned out this was a big mistake. It basically ended up orphaning my SQL Server 2005 Express Edition, so that I couldn't fully uninstall it. So I ended up downloading and reinstalling SQL Server 2005 Express Edition SP3, and then uninstalling it.

This worked, and when I went back to install SQL Server 2008 Express, I got a new error message:





Getting closer! Just need to install VS.NET 2008 SP1.

No comments:

Post a Comment