Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Installing SQL 2008 on existing SBS 2008 Premium

Posted on 2013-01-09
3
Medium Priority
?
536 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 19

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 19

Accepted Solution

by:
Andrew Davis earned 1500 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month8 days, 18 hours left to enroll

876 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