I need to install SQL Server MSDE 2000 SP4 on Windows 10.
I have other machines that run Windows 7 and 8.1 and SQL Server MSDE 2000 works fine (with merge replication configured too).
Now I testing the same scenario with Windows 10, but setup is closing unexpectedly during installation.
SQL Server 2000 Service Pack 1 (SP1) is no longer available. Fix list For more information about the problems that are fixed by SQL Server 2000 Service Pack 1, click the following article numbers to view the articles in the Microsoft Knowledge Base. Microsoft SQL Server is a relational database management system developed by Microsoft. SQL Server 7 and SQL Server 2000. SQL Server Operations Studio (Preview) is a cross platform query editor available as an optional download. Microsoft® SQL Server™ is a relational database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. SQL Server 2000, includes support for XML and HTTP, performance and availability features to partition load and ensure uptime, and advanced management and tuning functionality to automate routine. Even back in the old days of the early 2000s, Microsoft knew the importance of having a powerful and reliable database server, and their answer to that is the. Download SQL Server 2000 Service Pack 3a (SP3a), the latest and most comprehensive update to SQL Server 2000 that corrects vulnerabilities including the Slammer (W32.slammer) virus.
I know that this version is very old, but is there a workaround to install it on Windows 10?
2 Answers
I know of no hacks to get SQL Server 2000 to install on an existing Windows 10 installation. There are probably forces against you from both within the setup program (which looks for certain things on the host system) and within the operating system (which prevents many flavors of older software from getting installed, mostly for security reasons but also compatibility, stability, etc). I have tried in the past and even with compatibility override options I came across the same failures every time.
A couple of ideas:
- Use a virtual machine. This really is the simplest and most obvious solution. Most (if not all) editions of Windows 10 now support Hyper-V natively; if not, there is always VMWare Workstation (not free) and Oracle VirtualBox (free).
- Install 2000 then upgrade. Not really practical, especially if you want to use the Windows 10 installation you already have, but if you were doing this from scratch, you could install XP/Vista/Win7, all of which should allow you to install 2000, and then upgrade. Take care, though, because some methods of upgrading to Windows 10 will relegate all of your programs and services to Windows.old, and they won't run any more.
In either case, firewall the crap out of that thing, because the most recent security patches for 2000 are hard to find, and the ones that I found wouldn't install anyway...
I managed to install following these steps:
- Extract SP4
- Copy
..SP4x86othersqlredis.exe
to..originalinstallpathx86other
(this avoid mdac insall freezing)
- Create this folder structure (any place):
Microsoft SQL Server80ToolsBinn
Microsoft SQL ServerMSSQLBinn
- Find out sqlunirl.dll on
SP4
path and copy to Binn folder above - Copy
dll
files on..SP4x86setup
toMicrosoft SQL ServerMSSQLBinn
(folder above) - Copy folder structure (created on step 3) to
C:Program Files (x86)
Give full access to user logged to **Microsoft SQL Server** folder
- Change install compatiblity
..originalinstallpathx86setupsetupsql.exe
XP SP2
Run as administrator
All these steps are in this tutorial: How to install SQL Server 2000 (SP4) on Windows 10
protected by Paul White♦Aug 12 '17 at 7:44
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged sql-serverinstallationsql-server-2000windows-10 or ask your own question.
SQL Server 2000 SP4 is made up by a collection of three files that include the updates for the following SQL Server 2000 components:
- Databasecomponents, updated by launching: SQL2000-KB884525-SP4-x86.EXE. Updates your 32-bit database components of SQL Server 2000 including Database Engine, Replication, Client Connectivity components and Tools
- Analysis servicecomponents: for which purpose SQL2000.AS-KB884525-SP4-x86.EXE is used.
- SQL Server 2000 desktop enginecomponents: updated by means of SQL2000.MSDE KB884525-SP4-x86.EXE.
Microsoft always advises its users to update their products, so if you use SQL Server 2000 and you haven't updated it, you have to download SQL Server 2000 SP4.