Microsoft sql server 2000 desktop engine windows 10

I need to install MSDE 2000 Release A on Windows 10.

The installation window pops up and then immediately closes without an error message.

This answer to this SO question seemed to solve a very similar problem and indicates that it is in fact possible to install and run MS SQL Server 2000 on Windows 10. I know that that question is about SQL Server 2000 and not MSDE, but I hope that if it works for SQL Server 2000, it will also apply to the Desktop Engine variant.

Any ideas about what could be killing the installer and/or how I could try to figure this out?

  • I have already tried setting the compatibility mode of the installer to WinXP SP2 and running with admin priviledges

  • I have not yet tried to first install Win 7, then MSDE, then upgrade to Win 10, and would very much prefer to directly install on Win 10

Community's user avatar

asked Jan 10, 2016 at 19:22

Reto Höhener's user avatar

Reto HöhenerReto Höhener

5,4524 gold badges40 silver badges81 bronze badges

3

I have found a workaround…

I found that it was extracting several dlls to the temp folder during install and the MSI log was complaining about loading one of them. No dependency loading issues found with any of them so I tried copying them all to C:\Windows\SysWow64, but one of them (sqlunirl.dll) got access denied as it is a part of the OS. If I change the owner and permissions of that dll, I can then replace it with the extracted one, install MSDE, and afterwards replace it with the original Win10 one. However the SQL Service Manager app then refuses to start, but since exes always look for dlls in their own folder first, put that same dll in C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn. Just in case, I’ve also copied it to other folders that have executables in too. I’ve not tested this out yet but have knocked up a quick batch file to install (put it next to Setup.exe along with the sqlunirl.dll grabbed from the temp folder from a previous install attempt):

takeown /f C:\Windows\SysWOW64\sqlunirl.dll /a
icacls C:\Windows\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:f
IF NOT EXIST C:\Windows\SysWOW64\sqlunirl.bak move C:\Windows\SysWOW64\sqlunirl.dll C:\Windows\SysWOW64\sqlunirl.bak
copy /y "%~dp0sqlunirl.dll" C:\Windows\SysWOW64

"%~dp0Setup.exe" (plus your extra parameters such as SAPWD=PASSWORD)

move /y C:\Windows\SysWOW64\sqlunirl.dll "C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn"
copy /y C:\Windows\SysWOW64\sqlunirl.dll "C:\Program Files (x86)\Microsoft SQL Server\80\COM"
copy /y C:\Windows\SysWOW64\sqlunirl.dll "C:\Program Files (x86)\Microsoft SQL Server\Mssql$InstanceName\BinnMSSQL$InstanceName\Binn"
move /y C:\Windows\SysWOW64\sqlunirl.bak C:\Windows\SysWOW64\sqlunirl.dll
icacls C:\Windows\SysWOW64\sqlunirl.dll /remove *S-1-5-32-544
icacls C:\Windows\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:(GR,GE,WO)
icacls C:\Windows\SysWOW64\sqlunirl.dll /setowner *S-1-5-80-956008885-3418522649-1831038044-1853292631-2271478464

(NB: SIDs are used for Administrators group and TrustedInstaller so that it works on any language. Generic Read and Generic Execute rights are the default on the administrators group, but I am also applying Write Owner so that I can set it back to TrustedInstaller as I couldn’t find a way to use TakeOwn.exe to set it back!)

answered Jan 26, 2018 at 16:18

Dan Gough's user avatar

2

This is sort of a reverse-answer to the question, hope it’s OK! I couldn’t find anyone else mentioning it so hopefully it’s alright. Just wanted to say that Dan’s solution also works for uninstalling MSDE 2000 from Windows 10.

I had a Win7 computer that had MSDE 2000 installed, which I upgraded to Windows 10. Everything worked fine till I needed to upgrade the software which involved uninstalling MSDE 2000. It simply wouldn’t uninstall — the msi would run then just exit.

All I had to do was rename sqlunirl.dll, run the uninstaller from add/remove programs, then rename it and change the permissions back:

takeown /f %SystemRoot%\SysWOW64\sqlunirl.dll /a
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:f
IF NOT EXIST %SystemRoot%\SysWOW64\sqlunirl.bak move %SystemRoot%\SysWOW64\sqlunirl.dll %SystemRoot%\SysWOW64\sqlunirl.bak

< RUN UNINSTALLER HERE >

move /y C:\Windows\SysWOW64\sqlunirl.bak C:\Windows\SysWOW64\sqlunirl.dll
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /remove *S-1-5-32-544
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:(GR,GE,WO)
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /setowner *S-1-5-80-956008885-3418522649-1831038044-1853292631-2271478464

