How to get SQL Server installed on SBS 2008 premium - Hyper V

I have a server which I would like to run sbs 2008 premium.  This will be my first installation of sbs 2008, and first experience using it.

I am under the impression that sql server will not run on an SBS machine.  So, research has led me to believe that I can do a virtual session of server 2008 on my sbs machine.

My problem is, I don't know how to do this...I have never worked with Hyper-V, and do not even know if that is what is needed.

So, here is the server specs:

-3 Seagate Barracuda 7200.11 ST3320613AS 320GB 7200 RPM 16MB Cache SATA  which will be in a Raid 5 Setup
-ASUS TS500-E6/PS4 Pedestal Barebone Server Intel 5500 Dual LGA 1366 Dual Intel Xeon 5500 and 5600 Series
-12 gig Kingston ValueRAM 6GB (3 x 2GB) 240-Pin DDR3 SDRAM ECC Registered DDR3 1333
-Intel Xeon E5504 Nehalem 2.0GHz 4 x 256KB L2 Cache 4MB L3 Cache LGA 1366 80W Quad-Core Server Processor

So, what steps do I need to take to have SBS 2008 installed and have SQL Server running also?  Hyper-V?  If so, how?  Could I use the free esxi?  If so, how?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ady FootSharePoint ConsultantCommented:
Hi there,

You're mis-informed about SQL 2008 (or 2005 for that matter) not running under a default SBS 2008 installation; it runs perfectly well.

Please take a look at this Microsoft guide:

Note the point "You can install SQL Server on the server running Windows SBS 2008 or on the second server that you set up for your Windows SBS 2008 domain."

I have personally run SQL 2008 on my SBS 2008 machine and have experienced no problems whatsoever.  Be sure to read the guide I've given you fully because it does give you some information.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
In addition to afoot.

We install SQL 2008 on SBS 2008 premium servers with no issue. We have quite a number of these servers at various customers in this configuration.

The only thing you have to do is to remove the workstation components of SQL 2005 which are on the main server. Make sure that is the only thing you do. Do not try and remove any of the actual sql 2005 instances (ie SBS monitoring).

You do this by finding the main SQL 2005 entry in programs/features and selecting 'change'. Then select add/remove features, then select 'workstation components'. Deselect any workstation components that are in here, and follow through the uninstallation.

You can then install SQL 2008 (although I would restart the server before you do this).

Make sure you have plenty memory. 5 users systems should have at least 8GB RAM, up to 20 Users at least 12 GB RAM, and more than 20 users we advise at least 18GB RAM.

If you do not uninstall the 2005 workstation components, it will still install SQL 2008, but it will fail to install the sql 2008 management studio. This can be installed on another pc or server if you wish.

dzirkelbAuthor Commented:
Oh excellent!  Yes, I must have been mis-informed....this takes a load off my back.

Now, to finish building the server and do a regular sbs 2008 install, then install sql server and do the above answers.  Thanks a lot guys!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Virtual Server

From novice to tech pro — start learning today.