• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

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.
2 Solutions
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?
Chris MConsulting - Technology ServicesCommented:
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.
Chris Musasizi.

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now