Solved

Installing SQL 2008 on existing SBS 2008 Premium

Posted on 2013-01-09
3
533 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

628 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