Hope that helps someone!

answered Jul 21, 2019 at 11:52

Eugene Kang's user avatar

It has worked for me doing what it says @Eugene Kang, but with the following setting I add the sqlunirl.dll dll in Windows\system32 before installation.

I have used sql server 2000 sp4.

So i add one line to your script:

takeown /f %SystemRoot%\SysWOW64\sqlunirl.dll /a
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:f
copy %SystemRoot%\SysWOW64\sqlunirl.dll %SystemRoot%\system32\sqlunirl.dll
IF NOT EXIST %SystemRoot%\SysWOW64\sqlunirl.bak move %SystemRoot%\SysWOW64\sqlunirl.dll %SystemRoot%\SysWOW64\sqlunirl.bak

< RUN UNINSTALLER HERE >

move /y C:\Windows\SysWOW64\sqlunirl.bak C:\Windows\SysWOW64\sqlunirl.dll
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /remove *S-1-5-32-544
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:(GR,GE,WO)
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /setowner *S-1-5-80-956008885-3418522649-1831038044-1853292631-2271478464

Thanks in advance,

answered Aug 28, 2020 at 8:25

Tabutnas's user avatar

Solution 1

I have found a workaround…

I found that it was extracting several dlls to the temp folder during install and the MSI log was complaining about loading one of them. No dependency loading issues found with any of them so I tried copying them all to C:\Windows\SysWow64, but one of them (sqlunirl.dll) got access denied as it is a part of the OS. If I change the owner and permissions of that dll, I can then replace it with the extracted one, install MSDE, and afterwards replace it with the original Win10 one. However the SQL Service Manager app then refuses to start, but since exes always look for dlls in their own folder first, put that same dll in C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn. Just in case, I’ve also copied it to other folders that have executables in too. I’ve not tested this out yet but have knocked up a quick batch file to install (put it next to Setup.exe along with the sqlunirl.dll grabbed from the temp folder from a previous install attempt):

takeown /f C:\Windows\SysWOW64\sqlunirl.dll /a
icacls C:\Windows\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:f
IF NOT EXIST C:\Windows\SysWOW64\sqlunirl.bak move C:\Windows\SysWOW64\sqlunirl.dll C:\Windows\SysWOW64\sqlunirl.bak
copy /y "%~dp0sqlunirl.dll" C:\Windows\SysWOW64

"%~dp0Setup.exe" (plus your extra parameters such as SAPWD=PASSWORD)

move /y C:\Windows\SysWOW64\sqlunirl.dll "C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn"
copy /y C:\Windows\SysWOW64\sqlunirl.dll "C:\Program Files (x86)\Microsoft SQL Server\80\COM"
copy /y C:\Windows\SysWOW64\sqlunirl.dll "C:\Program Files (x86)\Microsoft SQL Server\Mssql$InstanceName\BinnMSSQL$InstanceName\Binn"
move /y C:\Windows\SysWOW64\sqlunirl.bak C:\Windows\SysWOW64\sqlunirl.dll
icacls C:\Windows\SysWOW64\sqlunirl.dll /remove *S-1-5-32-544
icacls C:\Windows\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:(GR,GE,WO)
icacls C:\Windows\SysWOW64\sqlunirl.dll /setowner *S-1-5-80-956008885-3418522649-1831038044-1853292631-2271478464

(NB: SIDs are used for Administrators group and TrustedInstaller so that it works on any language. Generic Read and Generic Execute rights are the default on the administrators group, but I am also applying Write Owner so that I can set it back to TrustedInstaller as I couldn’t find a way to use TakeOwn.exe to set it back!)

Solution 2

This is sort of a reverse-answer to the question, hope it’s OK! I couldn’t find anyone else mentioning it so hopefully it’s alright. Just wanted to say that Dan’s solution also works for uninstalling MSDE 2000 from Windows 10.

I had a Win7 computer that had MSDE 2000 installed, which I upgraded to Windows 10. Everything worked fine till I needed to upgrade the software which involved uninstalling MSDE 2000. It simply wouldn’t uninstall — the msi would run then just exit.

All I had to do was rename sqlunirl.dll, run the uninstaller from add/remove programs, then rename it and change the permissions back:

takeown /f %SystemRoot%\SysWOW64\sqlunirl.dll /a
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:f
IF NOT EXIST %SystemRoot%\SysWOW64\sqlunirl.bak move %SystemRoot%\SysWOW64\sqlunirl.dll %SystemRoot%\SysWOW64\sqlunirl.bak

