installing SQL Server 2008R2 and Visual Studio 2010 on the same computer RRS feed

  • Question

  • Hi,

    I would like to install Visual Studio 2010 Professional on a machine that has SQL Server 2008 R2 Developer's Edition on it already.  When SQL Server was installed it looks like it also installed "Visual Studio 2008 Shell (integrated mode) - ENU" and "Visual Studio Tools for Applications 2.0 - ENU".  When I look at the custom installation screen for Visual Studio 2010 it gives an option to turn off the installation of "Microsoft SQL Server 2008 Express Service Pack".  Here are my questions:

    1. Will installing VS 2010 automatically upgrade the VS 2008 components that alredy exist on the machine?  If not, can the VS 2008 components and VS 2010 co-exist on the same computer without any problems?

    2. Should I choose custom installation when installing VS 2010 and turn off "Microsoft SQL Server 2008 Express Service Pack" since the computer already has SQL Server 2008 R2?

    3. If question 2's answer is yes - will VS 2010 be able to communicate with the database seamlessly using the pre-existing SQL Server 2008 R2 installation?

    Thanks, knot

    Sunday, September 25, 2011 4:01 PM


  • Hi,

    Let me try to answer your questions:

    1. VS 2008 and 2010 can live side-by-side. you can install it.
    2. If you do not need another instance of SQL express, then choose custom install.
    3. It depends :). If you set the correct connection string whenever you want to use  database connection, then the answer is yes.

    I hope it helps.


    There are 10 type of people. Those who understand binary and those who do not.
    • Proposed as answer by Maggie Luo Tuesday, September 27, 2011 5:08 AM
    • Marked as answer by Knot Wednesday, September 28, 2011 1:53 AM
    Sunday, September 25, 2011 5:21 PM