Solved

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

Posted on 2014-01-15
2
364 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
2 Comments
 
LVL 35

Accepted Solution

by:
Cris Hanna earned 500 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 21

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

932 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

12 Experts available now in Live!

Get 1:1 Help Now