Upgrade sbs 2003 standard to premium - Would it affect the database of Exchange server and sharepoint. Since the real version of SQL will be installed on ?

Posted on 2008-10-21
Last Modified: 2012-05-05
I have a SBS 2003 Standard edition without MS SQL server. We need MS SQL on the server, but since Exchange server and sharepoint is current using some sort of MS SQL. I am not sure if by upgrade to premium edition to get MS SQL server or install MSSQL server 2008 express edition in would affect Exchange or Sharepoint ?  
Question by:cuteo408
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
  • 2
  • 2
  • 2

Accepted Solution

Dimarc67 earned 500 total points
ID: 22771729
Exchange isn't using SQL, so you're good there.
Are you using Sharepoint, or is it simply there with the rest of the automatically installed software?  If you're not using it, then there's no worry of hurting anything.
Lastly, SBS standard comes with MSDE which is what Sharepoint is currently using.  Upgrading to Premium will provide MS SQL Server, which will happily coreside with MSDE.  From Microsoft's MSDE ReadMe file:
"You can install up to 16 copies, or instances, of MSDE 2000 and the SQL Server 2000 database engine on the same computer. "
New York, NY

Author Comment

ID: 22771972
hi Dimarc67,

I am currently using Sharepoint, Exchange & outlook web, intranet (company web) and Desktop Remote. Dont know if will change any setting of SBS 2003 standard after the upgrade. What about the licensing ?


Expert Comment

ID: 22772030
Ah, well that's the easy part.

SBS 2003 Premium is exactly the same software as Standard, only it includes two extra CDs for SQL Server and ISA, which you'll install on your existing server using the instructions in the Premiuminstallsteps.htm file on the Premium Technologies CD.  That's all there is to it.

As for the licensing, there may be separate product keys for SQL Server and/or ISA, but maybe not even that.
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

LVL 51

Expert Comment

by:Mark Wills
ID: 22778225
Think the SBS premium only gives you workgroup edition of SQL Server.

Might be better to save your money and get SQL 2008 Express with advanced services, or the Standrad license. Sharepoint will continue to run as a named instances, and can migrate into the new server if needed.

Author Comment

ID: 22778549
Thanks Dimarc67,
I'll install SQL in this weekend, will let you know after the installation.

Mark, I was think of installing SQL 2008 Express too, because the features on 2008 version are much easy to use. But we already bought the Premium CD.  
LVL 51

Expert Comment

by:Mark Wills
ID: 22778632
Ah well, thems the breaks...

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

728 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