?
Solved

SQL 2005 and 2008 side-by-side with Server Managerment Studio Express

Posted on 2011-02-21
2
Medium Priority
?
542 Views
Last Modified: 2012-05-11
Dear Experts, can you advise on this one please? My knowledge around this area is very limited. I need to have SQL 2005 express and 2008 express installed side by side working with management studio express. This is on a laptop with Windows 7.  I have been running fine with SQL 2005 and studio for a long time now.  I did the following to install 2008 express:
1. remove studio management
2 install sql 2008 express - all ok
3 re-installed studio management (version9.00.2047.00)
So far so good. If I log in to SMME it looks like it only 'see's' SQL 2005 (my original install) and says on screen: SQL2005
I'm wondring how I can get to 'see' the SQL 2008 'instance' (if that's the correct word) - at long in to SMME there is a browse function but does not seem to find anything.

Any help greatly appreciated, thanks, Rob



0
Comment
Question by:robfendergibson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
Rahul Agarwal earned 500 total points
ID: 34942609
what version the shows in SMME will it starts with 10.x.x.x or 9.x.x.x if it starts with 10.x.x.x then your SQL Server version is already upgraded to SQL Server 2008 version otherwise you need to start the SQL Server 2008 service from Services section in control panel's administrative tools.
0
 

Author Closing Comment

by:robfendergibson
ID: 34943997
Hi, yes did that thanks and all ok now, many thanks, Rob
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question