Solved

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

Posted on 2014-01-15
2
362 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article I will describe the Detach & Attach 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.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

743 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

16 Experts available now in Live!

Get 1:1 Help Now