Solved

SQL Server 2008 Management Studio 2005 and 2008 on Same machine

Posted on 2011-02-24
4
699 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

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 Backup & Restore 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.
OfficeMate Freezes on login or does not load after login credentials are input.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

752 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