Solved

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

Posted on 2011-02-21
2
538 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:
agarwalrahul earned 125 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

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.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

710 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