SQL Server 2008 Side by Side with SQL Server 2005

Question

I am considering installing SQL Server 2008 as a named instance side by side with SQL Server 2005.    I gave 4GB RAM and plenty of disk space. 

Can anyone confirm  that I would be to  run SSMS & BIDS for SQL Server 2005 and 2008?

What issues am I  likely to experience?

---

PG

Answer 1

Hello,

There are known issues when installing SQL Server 2008 side by side with SQL Server 2005 on a cluster (see KB2000403), but you don’t have a cluster.

Do you have Visual Studio 2008 installed in the same box? If that is the case, see KB956139.

I don’t know of any other issues. Everything should be working fine after installing SQL Server 2008.

Please see the following article about side-by-side support for SQL Server 2008:

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

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

I can confirm that its safe to use both SSMS and Bids on same machine as I am having on my system. SQL tools will be installed in different folders. i.e 90 will be used for 2005 and 100 will be used for 2008.

Answer 3

One thing I do t is that SSMS project will only wne of the SSMS's. My findings is that it will be the one you pacted most recently, but I've gottent some conflivfeedback on that so not entirely certain. I've decided to only have one version of the tools on my machine (and have SSMS 2005 in a virtual machine in unlikely event I need it).

---

Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi

Answer 4

Oh, btw, you should really only have one SSIS service. Right after 2008 install, you might see both SSIS services but one will magically dissapear (again, probably after some patching), and you will be left with 2008 SSIS service only.

---

Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi

Answer 5

That is useful to know.   I have a few 2005 packages.  I assume this means they would have to be maintained in BIDS 2008, correct?

---

PG

Answer 6

I'm no SSIS expert so consider posting to an SSIS forum. Yes, they would be executed by 2008 SSIS. You possibly want to upgrade the packages to SSIS 2008 format. Also, if they are in msdb, you probably need to store them in msdb on a 2008 instance (as I recall, 2008 SSIS refused to connect to SQL Server 2005 for package storage).

---

Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi