First of all, it’s really stupid I have to write a blog post on how to install the free Microsoft SQL express package, but it just isn’t that easy to do. It’s nice they give it away for free for people like me to learn it all, but they assume you already know it in the limited instructions you are given. The big problem is, there are a ton of pre-requisites that — if not already installed, will fail the installation and leave your install in a bad shape. For example…. this lovely error:
An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package ’sqlncli.msi’
10 Step Install
All of this assumes a fresh install of Windows XP in a virtual machine with one gig RAM allocated to it.
- Do it inside a virtual machine and snapshot it before the install so if it fails, you can start over easily.
- Go into Add/Remove programs, Windows Components, check IIS, install it
- Install .NET Framework 3.5 – I just went into Windows Update, optional installs, and it was listed there.
- Go to Windows Download page, search for MSXML 6.0 and install it
- Google “ms sql express download” and pick the appropriate link from Microsoft’s site. When I did it I went to: http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx
- Click the link for 2005 express download. That took me to http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx
- Do NOT install the Advanced Services option. I had errors doing that.
- Download and install SQL Server Express (sqlexpr32.exe), take all defaults.
- Download and install SQL Server Management Studio Express
Hopefully that will do it. The SQL Server Management Studio program will be in the program menu. I’ll write more blog entries as I figure it out myself.