Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2008 Management Studio 2005 and 2008 on Same machine

Posted on 2011-02-24
4
Medium Priority
?
723 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
4 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 2000 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

Industry Leaders: 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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
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 process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

824 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