SQLServer 2008 dev install

My dev box is currently runnng  WINXP pro, VS2008 pro and SQLServer 2005 dev plus SqlExpress. Now I need to install SQLServer 2008 dev on that same box. I plan to keep SqlExpress and all existent databases. How easy is the installation going to be?  Any precautions or caveats to beware of? Can I use SSAS with the new SQL2008 intall and the preinstalled VS2008? Thanks for any help.
ksfokAsked:
Who is Participating?
 
Chris MConnect With a Mentor Consulting - Technology ServicesCommented:
Hi,
You definitely can install more than two instances of SQL even if they are not the same version. The only thing you cannot do with WinXP is installing Standard or Enterprise editions.
All you have to do is ensuring that the instance names are different and for easier manageability, kindly use slighly different installation paths (if you can).
You can also make connectivity easier by creating aliases (use SQL server config manager or SQL server client network utility if you run an SQL 2K instance) pointing to the different service names and ports. (No 2 SQL servers can run on the same port) and SQL client tools tend to default to specific ports.
Everything is not transparent, the future is bright, enjoy.
Regards,
Chris Musasizi.
0
 
St3veMaxConnect With a Mentor Commented:
You can install it however it will ask you for an instance name as the chances are based on your question that the default instance is in use.

Just be aware of resource utilisation on your dev machine; perhaps close down some of the unused SQL Server instances for a while?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.