Solved

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

Posted on 2011-09-04
3
484 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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…
Learn about cloud computing and its benefits for small business owners.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

829 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