Sql-server – a SQL Server instance

After continuing to dig around I finally found an article in MSDN that covers installing advanced services without installing SQL Server. That got me pointed in the right direction:

The Crux of my mistake is that I thought of this as 'adding a feature to an existing instance of SQL Server 2008.' Therein lies my flaw. In the install process there is an option for 'Installation Type.' What I should have marked was 'perform a new installation of SQL Server 2008.' (even though I already have 2008 Express installed)

Then when I get to the section with the License Terms I had to select my key, ctrl+x to cut it out the license key (it was correct), then ctrl+p to paste it back, THEN click next. Otherwise I would get the Express install, not the regular install. Apparently an 'on key' or 'on click' event was not being properly captured.

At that point I could add SQL Server (non express) features to my laptop. The most important check box for SSIS is 'Integration Services'

It appears that there are a few things that are confusing in the wording and a few things buggy in the tool flow.

Check if your SQL Server Express service is running and start it if necessary. Then try to connect to server .\SQLEXPRESS with Windows Authentication.