XP Reboots when installing SQL 2005 SP3

  • Rich Ray

    SSC Eights!

    Points: 887

    Good morning all,

    When installing SQL 2005 SP3 on a Windows XP SP3 machine, the PC reboots when I try to test the connection OR click Next at the Authentication screen.

    There is nothing meaningful in the SQL logs.

    Unfortunately I am connecting via RDP as there is no keyboard or mouse attached in the server room where the PC resides so I am not able to see any possible errors before it reboots.

    Has anyone else had this problem?

    Kind regards,

    Richard

  • Rich Ray

    SSC Eights!

    Points: 887

    Hi all,

    I've got an update.....

    We have two XP clients that are exactly the same - well out the box anyway, perhaps someone has changed something.

    I still have the problem with SP3 on one of them but the other one is fine.

    Are there any undocumented pre-reqs for SP3? As the SQL Logs are not showing anything of any use, is there anywhere else I can look for logs that may be of any use?

    Also, if I am restoring DB's from an SP3 system into SP2 would there be any issue? There does not appear to be but I just wanted to check.

    Thanks,

    Richard

  • jcbarnes411

    SSC Enthusiast

    Points: 137

    I have exact same problem - also happens same place if I attempt SP2. ALSO, I had external 500gb USB HD and 4gb in machine, so unplugged USB HD, and removed 2gb. Still reboots.

    Also, I had to put 2gb back into mach to get past "Resuming Windows..." then turn hibernation OFF, to get machine to stop "resuming windows...", then remove the 2gb again to reboot.

    After that I still have the reboot problem.

    Any clues ?

    Thanks

    Jeff Barnes

  • vegemite003

    SSC Journeyman

    Points: 79

  • jcbarnes411

    SSC Enthusiast

    Points: 137

    Thanks Vegemite.

    I got around problem with MS hotfix 184176.

    Had I gone to XP SP3 that might have fixed it as well.

    Problem was access violation caused a BSOD (which was a .15 sec flash before machine shutoff).

    Regards

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply