Solved

Installing Microsoft SQL Server 2000 Personal Edition on Windows XP Professional with SP2

Posted on 2004-10-28
534 Views
Last Modified: 2012-05-05
I am trying to install Microsoft SQL Server 2000 Personal Edition on Windows XP professional with the latest critical updates, but system seems to hang at configuring services.
0
Question by:dorsai0423
    9 Comments
     
    LVL 6

    Expert Comment

    by:Duane Lawrence
    0
     

    Author Comment

    by:dorsai0423
    I read the comment but how do I roll back SP2????

    "My solution was to rollback SP2... Then install MDAC 2.80... Then reinstall SQL Server... "
    0
     
    LVL 8

    Expert Comment

    by:SashP
    See How to remove Windows XP Service Pack 2 from your computer

    http://support.microsoft.com/kb/875350
    0
     
    LVL 6

    Expert Comment

    by:Duane Lawrence
    I had to uninstall it because it failed the first time I tried to install it on my laptop.  Use the below command in the "run" on the start menu.

    c:\windows\$NtServicePackUninstall$\spuninst\spuninst.exe

    Duane
    0
     
    LVL 34

    Accepted Solution

    by:
    I wouldn't say uninstall SP2, I'm having no problems with it and SQL Server--people are to quick to blame it for a lot of things....Do you have file and printer sharing enabled?  Have you looked at the installation log for errors?
    0
     
    LVL 6

    Expert Comment

    by:Duane Lawrence
    If the question gets deleted, does the count of questions I participated in go down by one?

    The correct way to handle WinXP service pack 2 issues is:

    remove the bad install of sp2
    c:\windows\$NtServicePackUninstall$\spuninst\spuninst.exe

    Download the sp2 to your hard drive, go into safe mode, now install sp2.

    Duane
    0
     
    LVL 34

    Expert Comment

    by:arbert
    "The correct way to handle WinXP service pack 2 issues is:

    remove the bad install of sp2
    "


    Nobody ever said it was a bad install of SP2....The original question said " but system seems to hang at configuring services."  Didn't say what services and I haven't had a problem with SQL Server and SP2 (as long as you meet the prerequesites--uninstalling a hung install of SP2 can present its own problems....Since there was no further input or clarification on the question, I would delete it...
    0
     
    LVL 8

    Expert Comment

    by:SashP
    I agree
    0
     

    Author Comment

    by:dorsai0423
    Thanks, the issue was with adjusting the new firewall settings with SP2
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    884 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now