Thursday, October 26, 2006

SQL Server 2000 on Vista?

I read a number of articles that mentioned SQL Server 2000 will not install and/or is not supported on Vista. I just wanted to let you know that it WILL install. The only major caveat that I ran into was in enterprise manager when trying to connect to the 'local' instance. I had to dump that connection and connect to the actual named install of the sql server (which was my server name).

There is also an issue with SQL Server starting properly when Vista loads up. The MSSQLSERVER service was set to start up "Automatic" but in fact this doesn't work. If you change the startup type to "Automatic (Delayed Start)" things will work as expected.

All of that aside, based on the articles I read, along with all of the prompts Vista throws at you to essentially not install it, I don't know if I would install it on a production system, as Microsoft probably won't support it.

Good luck!

10 comments:

  1. Anonymous5:54 PM

    Michael
    Thanks - I just upgraded to Vista and forgot to detach my SQL 2000 databases but, thanks to your blog, I can now access them under Vista!
    Ian

    ReplyDelete
  2. How did you get the install program to run? Mine keeps telling me that I have to reboot to finish off another installation.

    I have rebooted several times and the message doesn't change

    ReplyDelete
  3. It turns out that because Office 2007 was preinstalled with SQL Server 2005 Express edition, this confuses the SQL 2000 setup.

    I can't reinstall Vista because it came preinstalled on my laptop, so I'm forced to use SQL Server 2008 Express edition, which is a real pain.

    ReplyDelete
  4. hi,

    I am shailaja, i just bought a pc with windows vista (home basic). Now i am trying to install Sql Server 2000 but at the end of the installation it displaying the message as "Installshield has stopped working". Happy to hear that Sql Server 2000 is able to install in vista. So Can you please help to resolve the problem.

    Thanks

    ReplyDelete
  5. You might want to ensure that you're running the install program "as an administrator". I wish I could be of more help, but there are quite a few resources out there. Have a look at this link.

    http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/6d2b27b5-4114-47d9-a9bc-9c8bb9104f88/

    ReplyDelete
  6. Anonymous8:32 AM

    I had some problems connecting to the instance installed on vista but once i had installed the sp4 every thing is working fine .

    ReplyDelete
  7. Vista support SQL SERVER 20.

    For Support contact.

    ReplyDelete
    Replies
    1. Please guide me, how can I install SQL Server 2000 (Developer) on Vista Business edition.

      Always getting below error message:
      "installshield engine has stopped working"

      Delete
  8. Thanks for the info.

    As for the question about pending installation;
    If the installation of SQL Server fails due to the machine not being rebooted between the installations of various products, delete the registry entry item ‘PendingFileRenameOperations’ from the registry location ‘HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager’ and all subsequent ControlSets child key ‘Session Manager\PendingFileRenameOperations’ (ControlSet1, ControlSet2 etc.)

    ReplyDelete
  9. Anonymous10:19 PM

    The only major caveat that I ran into was in enterprise manager when trying to connect to the 'local' instance. [i]I had to dump that connection and connect to the actual named install of the sql server (which was my server name).[/i]

    can someone please explain how to do this? thanks..

    ReplyDelete