Solved

SQL Server 2008 Management Studio 2005 and 2008 on Same machine

Posted on 2011-02-24
4
703 Views
Last Modified: 2012-05-11
Hi I have installed SQL Server 2005 and mgt studio with that.

I need to administrate a machine that;s running SQL Server 2008. Can I install 2008 alongside all my 2005 stuff?

I downloaded the full SQL Server 2008 R2 file and tried to find somewhere in the installation package where I could select just the Management features but can't find it.

I've been at this for hours. Please help me!
TIA
0
Comment
Question by:billymcss
[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
4 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 500 total points
ID: 34971872
you should install the SQL Server 2008 Management Studio 2008 if you want to manage an instance running sql server 2008. You could not connect to an 2008 inststance with the SQL Server 2008 Management Studio 2005... You just need to installl tghe magament tools.
0
 
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 34971957

Run the installation, you will get to a point where you select the components you want to install, Select the management components then
0
 
LVL 13

Expert Comment

by:upalakshitha
ID: 34972179
0
 

Author Closing Comment

by:billymcss
ID: 34972712
That's what I tried the first time round but I had to uninstall a previous version od sql server express 2005.
thx
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

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.
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…

617 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