< RUN UNINSTALLER HERE >

move /y C:\Windows\SysWOW64\sqlunirl.bak C:\Windows\SysWOW64\sqlunirl.dll
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /remove *S-1-5-32-544
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:(GR,GE,WO)
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /setowner *S-1-5-80-956008885-3418522649-1831038044-1853292631-2271478464

Hope that helps someone!

Related videos on Youtube

How to install SQL Server 2000 (SP4) on Windows 10

13 : 49

How to install SQL Server 2000 (SP4) on Windows 10

HOW TO INSTALL MICROSOFT SQL SERVER 2000 FOR WINDOWS 10 PRO x64

16 : 16

HOW TO INSTALL MICROSOFT SQL SERVER 2000 FOR WINDOWS 10 PRO x64

SQL Server 2000 installation win10 X64 part1

12 : 34

SQL Server 2000 installation win10 X64 part1

Cara Mudah Install SQL Server 2000 pada Windows 10 64 Bit (Tanpa Error)

07 : 13

Cara Mudah Install SQL Server 2000 pada Windows 10 64 Bit (Tanpa Error)

Install SQL Server 2000 on Windows 10 - Solved - Setup Initialization Error in SQL Server 2000

09 : 30

Install SQL Server 2000 on Windows 10 — Solved — Setup Initialization Error in SQL Server 2000

Server 2000 Install New PC updated 100% with client

19 : 07

Server 2000 Install New PC updated 100% with client

How to Install SQL Server 2000

15 : 45

How to Install SQL Server 2000

Sql 2000 in window 10  Installation for Client

19 : 30

Sql 2000 in window 10 Installation for Client

Comments

  • I need to install MSDE 2000 Release A on Windows 10.

    The installation window pops up and then immediately closes without an error message.

    This answer to this SO question seemed to solve a very similar problem and indicates that it is in fact possible to install and run MS SQL Server 2000 on Windows 10. I know that that question is about SQL Server 2000 and not MSDE, but I hope that if it works for SQL Server 2000, it will also apply to the Desktop Engine variant.

    Any ideas about what could be killing the installer and/or how I could try to figure this out?

    • I have already tried setting the compatibility mode of the installer to WinXP SP2 and running with admin priviledges

    • I have not yet tried to first install Win 7, then MSDE, then upgrade to Win 10, and would very much prefer to directly install on Win 10

    • Have you considered a virtual machine with an OS that does support that version?

  • Wow, thanks. Didn’t know/think about the MSI log. I don’t need MSDE anymore, but that debug avenue might be useful in the future.

  • I’m just going to accept your answer, even though I didn’t try it out myself.

Recents

Related

Archived Forums 381-400

 > 

SQL Server Tools

  • Question

  • Question

    Sign in to vote

    0


    Sign in to vote

    Team,

    Greetings!!

    Microsoft SQL 2000 Desktop Engine is not Compatible with Windows 10 OS. Any other alternative software is available? Will MS SQL Server Standard latest version include this MSDE component? Please suggest.

    Friday, May 3, 2019 6:28 AM

All replies

  • Question

    Sign in to vote

    0


    Sign in to vote

    refer following link

    https://stackoverflow.com/questions/34709781/install-microsoft-sql-server-2000-desktop-engine-msde-2000-release-a-on-window


    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

    Friday, May 3, 2019 6:34 AM

  • Question

    Sign in to vote

    0


    Sign in to vote

    SQL Server 2000 is out-of-Support since a very Long time; no currently OS Version supports it.

    MSDE 2000 was the free Version of SQL Server 2000; now the free Version is called Express Edition; you can use that one.

    https://www.microsoft.com/en-us/sql-server/sql-server-editions-express


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by
      Puzzle_Chen
      Monday, May 6, 2019 2:36 AM

    Friday, May 3, 2019 7:54 AM

Это своего рода обратный ответ на вопрос, надеюсь, что все в порядке! Я не мог найти никого, кто бы упоминал об этом, так что надеюсь, что все в порядке. Просто хотел сказать, что решение Дэна также работает для удаления MSDE 2000 из Windows 10.

У меня был компьютер с Win7, на котором был установлен MSDE 2000, который я обновил до Windows 10. Все работало нормально, пока мне не потребовалось обновить программное обеспечение, которое включало удаление MSDE 2000. Он просто не удалялся — MSI запускался, а затем просто выходил.

Все, что мне нужно было сделать, это переименовать sqlunirl.dll, запустить деинсталлятор из программ добавления / удаления, затем переименовать его и снова изменить разрешения:

