Solved

Installing SQL 2008 on existing SBS 2008 Premium

Posted on 2013-01-09
3
530 Views
Last Modified: 2016-11-23
We currently have an up and running dell server with SBS 2008 Premium installed with 10 users doing mostly exchange.

We would like to put SQL 2008 on this existing server, but after reading many post's I'm confused.

I know its recommended to be on a second server but if we don't have to spend the money, I want to see if its possible to put it on the existing server.

So, does anyone have any detailed help on this?
I've seen this link, http://technet.microsoft.com/en-us/library/cc794696(v=ws.10).aspx
but it doesn't seem to address my issue.
0
Comment
Question by:Allan Hancock
  • 2
3 Comments
 
LVL 18

Expert Comment

by:Andrew Davis
ID: 38761500
See http://social.technet.microsoft.com/Forums/en-US/windowsserver2008r2general/thread/feb0ecdd-10c6-48c6-ad7c-ef7e2938c4d4

As you have "Premium" that allows a second standard server for this exact reason. as for hardware costs, you could virtualize it (which is what i would do anyway).

Cheers
Andrew
0
 

Author Comment

by:Allan Hancock
ID: 38762849
The link refers to SBS Standard not Premium , so I'm not sure that helps.

As to hardware costs you mention virtualizing it.

I don't have any experience with that.
Are you referring to installing software like vmware and installing vmware on my server?

If so what are the requirements like?
0
 
LVL 18

Accepted Solution

by:
Andrew Davis earned 500 total points
ID: 38766101
Regarding the link. Forget about the question and just read Krystian's answer that deakls with premier.

As for virtualizing it.
If your hardware is complient with VMWare, then i would be converting over to an ESXi environment.
see http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1003661
and
http://www.vmware.com/resources/compatibility/search.php

If not then you would need Hyper V, which will support more hardware.

to keep on the same hardware it involve doing a backup, and then blowing the server away, installing virtualization host, and then configuring the VM's and restoring your SBS server to one of them. If you have never done this then i would highly recommend getting an experianced contractor in to guide you through it.

Certainly you could just install SQL2008 on the current box, and be prepared for the headaches that you will have to resolve, and the fact that it will allways be hobbled by being on the same box as the resource hungry exchange (depending on your network load this may or may not be an issue).

Obviously the preferable route here would be to have a second server that you could use temporarily to do a test migration to Virtual, this will be easier with Hyper-V as it's hardware support is greater. This would allow you to test migrate to a beefed up desktop, and once happy with the procedure, migrate the physical Dell server.

Cheers
Andrew
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

810 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