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.
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!
How did you get the install program to run? Mine keeps telling me that I have to reboot to finish off another installation.ReplyDelete
I 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.ReplyDelete
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.
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.
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.ReplyDelete
I had some problems connecting to the instance installed on vista but once i had installed the sp4 every thing is working fine .ReplyDelete
Vista support SQL SERVER 20.ReplyDelete
For Support contact.
Please guide me, how can I install SQL Server 2000 (Developer) on Vista Business edition.Delete
Always getting below error message:
"installshield engine has stopped working"
Thanks for the info.ReplyDelete
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.)
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]ReplyDelete
can someone please explain how to do this? thanks..