Can I install SSMSE 2008 , and steel keep SSMSE 2005 and how?

Question

Can I install SSMSE 2008 , and steel keep SSMSE 2005 and how?

markih

SSC Enthusiast

Points: 157
More actions
April 14, 2010 at 9:07 pm

#139864

I have SQL Server express 2005 on my local computer, working with SSMSE 2005.
I also need SSMSE 2008 for remote connection to SQLS 2008 DB's on server.
Can I have SSMSE 2005, SSMSE 2008 on 1 local computer?
If yes, How can i install SSMSE 2008, without losing SSMSE 2005?
Can I work with certain SSMSE or other program connect to both versions of SQLSE (2005,2008)? SSMSE 2005 doesn't connect SQLS 2008 DB's or my attempt failed.
I don't want to install SQLSE 2008.
The main purpose of above questions is TO HAVE possibility to connect from computer local SQLSE 2005, and server SQLS 2008.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

StarNamer SSCrazy Eights Points: 8746 More actions · Answer 1

I have SQLServer 2005 (Developer) with SMSS and SQLServer 2008 Express with SSMSE 2008 installed with no problem, so would think SSMSE 2005 and 2008 shold be able to coexist. SSMSE 2008 can connect to SS2k5 with no apparent problem, so I actually use that almost all the time.

Derek

CDBA Hall of Fame Points: 3266 More actions · Answer 2

Mark

You can have SQL 2005 and 2008 in the same computer. If you are planning to install 2008 server components, make sure to install a new instance instead of upgrading the existing 2005 one. This will not disturb your 2005 instance and you will have 2008 instance.

Also as a side note, you should be able to use your 2005 and all other older instances using 2008 client tools. So may be you want to consider using 2008 only.

NB. I have 2000 (EE), 2005 (EE) and 2008 (Express) running in parallel on my machine with out any issue.

CDBA

WayneS SSC Guru Points: 95460 More actions · Answer 3

Utsab Chattopadhyay (4/15/2010)
Also as a side note, you should be able to use your 2005 and all other older instances using 2008 client tools. So may be you want to consider using 2008 only.

I have noticed that when I use SSMS 2008 on a 2005 server, that you should not modify the maintenance plans... something gets added that causes an error when you then open it up in SSMS 2005 (MP gets rebuilt without loosing anything).

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

markih SSC Enthusiast Points: 157 More actions · Answer 4

Derek, Thank u for reply.

I don't want to install SQLSE 2008.

I had downloaded SSMSE 2008 and I hadn't asked where to install.

Can u say me how can i do install SSMSE 2008 without installing SQL SE 2008?

markih SSC Enthusiast Points: 157 More actions · Answer 5

Thank u for reply.

I want only SSMS express 2008 for connecting SQL 2008 DB'S on remote servers.

How can i do it?

markih SSC Enthusiast Points: 157 More actions · Answer 6

During installation of SQL Server Management studio express (SSMSE)2008 , I was requsted to uninstall SQL Server Express 2005. I don't want to Remove it.

I need SQL Server Express 2005, both SSMSE 2005,2008 on my computer.

How can i overcome this problem?

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 7

I think you just want to install client components.

http://msdn.microsoft.com/en-us/library/ms143219.aspx

MJ

markih SSC Enthusiast Points: 157 More actions · Answer 8

markih

SSC Enthusiast

Points: 157

April 16, 2010 at 11:02 am

#1153028

Thank u. I'll try it later.