[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Creating another instance of SQL Server 2008

Posted on 2011-10-06
Medium Priority
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
  • 5
LVL 14

Accepted Solution

theruck earned 2000 total points
ID: 36923085
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

ID: 36923765
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

ID: 36924808
After trying to continue installation by run program, it shows another warning as attached. Not sure what I'm missing here.
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.


Author Comment

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

Assisted Solution

thecavalry earned 0 total points
ID: 36953670
I found that installing SQL Server 2008 R2 with Advance Services does not warn me about installing SP.

Author Closing Comment

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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

872 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