Solved

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

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

861 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now