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!
Michael
ReplyDeleteThanks - 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
How did you get the install program to run? Mine keeps telling me that I have to reboot to finish off another installation.
ReplyDeleteI have rebooted several times and the message doesn't change
It turns out that because Office 2007 was preinstalled with SQL Server 2005 Express edition, this confuses the SQL 2000 setup.
ReplyDeleteI 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.
hi,
ReplyDeleteI 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
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.
ReplyDeletehttp://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/6d2b27b5-4114-47d9-a9bc-9c8bb9104f88/
I had some problems connecting to the instance installed on vista but once i had installed the sp4 every thing is working fine .
ReplyDeleteVista support SQL SERVER 20.
ReplyDeleteFor Support contact.
Please guide me, how can I install SQL Server 2000 (Developer) on Vista Business edition.
DeleteAlways getting below error message:
"installshield engine has stopped working"
Thanks for the info.
ReplyDeleteAs 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.)
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]
ReplyDeletecan someone please explain how to do this? thanks..