I recently installed SQL Express 2008 and ran into an annoying issue when I later tried to alter the installation.
The initial SQL install went off without a hitch, but the problems began when I tried to add my application. During the installation process, I was prompted to enable full-text indexing on my SQL server. I had no idea this was a prerequisite…shame on me for not reading the application requirements! To add insult to injury, I was not aware that version of SQL Express I was using did not come with full-text indexing as an installable option.
Back to the Internet I went, searching for a copy of SQL Server 2008 Express with Advanced Services. A 500 MB download later, and I was well on my way to getting things running, or so I thought.
I began my SQL installation, choosing to add or change features to my existing install. Everything seemed to be pretty straightforward and painless until I tried to select which SQL installation to upgrade. Each and every time I tried to select the one and only instance on this particular server, I was greeted with the message, “The instance id is required but it is missing”.
I double-checked the installation options I had selected, I ensured that all of the proper services were up and running, plus I even rebooted the server and tried the installation again. However, no matter what I tried, I received the same error each time I attempted to select my SQL instance.
I poked around for awhile, then finally found a solution. First, I went to the Control Panel and selected the Add/Remove Programs console. There, I located the SQL express install and clicked the Change/Remove button. This brought up a slightly different version of the installer interface, from which I could choose an Add option.
Going through the paces, this installer found my existing SQL instance without any issues and I had my SQL Server, complete with full-text indexing in no time!