Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Upgrading from SBS2003 Standard SP1 to SBS2003 R2 Premium

Posted on 2008-06-15
6
Medium Priority
?
996 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 2000 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
Technology Partners: 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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…
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…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

610 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