takeown /f %SystemRoot%\SysWOW64\sqlunirl.dll /a
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:f
IF NOT EXIST %SystemRoot%\SysWOW64\sqlunirl.bak move %SystemRoot%\SysWOW64\sqlunirl.dll %SystemRoot%\SysWOW64\sqlunirl.bak

< RUN UNINSTALLER HERE >

move /y C:\Windows\SysWOW64\sqlunirl.bak C:\Windows\SysWOW64\sqlunirl.dll
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /remove *S-1-5-32-544
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /grant *S-1-5-32-544:(GR,GE,WO)
icacls %SystemRoot%\SysWOW64\sqlunirl.dll /setowner *S-1-5-80-956008885-3418522649-1831038044-1853292631-2271478464

Надеюсь, что это помогает кому-то!

Sql Server установка на Windows 10 установка Microsoft Sql Server 2000 Desktop Engine Msde

Contents

  • 1 Sql Server установка на Windows 10 установка Microsoft Sql Server 2000 Desktop Engine Msde
  • 2 Installing Sql Server 2019
    • 2.1 Conclusion
      • 2.1.1 Related image with sql server установка на windows 10 установка microsoft sql server 2000 desktop engine msde
      • 2.1.2 Related image with sql server установка на windows 10 установка microsoft sql server 2000 desktop engine msde

We believe in the power of knowledge and aim to be your go-to resource for all things related to Sql Server установка на Windows 10 установка Microsoft Sql Server 2000 Desktop Engine Msde. Our team of experts, passionate about Sql Server установка на Windows 10 установка Microsoft Sql Server 2000 Desktop Engine Msde, is dedicated to bringing you the latest trends, tips, and advice to help you navigate the ever-evolving landscape of Sql Server установка на Windows 10 установка Microsoft Sql Server 2000 Desktop Engine Msde.

Download Microsoft Sql Server 2000 Full All Free Download

Download Microsoft Sql Server 2000 Full All Free Download

Download Microsoft Sql Server 2000 Full All Free Download

Ms Access 2000 Runtime Pagnewyork

Ms Access 2000 Runtime Pagnewyork

Ms Access 2000 Runtime Pagnewyork

Windows 10 Install Sql Server 2000 Desktop Engine Lasopavelo

Windows 10 Install Sql Server 2000 Desktop Engine Lasopavelo

Windows 10 Install Sql Server 2000 Desktop Engine Lasopavelo

Https Stjag Ru Index Php 2012 02 08 10 29 37 добровольчество Item 37164 сражение за рудо Html

Https Stjag Ru Index Php 2012 02 08 10 29 37 добровольчество Item 37164 сражение за рудо Html

Https Stjag Ru Index Php 2012 02 08 10 29 37 добровольчество Item 37164 сражение за рудо Html

Installing Sql Server 2019

Installing Sql Server 2019

this video demonstrates how to install sql server 2019. microsoft sql can be installed on a windows server, linux system, or in simple and straightforward steps on how to install sql server 2019 on windows 10. up your data analysis skills: sql server can be installed on your windows 8 or 10 computer (with a 64 bit operating system) that is most modern desktops or learn how to install microsoft sql server 2019 on windows 10. with that, we will also install sql server management studio. learn how to install microsoft sql server 2022 on windows 10. with that, we will also install sql server management studio. in this step by step tutorial, learn how you can write your own sql queries. you don’t need any prior knowledge and we’re going this video explains how to create a new database and new login in microsoft sql server 2019. step by step procedure here this video demonstrates how to configure security auditing in microsoft sql server. hello everyone! today in this video i am going to step by step guide you on how to install microsoft sql server for writing sql in this sql video, we will learn how to restore or upload a database in sql server using ssms. how to install sql server for this playlist covers what additional skills are required to work as an rpa developer the skill we are talking here is knowledge of

Conclusion

After exploring the topic in depth, it is clear that article offers helpful insights concerning Sql Server установка на Windows 10 установка Microsoft Sql Server 2000 Desktop Engine Msde. Throughout the article, the author presents a wealth of knowledge about the subject matter. Notably, the discussion of X stands out as particularly informative. Thanks for this article. If you have any questions, please do not hesitate to contact me via social media. I am excited about your feedback. Furthermore, below are a few similar articles that might be helpful:

  • Microsoft sql server скачать для windows 11
  • Microsoft sql server для windows server 2008 r2
  • Microsoft security essentials для windows 7 x64 скачать обновление
  • Microsoft sql server windows firewall
  • Microsoft security essentials windows server 2012 essentials