|
We are documenting herewith our own esperiences installing and/or upgrading SQL Server Express instances in various
flavours.
Notice:
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft Corporation is not responsible for the information herewith provided
and therefore disclaims all warranties, whether express implied or statutory,
fitness for particular purpose, title and non-infringement.
All logos, name, images, are to be considered property/copyright/trademark of
the respective holders.
Installing SQLExpress 2005 and SQLExpress 2008 side by side
Current goal: having an existing SQLExpress 2005 instance running side by side with a new SQLExpress 2008 instance we are going to install.
In order to have the initial scenario set, we have to install an instance of SQLExpress 2005 and relative management tool, and the achieved and desired initial schema is reassumed as
We proceed further executing the SQL Server 2008 with Tools setup application adding an new instance.
Soon after the traditional consistency checks and support file installation, we define to install both the relational database engine and the new management tool
The setup application recognize the current installed SQLExpress 2005 instance and SQL Server Management Studio Express 2005, and we here provide the instance name for the new installation
We use the same rules regarding security context, collation, mixedm mode authentication, file system directories, Filestream settings as in the previous installation samples.
Execution is stopped as SQL Server Management Studio Express and SQL Server Management Studio Basic 2008 can not be installed (and used) in side by side mode, and it can not be even directly upgraded to the 2008 flavour;
it actually is not the full fledged SQL Server Management Studio 2005, just a sort of hybrid (please see Mike Wachal, SQLExpress PM, answer in Microsof public forums) and we have to manually uninstall it before proceeding.
Having it manually uninstalled, we are allowed to perform our succesfull installation that we can later check with our traditional trivial methods, live application level
installed application level
available services level
and file system level
SQL Server Configuration Manager allows us to manage both version of services
and so does SQL Server Management Studio Basic
Navigation
Summary and foreword.
Installing SQLExpress and SQL Server Management Studio
SQL Server Management Studio Basic
Installing a SQLExpress named instance
Installing a SQLExpress default instance
Installing a SQLExpress 2005 and SQLExpress 2008 side by side
Upgrading an existing SQLExpress 2005 with Advanced Services instance to SQLExpress 2008 with Advanced Services
Uninstalling an existing SQLExpress 2008 instance
Related:Consuming the SQL Express 2008 Installation Package wrapper.
Installing SQL Server Management Studio Express.
Installing SQL Server 2008 service pack 1 on SQL Server Express 2008.
Installing additional features to a SQL Server instance already updated to service pack 1.
Upgrading SQLExpress 2008 to SQLExpress 2008 R2.
Installing SQLExpress 2008 R2 with Advanced Services and related tools.
|
