SBS Premium:Install SQL 2000 now or wait for SQL 2005?

Discussion in 'Windows Small Business Server' started by SolRodriguez, Mar 16, 2006.

  1. SolRodriguez

    SolRodriguez Guest

    Hello. I'm looking for advice on installing SQL 2000 in the premium edition
    of SBS 2003 now, or waiting for SBS 2003 R2 which includes SQL 2005. We have
    recently set up a new SBS 2003 box, but I have not yet installed the premium
    apps. We would like to get started with some simple database development for
    some simple web based interfaces, but I'm trying to decide wether it would be
    better to just wait a few more months and upgrade to SBS 2003 R2 so I
    wouldn't have to migrate data from SQL 2000 to SQL 2005.

    Thanks.

    Sol Rodriguez
     
    SolRodriguez, Mar 16, 2006
    #1
    1. Advertisements

  2. Hello Sol,

    Thank you for posting to the SBS Newsgroup.

    I understand that you are SBS 2K3 Standard Edition now and you want to know
    some information about SQL 2005 Workgroup in the SBS 2K3 R2. If I have
    misunderstood your concern, please let me know.

    Please take your time to read through my reply:

    ============

    Actually, you can either

    a. Purchase and install SBS 2K3 Premium to have SQL 2K. After R2 release,
    and continue installing R2.

    OR

    b. Wait for SBS 2K3 R2 to be released for SQL 2005 Workgroup.

    ============

    SBS 2003 R2 Premium now includes 2 CDs for Premium Technologies, SQL 2005
    Workgroup Edition is in Disk 2. From your decryption, it seems that you
    have not installed SBS 2K3 SP1 yet, so you need to install SBS 2K3 SP1 and
    then install SBS 2003 R2.

    For detail instructions to install SBS 2003 SP1, please refer to the
    following SBS 2003 SP1 download page.

    [Note]: Please read and follow the instructions carefully to complete the
    installation.

    Downloading and Installing Windows Small Business Server 2003 Service Pack
    1
    http://download.microsoft.com/download/e/0/f/e0fee8ce-768d-41c0-8871-9bc48e0
    b3fc3/ToDownLoadFilesandReadInstructions.htm

    For the Windows Small Business Server 2003 Premium SP1 which includes ISA
    2004/SQL SP4, you need to order it.
    http://go.microsoft.com/fwlink/?LinkId=45336

    For the detailed steps to install ISA 2K4 and SQL 2000 SP4 (and W/MSDE
    SP4), please see following document:

    Completing Setup for Microsoft Windows Small Business Server Premium
    Technologies
    http://www.microsoft.com/downloads/details.aspx?FamilyId=87A48D35-54AB-4F63-
    90A3-A884311202E1&displaylang=en

    ============

    For your additional information:

    1> From a support lifecycle perspective, SQL Server 2000, which was
    available with SBS 2003 Premium will exit standard support at the end of
    2007, while the standard support for SQL Server 2005 will be 2 years after
    the release of next version of SQL Server.

    2> Most applications designed for SQL Server 2000 Standard Edition will be
    compatible with SQL Server 2005 Workgroup Edition. However it is important
    to review the backward compatibility documentation for SQL Server 2005
    available at this link:

    Backward Compatibility
    http://msdn2.microsoft.com/en-us/library/ms143232.aspx

    Thoroughly testing your application in a test environment with SQL Server
    2005 is recommended before upgrading your existing production application
    installation to SQL Server 2005

    3> I also found following Documents for your reference, please see:

    Windows Small Business Server 2003: R2
    http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/r2.mspx


    Windows Small Business Server 2003 R2: Powering Small Businesses
    http://www.microsoft.com/windowsserver2003/sbs/r2/default.mspx

    Hope it helps! If you have any further questions or concerns, please feel
    free to let me know. I am looking forward to hearing from you!

    Best regards,

    Brandy Nee

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security
    ======================================================
    This newsgroup only focuses on SBS technical issues. If you have issues
    regarding other Microsoft products, you'd better post in the corresponding
    newsgroups so that they can be resolved in an efficient and timely manner.
    You can locate the newsgroup here:
    http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

    When opening a new thread via the web interface, we recommend you check the
    "Notify me of replies" box to receive e-mail notifications when there are
    any updates in your thread. When responding to posts via your newsreader,
    please "Reply to Group" so that others may learn and benefit from your
    issue.

    Microsoft engineers can only focus on one issue per thread. Although we
    provide other information for your reference, we recommend you post
    different incidents in different threads to keep the thread clean. In doing
    so, it will ensure your issues are resolved in a timely manner.

    For urgent issues, you may want to contact Microsoft CSS directly. Please
    check http://support.microsoft.com for regional support phone numbers.

    Any input or comments in this thread are highly appreciated.
    ======================================================
    This posting is provided "AS IS" with no warranties, and confers no rights.



    --------------------
     
    Brandy Nee [MSFT], Mar 17, 2006
    #2
    1. Advertisements

  3. SolRodriguez

    SolRodriguez Guest

    Thanks for the reply Brandy. I actually have the Premium edition of SBS 2003
    already, I just haven't installed SQL or ISA yet. That's why I'm wondering
    IF I should install SQL now, or just wait for SQL 2005 in R2.

    Any thoughts?

    Sol
     
    SolRodriguez, Mar 17, 2006
    #3
  4. Hello Sol,

    Thank you for posting back!

    I am sorry for the delayed response due to the weekend. Please understand
    that the newsgroups are staffed weekdays by Microsoft Support professionals
    to answer your systems and applications questions. Your understanding is
    greatly appreciated!

    Actaully, it depends on your business needs if install SQL 2K now or waiti
    for SQL 2K5 Workgroup in R2. From your reply, I understand that you have
    Premium Edition, in this case, you can try and install the Premium first.

    If you have any further questions or concerns, please feel free to let me
    know. I am looking forward to hearing from you!

    Best regards,

    Brandy Nee

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security
    ======================================================
    This newsgroup only focuses on SBS technical issues. If you have issues
    regarding other Microsoft products, you'd better post in the corresponding
    newsgroups so that they can be resolved in an efficient and timely manner.
    You can locate the newsgroup here:
    http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

    When opening a new thread via the web interface, we recommend you check the
    "Notify me of replies" box to receive e-mail notifications when there are
    any updates in your thread. When responding to posts via your newsreader,
    please "Reply to Group" so that others may learn and benefit from your
    issue.

    Microsoft engineers can only focus on one issue per thread. Although we
    provide other information for your reference, we recommend you post
    different incidents in different threads to keep the thread clean. In doing
    so, it will ensure your issues are resolved in a timely manner.

    For urgent issues, you may want to contact Microsoft CSS directly. Please
    check http://support.microsoft.com for regional support phone numbers.

    Any input or comments in this thread are highly appreciated.
    ======================================================
    This posting is provided "AS IS" with no warranties, and confers no rights.



    --------------------
     
    Brandy Nee [MSFT], Mar 20, 2006
    #4
    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.