Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SBS2008 Setup Exchange 2007 and SQL2008

Posted on 2011-02-10
7
Medium Priority
?
271 Views
Last Modified: 2012-05-11
I read that Exchange and SQL are not good to have on the same server, although with SBS2008 it comes with both of them preinstalled, right?  I could be SQL in a VM on that same server but if its disk IO + RAM issue then that won't help.
Also wondering on the SQL instance thats installed - it doesnt quite look right, I dont see the traditional enterprise manager?
The server has 4 quadcores with hyperthreading so windows sees 16 cores and 24gb of ram...  This is for an organization of about 30 people - nothing too intense.  SQL is used for their CRM, but again nothing crazy busy...
0
Comment
Question by:rhwimmers
[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
  • 4
  • 3
7 Comments
 
LVL 6

Expert Comment

by:linraf
ID: 34867020
SBS 2008 Standard only comes with SQL Express ( The free and limited version of SQL) installed.

SBS 2008 Premium comes with Licensing for SQL server, and an additional Windows server license. they intend that you use SQL server on the second Windows server.
0
 
LVL 1

Author Comment

by:rhwimmers
ID: 34867102
yeah I got premium, so it is meant for another box then eh?
0
 
LVL 6

Expert Comment

by:linraf
ID: 34867201
It can be run on the same box, and it sounds like is beefy enough that it would handle it. Many people do virtualize the 2nd windows with sql also.

SBS2003 premium included sql and ran on the same server without issues.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 6

Expert Comment

by:linraf
ID: 34867216
The sql that is installed by default is the SQL Express ( meant for and used by WSUS, Sharepoint, and Sbs monitoring).  You have to purposely installl the SQL workgroup.
0
 
LVL 1

Author Comment

by:rhwimmers
ID: 34867456
Yeah I put the disc in that said SQL and did the install...In programs it now has sql2005 and sql2008, but I still dont see enterprise manager and query analyzer etc?
0
 
LVL 1

Author Comment

by:rhwimmers
ID: 34912134
Anyone have thoughts on this?
0
 
LVL 6

Accepted Solution

by:
linraf earned 2000 total points
ID: 34917256
They should be extra option on the install cd, I believe.
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

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

One-stop solution for Exchange Administrators to address all MS Exchange Server issues, which is known by the name of Stellar Exchange Toolkit.
Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

609 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