Creating another instance of SQL Server 2008

Posted on 2011-10-06
Last Modified: 2012-06-27

I already have 1 instance of SQL Server 2008 R2 express edition installed on a server - SQL Server 10.50.1600.1. and I want to create another instance. If I go to the server properties, it shows the Product as Microsoft SQL Server Express Edition with Advanced Services (64 bit).

I could not find anywhere that specify that SP2 has been installed except in Programs and Features where I can see that there are and other related SQL Server stuff:
Microsoft SQL Server 2008 R2 (64-bit)
Microsoft SQL Server 2008 R2 Setup (English)
Microsoft SQL Server Compact 3.5 SP2 ENU

My question is when I try to install another instance of SQL Server 2008 Express Edition with Advance Services - SQLEXPRADV_x64_ENU.exe I get the attached warning asking to installed SP1 or later. Is that normal?
Question by:thecavalry
    LVL 14

    Accepted Solution

    yes it is normal as it is saying that the version without sp1 has know issues.
    after you install it you need to apply sp1 at least to be on a supported configuration.
    the sp is installed per instance so if you are installing a new instance you will need to SP it afterwards.
    if you plan to add another instance it will be the same

    Author Comment

    Thanks theruck, so is it normal for the existing SQL Server 2008 express edition to be using Microsoft SQL Server Compact 3.5 SP2 ENU instead of Microsoft SQL Server Express 3.5 SP2 ENU?

    Author Comment

    After trying to continue installation by run program, it shows another warning as attached. Not sure what I'm missing here.

    Author Comment

    The above SQL Server Setup Failure goes away after another attempt.

    Assisted Solution

    I found that installing SQL Server 2008 R2 with Advance Services does not warn me about installing SP.

    Author Closing Comment

    Installing SQL Server 2008 R2 avoided the need to install SP later on.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now