Solved

SBS2008 Setup Exchange 2007 and SQL2008

Posted on 2011-02-10
7
267 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Problems using Powershell and Active Directory?

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

733 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