Solved

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

Posted on 2011-02-21
2
530 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
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

809 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