SQL Server 2005 and SQL Server Express 2008 installed on same server

I currently have a situation were I need to install SQL Server Express 2008 on a server that already has SQL Server 2005 installed on it. Please can you advise if this is recommended and what are the best practices for such an install.

Thanks in advance for you're assistance
LVL 1
MartynLawsonAsked:
Who is Participating?
 
Imran Javed ZiaConnect With a Mentor Consultant Software Engineer - .NET ArchitectCommented:
Hi,

You can do side by side install SQL Server 2008 and 2005. No consequence of installing both. It really depends on what you want.
for more information please review the following:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/b4e6ef94-40ef-4c96-b4e7-e91f7dfca690 

Thanks
0
 
x-menConnect With a Mentor IT super heroCommented:
there can be only one default instance per server, you'll have to install a named instance, other limitations are edition wise.
0
 
kamindaConnect With a Mentor Commented:
There is no issue of running SQL Server 2005 side by side with 2008. I use 2005, 2008 and R2 on the same box in my laptop. Is this a prduction server? Then you have to consider the resource allocation as there can be perfomance issues you will run into.
0
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
Its' not an issue.
0
 
MartynLawsonAuthor Commented:
Thanks for all your comments. I've successfully installed the SQL 2008 on the server.
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.

All Courses

From novice to tech pro — start learning today.