domain controller on sbs 2008

Posted on 2012-09-20
Last Modified: 2012-10-01
hey guys can i install sql 2008 r2 on a sever of my client which has small bussiness server 2008 standard?

the sever is a domain control.

i need to attach a database to the sever to get the connection string for my website.

how do i go about doing so?
Question by:JCWEBHOST
    LVL 25

    Expert Comment

    Seen this?

    Technically possible but not recommended and probably not supported.

    I'm no SBS expert but I know it is very particular about these kind of things and of course, it's never advisable to install SQL on DC.
    LVL 25

    Expert Comment

    Sushil...not sure that's 100% relevant as it's referring to Premium and if I recall that came licensed for SQL on and additional box?

    The OP has SBS Standard
    LVL 56

    Expert Comment

    by:Cliff Galiher
    Yes, tech I ally you can install SQL 2008 R2 on SBS 2008 as long as you have the appropriate SQL server license and CALs. SBS 2008 CALs do not cover SQL 2008 R2.

    For the record though, I'd never do it. It'll kill the performance of the server. Better to run it on a separate server, physical or virtual. And if this is going to be used to drive a web app, which seems implied in your question, I also wouldn't want it on a DC. significant security concerns there.

    All around there are several reasons to avoid this scenario. I'd be thinking of a new plan.
    LVL 10

    Expert Comment

    Depending on your requirements, and of course, taking the above security issues into account, you can install SQL on SBS 2008 DC.

    For example, if you use Symantec Backup Exec, it installs its own copy of SQL Server Express onto the server for its own small database.

    If your database size is going to be less than 10GB, and if you configure the SQL memory footprint to be low enough not to strangle SBS, but high enough to service your database (and/or fit some more memory to the SBS box), then you'll get away with SQL Server 2008 R2 Express edition, meaning you don't have the CAL issue either.

    But... be careful... check what you *actually* need, and from where, and make sure the firewall rules are set strictly enough to protect the network, and that you've got enough memory etc etc etc.

    Author Comment

    ok thanks guys, i have another question?

    can SBS 2008 host emails and web sites?

    if so it should be able to house a database?

    i am just asking, i am a web developer and do host websites, but this client have SBS and wants me to move his database to his server.

    so i am new to this.
    LVL 25

    Accepted Solution

    As per earlier comments, providing you have the correct licenses then technically, yes, SBS 2008 standard can run SQL but also for the reasons mentioned, you shouldn't.

    To recap:

    SBS is a unique variant of Windows with very controlled components and ideas / management tools;
    SQL will hammer the performance;
    The SBS server is a domain controller. Because DC's have different security models to member servers, then it'll either lead to issues with SQL or you will have to relax security;
    If your SQL server is compromised you are handing the keys to your domain to the attacker as it's also a DC.
    LVL 56

    Expert Comment

    by:Cliff Galiher
    *can* SBS host SQL and websites? Yes. *should* it? Not just no, but hells no. I would never, under any circumstances, host a website on SBS. That is a HUGE security hole and the cost of hosting a basic website is so trivial that I cannot think of a single justification to put it on SBS.
    LVL 25

    Expert Comment

    SouthMod, I would personally say the following comments were most relevant:
    38417382 and 38417686

    With a rather passionate confirmation in 38417700 :-)

    Expert Comment

    I've requested that this question be closed as follows:

    Accepted answer: 167 points for Tony1044's comment #a38417382
    Assisted answer: 167 points for CSIPComputing's comment #a38417464
    Assisted answer: 166 points for cgaliher's comment #a38417700

    for the following reason:

    Accepting on behalf of the author.
    LVL 25

    Expert Comment

    Sorry for not responding sooner - I've had a crazy few days.

    I am, personally, quite happy with the split and grading.

    Thanks mods.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
    I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
    To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now