Today I was going to write a blogpost about persisting the simple domainmodel using Nhibernate and Fluent Nhibernate (I will have to write this later). It turned out to be quite and adventure. First I finaly installed R# on this machine I’ve been having the license since last octobre just haven’t used it yet on this or any other machine. That installation was pretty painless I must say.
Then I needed to install some kind of database. And I like shiny and new so I installed (or wanted to install) SQL server express 2008 on my Windows XP SP2 which is fully supported on this OS. It turned out to be a 5 hour plus ordeal and installing one program after the other. But lets not forget it’s free. So I’m not complaining just venting. First thing it said (well after a couple of minutes of unzipping it’s install files in some guid folder) was that I needed the 3.5 SP1 framework. Silly me only had 3.5. So I did that and restarted. At that moment I lost my first version of the blogpost. My bad. I only copied it to the clipboard.
Then I tried to install SQL Server Express again. And after deflating the files again in another GUID folder. It told me I should install Windows installer 4.5. Which of course I did.
Another restart later. I doubleclicked the SQL Server Express 2008 installer again and this time it actually started installing (I wonder what happened to the just_install_and_stop_nagging_me_button, I really miss that button). But no such luck. After the second next it said I had to install powershell for windows and the buttons back and next were disabled so after installing Powershell I had to restart the SQL Server 2008 Express edition again. And It was happy now. So I clicked the Third next button and now it complained that I had the wrong version of Visual Studio 2008. I needed SP1 for that too. So I installed that in two goes.
But not there yet. I got this errormessage.
TITLE: Microsoft SQL Server 2008 Setup
The following error has occurred:
The Windows Installer service cannot update the system file c:WINDOWSsystem32msxml6r.dll because the file is protected by Windows. You may need to update your operating system for this program to work correctly.
Which led me to this page
SQL Server Native Client
A network error occurred while attempting to read from the file ‘%.*ls’.
An attempt was made to install (or update) SQL Server Native Client on a computer where SQL Server Native Client is already installed, and where the existing installation was from an MSI file that was not named sqlncli.msi.
To resolve this error, uninstall the existing version of SQL Server Native Client. To prevent this error, do not install SQL Server Native Client from an MSI file that is not named sqlncli.msi.
Seriously. Are they trying to be funny? Would I ever install something that doesn’t have the name sqlncli.msi? I don’t think so.
So I uninstelled the two native clients on my machine and tried to install again. And finaly it worked
So after all this I have SQL server Express 2008 on my machine. What an adventure.
Now back to our regular program.