Solved

Installing SQL 2008 on existing SBS 2008 Premium

Posted on 2013-01-09
3
531 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The problem of the system drive in SBS 2003 getting full continues to be an issue, even though SBS 2008 and SBS 2011 are both in the market place.  There are several solutions to this, including adding additional drive space or using third party uti…
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…

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