Solved

Installing SQL 2008 on existing SBS 2008 Premium

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 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

10 Experts available now in Live!

Get 1:1 Help Now