Upgrading Small Business Server 2003 to Premium hanging on SQL Ser

Discussion in 'Windows Small Business Server' started by James Sanford, Jul 11, 2005.

  1. Hi. I am upgrading our SMS 2K3 server to include the premium components so
    that I can install Microsoft CRM. The Install instructions on the premium
    walk me through upgrading the default instance of the MSDE SQL Server, and
    applying sp4. The next section wants me to upgrade the Sharepoint instance
    of SQL Server to Standard. The SQL Server install hangs after I click on the
    full indexing sub component. Anyone have any ideas? This is a Dell
    Poweredge 400sc, with 1gb RAM.

    Thanks in advance,

    James Sanford
     
    James Sanford, Jul 11, 2005
    #1
    1. Advertisements

  2. Obviously, I meant. SBS, and not SMS...Not enough coffee yet this am. Sorry.

    james
     
    James Sanford, Jul 11, 2005
    #2
    1. Advertisements

  3. Hi James,

    Thanks for using the SBS newsgroup.

    Problem description:

    I understand that you encountered some problem when upgrade the standard
    version to premium.

    Analyzing:

    After checking the steps you mentioned, it seems you did not turn on
    full-text search in Windows SharePoint Services before you apply SQL SP4.
    So we would like to confirm that you have installed the premium version
    follow our white paper.

    Suggestion:

    Please double check if you follow the white paper to install the premium
    version.

    At your convenience, I would like to refer the documents for you:

    http://download.microsoft.com/download/8/2/4/824e18ac-8503-4277-aeb6-b3f24c3
    16f6c/PremiumInstallSteps.htm

    In additional, we would like to know if you have installed SBS 2003 SP1 on
    your SBS 2003, if not we recommend you install the SBS 2003 SP1, it will
    include the SQL 2000 SP4.
    We suggest you remove the SQL 2000 SP4 then install the SBS 2003 premium
    SP1.

    Here is the list documents which might be helpful to install SBS 2003 SP1:

    Follow the steps outlined in these documents to install the important
    updates included with Service Pack 1 for Windows Small Business Server 2003
    from CD.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=d56a7675-27c1-445b-
    a61f-007a30852ac6&DisplayLang=en

    Steps for installing Service Pack 1 for Windows Small Business Server 2003
    from the Web.

    http://www.microsoft.com/downloads/details.aspx?FamilyId=B6F8A4C0-B707-4161-
    ADEB-44F1B756119F&displaylang=en


    I appreciate your understanding on this issue, if you have any further
    concerns, please let me know. I am glad to help you.


    Best regards,

    Charles Yang (MSFT)

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security

    =====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    =====================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Charles Yang [MSFT], Jul 13, 2005
    #3
  4. Hi Charles,

    re:"After checking the steps you mentioned, it seems you did not turn on
    full-text search in Windows SharePoint Services before you apply SQL SP4. So
    we would like to confirm that you have installed the premium version follow
    our white paper.

    This is not the case. I'm followign the white paper (I think it was
    revision 4 on the website) step by step. I had just clicked full text search
    at the install components section, and the install hangs at the 'Gathering
    Information' stage.

    re:"In additional, we would like to know if you have installed SBS 2003 SP1
    on your SBS 2003, if not we recommend you install the SBS 2003 SP1, it will
    include the SQL 2000 SP4. We suggest you remove the SQL 2000 SP4 then
    install the SBS 2003 premium SP1.

    The SP1 had previously been installed on my SBS 2003 server. I'm confused
    by your statement, though. You say that SP1 includes SQL 2000 SP4 , but you
    suggest I remove it and then install SBS 2003 SP1.

    Maybe this will help. This was a Standard SBS 2003 server, that has SP1 on
    it. I had MSDE running on it to power sharepoint (The server actually came
    configured new this way). I followed the steps on the readme file, and
    clicked the link to get the updated readme file. Step by step, I very
    carefully completed the default upgrade of SQL Server Standard from MSDE.
    Then, I was on the step for upgrading the Sharepoint MSDE to SQL Server
    Standard. SP4 had not been applied.

    Should I 1) Check and remove SP4 (just in case), then 2) Remove SP1 from SBS
    2003, THEN try the upgrade from MSDE to Standard on the Sharepoint instance?

    I've also googled this problem, and have found numerous people that are
    having the same problem that haven't found a solution yet.

    Thanks in advance,

    James Sanford
     
    James Sanford, Jul 13, 2005
    #4
  5. HI James,

    Sorry for misunderstanding your issue, now I understand that you have
    already applied the SBS SP1 standard version on SBS 2003 standard, and you
    want to upgrade to SBS premium version.

    The SQL SP4 will be included in SBS premium SP1, it will not include in SBS
    standard SP1. you do not need to remove the SQL SP4.

    To make more searching about this issue, I would like to collect following
    information:

    1. From the \program files\microsoft integration\windows small business
    server 2003\logs directory, paste the following files:

    eventlog.txt
    errorlog.txt
    setup.log

    Thanks for your time and cooperation, I am here waiting for your updates.

    Best regards,

    Charles Yang (MSFT)

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security

    =====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    =====================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Charles Yang [MSFT], Jul 13, 2005
    #5
  6. It looks like I didn't read the directions properly, and now i've got
    everything working. Your comments helped me figure this out. First, I had
    installed the upgrade to SQL server standard on the default install and not
    the sharepoint install. It looks like I was supposed to upgrade sharepoint
    first, then do the default instance. After uninstalling SQL Server Standard,
    then I was able to upgrade the sharepoint instance to standard. After that,
    I installed a new instance of SQL Server and applied the patches.

    The moral of the story is to do things in the order recommended. I just got
    overzealous...

    Thanks,

    James
     
    James Sanford, Jul 13, 2005
    #6
  7. Hi James,

    Thanks for letting us know that my solutions helpful. We are glad to see
    the issue is resolved, Thanks for your effort.

    Hope you have a good sharing in this newsgroup. Hope to see you again in
    this newsgroup:

    Have a nice day!

    Best regards,

    Charles Yang (MSFT)

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security

    =====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    =====================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Charles Yang [MSFT], Jul 14, 2005
    #7
    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.