I recently rebuilt my Windows Vista Home Premium laptop with Windows 7 Ultimate; I also went from 32-bit to 64-bit. I'm trying to rebuild my web development interface, which means I'm trying to install SQL Server Express 2005 and SQL Server Management Studio Express 2005, which I've been using on Vista.
The Windows 7 answer site suggested I needed SP3, so I downloaded the SP3 installer (the EXE); but I get the same errors I got with the unpatched version:
It complains that only 64-bit ASP.Net is registered and it needs 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit). (I tried downloading and installing a 32-bit ASP.Net package and the installer wouldn't even run. A compatibility check said, not compatible.)
It complains that it can't find the installation package for Microsoft SQL Server Native Client and says to try again with the installation package sqlncli_x64.msi. (I can't find such a file on my disk.)
Actually with SP3 I got a new error: SQL Server Database Services install failed. It refers me to the setup log for detail but when I click on the link nothing comes up. I searched the log directory for the string "database services" and found nothing usable.
When the install says it's complete, I have no Surface Area configuration tool in my start menu, and Management Studio Express can't find a local database server to connect to.
Is this a known problem with SQL Server Express 2005 and 64 bit Windows 7? What should I be doing that I'm not?
Nature bats last.