• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

Can I install a new instance of SQL Server 2008 Express on a machine that is already running an existing instance of SQL Server 2005 Express?

The server at work is running an instance of SQL Server 2005 Express and I want to build a new database on it using SQL Server 2008 Express. Can I have both running or will the different versions cause a conflct? The server is running Windows 2003 Business Server operating system
0
Rob4077
Asked:
Rob4077
1 Solution
 
wolfman007Commented:
Although you should have no problem running a 2005 instance of the database engine beside a 2008 instance, The tools are installed into a shared directory, so you can't have two versions of the tools installed. Fortunately, the 2008 tools are backwards-compatible.

Before installing the 2008 tools, you need to remove any and all "shared" components from 2005. Try going to your Add/Remove programs control panel, find Microsoft SQL Server 2005, and click "Change." Then choose "Workstation Components" and remove everything there (this will not remove your database engine).

I believe the 2008 installer also has an option to upgrade shared components only.

http://stackoverflow.com/questions/175881/sql-server-express-2008-install-side-by-side-w-sql-2005-express-fails
0
 
RiteshShahCommented:
I think there shouldn't be any problem if you are installing named instance of SQL 2008 express edition. Link provided by wolfman007 is good, worth to refer.
0
 
Rob4077Author Commented:
Thanks for the comments and tips. Appreciate the link too wolfman007
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now