[Last Call] Learn how to a build a cloud-first strategyRegister Now


Installing SQL 2008 R2 on SBS 2011 standard

Posted on 2011-10-08
Medium Priority
Last Modified: 2012-05-12

Installing SBS 2011 standard worked fine. Adding SQL 2008R2 to it failes during 'Setup Support Tools'. The Performance counter registry hive consistency Failed.
The performance counter registry hive is corrupted. To continue you must repair..... Refer to KB300956.

It must have something to do with the dutch SBS 2011 and English SQL 2008R2.

Pls any advice?
Question by:maasdelta
  • 2
  • 2
LVL 10

Assisted Solution

SuperTaco earned 450 total points
ID: 36936128
is this SBS 2011 permium?  You can'e install SQl if it's standard

Author Comment

ID: 36936165

It is:

Windows Small business Server 2011 Standard (T72-02880)


Windows Small Business Server 2011 Premiun Add-on (2XG-00152)

I must say that a disk Windows Server 2008 R2 is included in the Premium package. But I don't understand (can't find clarification) the reason for that.
LVL 10

Assisted Solution

SuperTaco earned 450 total points
ID: 36936534
the packaging makes no sense (but SBS 2011 is based on Server 2008 R2)..... Regardless, you can only install SQL Express on SBS 2011 Premium.  You would have had to install SBS Premium to install SQL.  The add on package should have a SQL version you can install.
LVL 26

Accepted Solution

ronnypot earned 300 total points
ID: 36939268
To start with the explanation, you have a SBS 2011 Standard installation which is the DC, exchange, sharepoint, wsus, sbs console, etc. The premium add-on is an add-on that includes windows and sql 2008 r2 sql license to install on a second box (this can be physical or virtual).

So if you want to install it is recommended to install a second server with SQL. If you realy persist and can live with the performance and security issues, you can install another SQL instance on the SBS 2011 standard server, but ALWAYS install a new instance and never try to change or add a database to one of the existing SQL instances from SBS.

Author Closing Comment

ID: 37022742
The confusion arose from Microsoft's product and the supplier information. Wrong licenses, software and information is provided.

Thank you!


Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

830 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