Solved

Do I have SQLServer in my Windows 2008 Small Business Server Stnadard FE

Posted on 2011-09-04
3
465 Views
Last Modified: 2012-08-13
Hi,
  I like to know if I have SQL Server software with my Windows 2008 Small Business Server Stnadard FE. I included some screen shots for OS and SQL for you to see. Since I am not familiar with SQL Server, I don't know if I have one or not.
  If I have MS SQL capability, then I like to use it to learn about MS SQL.

Thank you.
SBS2008FE-SQL.doc
0
Comment
Question by:sglee
3 Comments
 
LVL 10

Accepted Solution

by:
SuperTaco earned 125 total points
ID: 36480330
SBS standard comes with an installation of SQL Express, which is mainly used for the SharePoint Foundation deployment.  You can use it for other databases through.  if the want the full blown SQL, you have to use SBS Premium and install it from an add-on.  I wouldn't use the SQL express for data bases mreo than 4 GB, then you have to start worrying about BLOB's if the database grows past that.  Most won't though.  if you do need a large SQL deployment, you're better off suing a separate server, to avoid overloading the SBS.
0
 

Author Comment

by:sglee
ID: 36480399
So I can use it to learn and develop SQL database that is less than 4GB in size?
If the database size becomes larger than 4GB, can I move the database to a full blowen version like the one that comes with  SBS Premium later on?
I have DELL  T110 Server with 6GB RAM with 2 active users with WORD/EXCEL/ACCESS, so there won't be any overloading because it is primarily for the purpose of learning & converting ACCESS based system into SQL database for learning purposes.
0
 
LVL 95

Assisted Solution

by:Lee W, MVP
Lee W, MVP earned 125 total points
ID: 36480637
SQL Express is a FREE version of SQL you can download and install from Microsoft. It should install on just about any computer running 2008/2008R2/Win7/Vista.  For learning basic SQL, it's pretty much full featured other than the limits mentioned.  If you want to learn it, I wouldn't learn it on your SBS server, I'd learn it on a Win7 PC using a copy you install.

SBS comes with SEVERAL SQL instances, not just one for Sharepoint - there's also one for monitoring and though I can't remember it now, I'm sure there's at least 1 more.

You can install at least 15 (there's a limit - but I don't recall exactly how many right now... I THINK it's 16, could be 32 installs of SQL on any one system.  
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration, of the HP EVA 4400 SAN Storage. The name , IP and the WWN ID’s used here are not the real ones. ABOUT THE STORAGE For most of you reading this, you …
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

896 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now