Solved

SBS2008 Setup Exchange 2007 and SQL2008

Posted on 2011-02-10
7
268 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 500 total points
ID: 34917256
They should be extra option on the install cd, I believe.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager

717 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