Solved

SQL Server 2008 Management Studio 2005 and 2008 on Same machine

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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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:…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

679 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