locked
Microsoft SQL Server 2008 R2 Express Parallel Installation RRS feed

  • Question

  • Hi,

    This is a pretty noob question,

    I want to install Microsoft SQL Server 2008 R2 Express parallel to my current installations. but the document at

    http://www.microsoft.com/download/en/details.aspx?id=23650

    doesn't cover my specific case.

    Here is my Microsoft SQL Servers currently installed on my computer:

    Under C:\Program Files (x86), I have

    • Microsoft SQL Server
    • Microsoft SQL Server Compact Edition

    and under C:\Program Files, I have the following as well:

    • Microsoft SQL Server
    • Microsoft SQL Server Compact Edition

    From the start menu, I can access

    • Microsoft SQL Server 2008
    • Microsoft SQL Server 2008 R2

    They all pointing to the Microsoft SQL Server on my corp network.

    Now, I want to install the Microsoft SQL Server 2008 R2 Express as a standalone app that parallel to my above current installations. How can I do that?

    - All installation options seem to "update" my existing Microsoft SQL Server 2008 installation, which is what I want to prevent.

    - Having installed it, how can I start my local SQL Server?

    - Is there any issues doing that?

    Again, Thess are a pretty noob questions. Please don't be offended for me to ask them.

    This is a 64 bit Win 7 machine, with Office 2010 and Visual Studio 2010 installed.

     

    Thanks for your help!

    smetah

    • Edited by smetah Tuesday, February 28, 2012 10:59 PM typo
    Tuesday, February 28, 2012 10:50 PM

Answers

  • hi,

    >They all pointing to the Microsoft SQL Server on my corp network.

    actually it can't be true... if you have those entries in your application bar, you installed SQL Server locally... more, SQL Compact can not be a network "app".. it must be local... go to control panel, services applets and investigate the name of your installed instance.. if you find "SQL Server (SQLExpress)" you have a named instance locally installe named "SQLExpress"... .. if you have "SQL Server MSSQLServer" you have a default instance installed... or run SQL Server Configuration Manager to identify them as well .... finally run SQL Server Management Studio and connect to the local instance to check all is up and running...

    if you have to do a new installation, perhaps you can have a look at my experiences at http://www.asql.biz/Articoli/SQLX08/Art5_2.aspx

    regards


    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools http://www.hotelsole.com/

    • Proposed as answer by Peja Tao Thursday, March 1, 2012 3:10 AM
    • Marked as answer by smetah Thursday, March 1, 2012 4:41 AM
    Wednesday, February 29, 2012 12:17 AM

All replies

  • hi,

    >They all pointing to the Microsoft SQL Server on my corp network.

    actually it can't be true... if you have those entries in your application bar, you installed SQL Server locally... more, SQL Compact can not be a network "app".. it must be local... go to control panel, services applets and investigate the name of your installed instance.. if you find "SQL Server (SQLExpress)" you have a named instance locally installe named "SQLExpress"... .. if you have "SQL Server MSSQLServer" you have a default instance installed... or run SQL Server Configuration Manager to identify them as well .... finally run SQL Server Management Studio and connect to the local instance to check all is up and running...

    if you have to do a new installation, perhaps you can have a look at my experiences at http://www.asql.biz/Articoli/SQLX08/Art5_2.aspx

    regards


    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools http://www.hotelsole.com/

    • Proposed as answer by Peja Tao Thursday, March 1, 2012 3:10 AM
    • Marked as answer by smetah Thursday, March 1, 2012 4:41 AM
    Wednesday, February 29, 2012 12:17 AM
  • Thanks a lot Andrea.

    That's really comprehensive.

    Thursday, March 1, 2012 4:42 AM