Solved

Upgrading from SBS2003 Standard SP1 to SBS2003 R2 Premium

Posted on 2008-06-15
6
990 Views
Last Modified: 2012-08-13
hi all,

I have a client who runs a SBS2003 Standard SP1 box.  They need to run SQL Server 2005 so it seems to me the most cost effective way to do that is for them to upgrade to SBS2003 R2 Premium which includes SQL Server 2005 on the Premium Technologies CD.  I just need to confirm the upgrade path.  From what i can see, none of the SBS upgrade products will jump straight from SBS2003 SP1 Standard to Premium R2.  It would appear I first need to upgrade to 2003 R2 Standard (via Microsoft product id T72-01415) then go from R2 Standard to R2 Premium via another upgrade pack (T75-01260).

Can anyone confirm if this is the correct path to perform this migration?  I'm trying to avoid having to install R2 Premium on a new box and migrate everything over.  It's only a small busines with 8 PCs and very basic AD structure so i don't see an issue.

ta
nathan
0
Comment
Question by:natrat22
[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
  • 3
  • 3
6 Comments
 
LVL 9

Accepted Solution

by:
waynewilliams earned 500 total points
ID: 21788857
Hi,
You dont need to perform a full upgrade of SBS.
The only difference between R1 and R2 SBS is 1 disc which has Service Pack 2 for Exchange,

Sharepoint Service Pack and R2 (which is basically just MMC3.0 and WSUS as well as a few other bits).

The only difference between standard and premium is the Premium Technologies CD which just had SQL and ISA on it.

All you woud need to buy is T75-01260 and you will have all you need.  You dont even need to use the R2 disc if you dont want to. You can just use the Premium Technologies CD to install SQL.  I have done this myself recently so I know it works.
0
 
LVL 1

Author Comment

by:natrat22
ID: 21789864
Wayne, thats great, thank for the info.  Does the DSQL Server 2005 install ask for a product key then?  And you just use the one that comeswith the R2 product?
0
 
LVL 1

Author Comment

by:natrat22
ID: 21790554
Oh and how does the licensing work for SQL 2005?  Will it use the SBS licenses from Standard SP1?  Or at some point do i need to enter the licernse for SBS R2 Premium?
0
Industry Leaders: 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 9

Expert Comment

by:waynewilliams
ID: 21791451
As far a i recall the SBS Version of SQL just needs the SBS Premium product key to install (you will get this with the upgrade pack).

Your SBS Cal's will cover the SQL server as well.
0
 
LVL 1

Author Comment

by:natrat22
ID: 21830243
Ok well i've installed SQL Server 2005 from the SBS2003 R2 Premium upgrade CD - it detected my existing trial install of the SQL 2005 STandard edition and even warned me that installing the Workgroup edition would mean i would lose some features.  It was a bit strange though - it automatically had pre-filled in a product key.  That key wasnt the same as the SBS premium R2 key and I don't think i had to enter a trial product key, so I'm presuming that the key is included within the SBS SQL install?   I'm hoping it's all going to be fine now when the trial would have run out, there doesn't seem to be any way of checking whether i am on a trial or not now, or how many licenses I have.
0
 
LVL 9

Expert Comment

by:waynewilliams
ID: 21832187
Yes I forgot that the product key is pre-filled.  You are now on full version.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…

756 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