Solved

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

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

758 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

14 Experts available now in Live!

Get 1:1 Help Now