Installing SQL2008 Standard Ed on SBS2003

Discussion in 'Windows Small Business Server' started by Kevin Young, Aug 27, 2009.

  1. Kevin Young

    Kevin Young Guest

    I plan to install SQL2008 Standard edition on to an SBS2003 server to
    upgrade the SQL2000 server that is on there.

    Should this be OK?
    Should I uninstall the SQL2000 first?
    Are there any other factors I should be aware of ?

    Thanks in advance
    Kevin
     
    Kevin Young, Aug 27, 2009
    #1
    1. Advertisements

  2. It should be possible to perform in place upgrade. However you should
    consider licensing, I think it can be cheaper to upgrade to SBS 2008 Premium
    which ships with SQL Server 2008, instead of upgrading your current Sql
    Server 2000.

    With kind regards
    Krystian Zieja
    http://www.projectenvision.com
     
    Krystian Zieja, Aug 27, 2009
    #2
    1. Advertisements

  3. Kevin Young

    Al Williams Guest

    Careful, there are quite a few databases used by SBS including monitoring,
    sharepoint, ISA firewall, WSUS2. For the SBS standard these are done with
    MSDE. For SBS Premium SQL2000 is also installed and some of the existing
    databases may or may not be migrated to it. I suspect you may run into
    issues trying to "upgrade" those databases.

    If this is for a heavily used LOB application I'd recommend a new database
    server setup as a member server. You may be able to run SQL2008 without
    affecting existing SQL versions by installing it standalone but it may be a
    strain on your hardware.
     
    Al Williams, Aug 27, 2009
    #3
  4. Hi Kevin,

    I have the same problem at a customer who uses SQL 2000 on SBS 2003 (not
    R2). All my tests on a virtual machine failed. The Installation started,
    after 1/3 of time appears that the SQL Browser Service cannot start - the
    installation breaks. Now I am testing several times again, but nothing will
    go. The Databank Company cannot help me but means to deinstall all the SQL
    and MSDE-Instances on SBS-Server...i am testing it - but failed again. Now I
    make one day stop then I try it again...

    greets
    Thomas
     
    Thomas Bläsing, Aug 28, 2009
    #4
  5. Kevin Young

    Kevin Young Guest

    OK - Thanks Thomas,
    I would be grateful if you let me know how you get on......

    This instance of SBS2003 is currently off-line with no live data - so I
    could thoeretically re-install SBS2003 - without the Premium disc
    (SQL2000) - and then install the new SQL2008 .....

    Kevin
     
    Kevin Young, Aug 28, 2009
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.