Solved

SBS2008 Premium and SQL 2008 on same machine?

Posted on 2011-03-16
2
531 Views
Last Modified: 2012-06-27
I have a brand new SBS2008 Premium server - Dell T610 packed with plenty of upgrades.

The SBS software came with an additional Server 2008 license as well as SQL Server license.

We currently don't have the hardware to build another x64 machine for Server 2008, but I do need it for some DB development for an in-house BOM management system development.

Would it be advisable to put SQL server on the same machine as the SBS?  
0
Comment
Question by:chrisrbloom
2 Comments
 
LVL 13

Accepted Solution

by:
connectex earned 500 total points
ID: 35148500
As I've post several times. Yes, it's possible. I've done it for various situations. I've got two clients that use SQL for Line Of Business (LOB) applications (20 users) and another using it for Microsoft's Dynamics CRM product (35 users). All using one SBS 2003/2008 server running SQL 2000-2008. It looks like the server you have will be good. I'd recommend at least 12GB of RAM. You can always move SQL to another server if dedicated performance is needed in the future.
0
 
LVL 42

Expert Comment

by:kevinhsieh
ID: 35148906
The other recommended option is to install Windows 2008 SP2 on the hardware, add Hyper-V and then run SBS in one VM and another Windows 2008 SP2 VM for SQL. All of that is included with your SBS 2008 license.
0

Featured Post

The curse of the end user strikes again      

You’ve updated all your end user’s email signatures. Hooray! But guess what? They’re playing around with the HTML, adding stupid taglines and ruining the imagery. Find out how you can save your signatures from end users today.

Join & Write a Comment

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…
In this article I will describe the Backup & Restore 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.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

762 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

22 Experts available now in Live!

Get 1:1 Help Now