?
Solved

Will SQL 2008 R2 Server for Small Business Install on Windows Server 2008 R2 Foundations?

Posted on 2014-01-15
2
Medium Priority
?
383 Views
Last Modified: 2014-01-16
So, I have a client that needs a full version (read: not Express) version of SQL 2008 R2 Standard on a Windows Server 2008 R2 Foundations domain controller.

My question is, will the SQL Server 2008 R2 Small Business Edition install?  From what I've read on the internet, it looks for an SBS domain, but foundations is even smaller than SBS.

I don't want to buy the wrong SKU and have an unreturnable product.

Thanks,
Chris
0
Comment
Question by:ottcomputing
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Cris Hanna earned 2000 total points
ID: 39785032
No, it will not install in a non SBS environment.  It's not about the number of users.  During the install process it looks for registry info that indicates there is as SBS 2008 server present.
0
 
LVL 22

Expert Comment

by:Larry Struckmeyer MVP
ID: 39785242
Adding that the SBS version WILL install on Server 2011 Essentials, so you may consider what is actually a minor upgrade to the Essentials product.  This may require open license and downgrading as I don't think the SBS version of SQL will install on Server 2012 Essentials, but considering that with either version you get a real price break on SQL AND client PC backup it may be a good investment.

Note that ON is not meant to mean on the actual instance of Server where Server is a DC.  You can do this but it is best to install in a second instance of Server.  Consider doing this where the new server runs either both instances as VM's in hyperV or using the existing server for SQL and a new one for Essentials.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

800 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