I wanted to post a quick FAQ to answer some of the questions surfacing around upgrading Express to SP1. This is not an "official" FAQ but just something I put together to help those who are having issues installing Express SP1.
Some definitions:
SKU:a term to describe a single Express product(ex. Visual C# Express)
RTM: The first version (i.e. non SP1) of Visual Studio Express 2008 that was released back in November 2007.
Q: Is Express SP1 a patch?
A: No, it's a major upgrade. What this means is that the Express SP1 installers uninstall and then reinstall the Express SKU. There is a minor technicality to this in that .NET 3.5 is patched to SP1 when installing Express SP1, but this should be transparent to you.
Q: Why would you want it to uninstall and reinstall? Doesn't this take longer?
A: There are number of reasons that led to us choosing this behavior, but our primary reason was that we didn't want new customers having to go through a multiple installer process just to get the latest version of Visual Studio. If you are a new user, or are just reinstalling on a clean machine, you only need to download and runthe SP1 installer and you automatically have the latest version of the product -- no need to go through Windows Update to get the patch. On an interesting side note, it actually takes longer to patch the product than it does to uninstall and then reinstall, so Express SP1 is actually faster than installing a patch.
Q: Does anything get removed when I upgrade to SP1 Express as a result of the uninstall?
A: No, with one exception for Visual Web Developerusers. Everything should remain as is from RTM when you upgrade to SP1. However, new menu items were added to Visual Web Developer Express, requiring a new settings file. On install,the new settings file overwrites the RTM settings file, resetting all settings to the SP1 default. You will then have to reconfigure your IDE settings after upgrading to SP1. Please see the readme for more information about this issue and how to backup your settings before upgrading.
Q: Isn't the regular Visual Studio SP1 a patch?
A:Yes. The higher end Visual Studio SKUs use a patch mechanism for SP1. Visual Studio Professional installationtakes much longer than Express, and patching in this case can be much quicker. Also, due to some hotfixes released for Visual Studio, a major upgrade is not possible without breaking those hotfixes, hence the decision to use a patch.
Q: I have Visual Studio Professional and Express installed on the same machine and I can't upgrade to Express SP1. Why not?
A: If you have both a paid version of Visual Studio and Visual Studio Express installed on the same machine, you must install the paid Visual Studio SP1 prior to upgrading Express to SP1. If you attempt to install Express SP1 first, you will get a blocking error asking you to upgrade the paid Visual Studio SP1.
Q: Do I need to install SP1 for each Express product that is on my computer?
A:Yes. You must download and install the appropriate SP1 for each Express product that needs to be upgraded. Also, once you upgrade one Express SKU to SP1, you must upgrade all Express SKUs to SP1 to retain functionality.
Q:Why does Help->About update the version for all Express SKUs even when I've only upgraded one of them to SP1?
A:If you have multiple Express SKUs on your computer and only upgrade one of them, the version listed under Help->About is updated for all Express products. This is a bug that we are tracking for Dev10 Express. You will still need to download and install SP1 for each Express product on your computer. In order to verify the actual version that is installed, you can open up Add/Remove Programs and see which Express SKUs have the suffix "with SP1" appended to their entry.
Q: Do I need to uninstall any Express SP1 Betas before installing?
A: You shouldn't have to explicitly uninstall the Beta versions of the Express SKUs when installing -- they should be upgraded automatically. On a few occasions there might be issues and you might want to consult the uninstall instructions for a manual removal.
Q: Do I need to reinstall Express add-ins such as XNA Game Studios or Iron Python?
A: If you have installed some of the available Express add-ins, you will most likely have to reinstall them after upgrading to SP1. I say "most likely" because on my tests XNA (the CTP version) continued to work after upgrading to SP1 but Iron Python did not and required a reinstall.
Q: I just upgraded Visual Web Developer Express and all my settings were reset. What happened?
A: As mentioned above, new menu items were added to Visual Web Developer Express, requiring a new settings file. On install,the new settings file overwrites the RTM settings file, resetting all settings to the SP1 default. You will then have to reconfigure your IDE settings after upgrading to SP1. Please see the readme for more information about this issue and how to backup your settings before upgrading.
Q: Is SQL Server 2005 Express uninstalled when I install Express with SP1?
A: No. The Express SP1 installers have no impact on SQL Server 2005 Express.
Q:Do I need to upgrade to SQL Server 2008 Express if I already have SQL Server 2005 Express installed?
A: No. Express SP1 should work just fine with SQL Server 2005 Express.
Q: Can SQL Server 2005 Express run side-by-side with SQL Server 2008 Express?
A: Technically yes, but it is not recommended. When you install SQL Server 2008 Express, the instance name .\SQLEXPRESS becomes associated with SQL Server 2008 Express. Therefore, when running Visual Studio, everything should work just as it did with SQL Server 2005 Express. You can configure them to work side-by-side by using different instance names but that is outside of the scope of this FAQ.
Q: If I upgrade from SQL Server 2005 Express to SQL Server 2008 Express, will my projects automatically be upgraded?
A: Yes. The project is automatically converted to work in SQL Server 2008 Express.
Q: Is SQL Server Management Studio available for SQL Server 2008 Express?
A: Not yet, but it will be availableshortly.
Q: I keep running into installation issues with SQL Server 2008 Express. Can you help?
A:There are a few issues that you might encounter when installing SQL Server 2008 Express through the Express SP1 installers. The readmetalks about most of these issues but here are themost common ones from my perspective:
-
User selects Restart Later and setup does not resume after restart: If you select Restart Later prior to installing SQL Server 2008 Express, the installer will not launch after reboot and SQL Express will not be installed. In order to fix this:
-
Restart your computer
-
Rerun setup which should launch in maintenance mode
-
Select "Add Optional Components
-
Add SQL Server 2008 Express and install
-
Pending Reboot: Sometimes a pending reboot can cause SQL Server 2008 Express to fail. In order to fix this:
-
Restart your computer
-
Rerun setup which should launch in maintenance mode
-
Select "Add Optional Components"
-
Add SQL Server 2008 Express and install
-
The SQLEXPRESS service is running: If you have installed a prerelease version of SQL Server 2008 Express, you must manually stop the service before installing Express SP1 or SQL Server 2008 Express will fail to install. To stop the service:
-
Go to Control Panel -> Administrative Tools -> Services and stop the "SQL Server (SQLEXPRESS)" service
-
Set the Startup Type of the service to "Manual" (This is needed because the reboot during 4.5 installer installation would cause the SQL Express serviceto start up again after reboot)
-
Reboot the machine, go back to the Services panel and verify "SQL Server (SQLEXPRESS)" service is not started.
-
Failure due to upgrade path (installing SQL Server 2008 Express ona machine with SQL Server 2005 Express with Advanced Services)
-
MSI 4.5 fails to install: If there is a pending reboot, MSI 4.5 can fail to install. Since SQL Server 2008 Express is dependent on MSI 4.5, the install will fail. In order to fix this:
-
Restart your computer
-
Rerun setup which should launch in maintenance mode
-
Select "Add Optional Components"
-
Add SQL Server 2008 Express and install
I will try and add more to this FAQ if you have any other interesting questions.
Thanks,
Wes