none
Windows 10 & My SQL Server 2000 Personal

    Question

  • One of my clients has an application that only requires “SQL Server 2000 Personal Edition” (the new versions of SQL are not supported).

    I have installed Windows 10 (64 bit) with iso file directly

    now, i cannot install My SQL Server 2000 Personal and error is sqlserv.exe not found

    but while upgrade from 7 or 8.1 (64bit), it (installed SQL Server 2000 Personal) work correctly in windows 10 upgraded

    why?

    how install it now in windows 10 directly??


    • Edited by HosseinE Tuesday, August 04, 2015 5:37 AM edit
    Tuesday, August 04, 2015 5:26 AM

All replies

  • Hi,

    It seems that SQL server 2000 is not compatible with Windows 10:

    https://www.microsoft.com/en-us/windows/compatibility/CompatCenter/ProductDetailsViewer?Name=Microsoft%20SQL%20Server%202000&vendor=Microsoft&Locale=1033%2C2057%2C3081%2C4105%2C16393&ModelOrVersion=8&BreadCrumbPath=SQL%20Server%202000%20personal&LastSearchTerm=SQL%2BServer%2B2000%2Bpersonal&Type=Software&tempOsid=Windows%2010

    But you can try to install it in compatible mode:

    Right click the installer > Click Properties> Under Compatibility tab> choose OS (Windows 7 or 8)

    Then see if it can work fine now.


    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Thursday, August 06, 2015 1:05 PM
    Moderator
  • installing start but it freez afew later and incomplete installing.why???!!

    please help me!

    link "sql server personal":

    http://www.sibaclub.com/files/SQL%20SERVER%20PERSONAL.zip

    stay in this page and not complete:

    http://8pic.ir/images/6905kqwtvyl3fpw81dbt.jpg

    installing stay and freez in this massage:

    setup is installing microsoft data access components (mdac)...


    • Edited by HosseinE Friday, August 14, 2015 6:21 AM sql link
    • Proposed as answer by S.Info Monday, September 28, 2015 12:09 PM
    • Unproposed as answer by S.Info Monday, September 28, 2015 12:10 PM
    Thursday, August 13, 2015 4:45 PM
  • Try this (You'll need SQL SP4 also):

    1. Extract SP4
    2. Copy `..SP4\x86\other\sqlredis.exe` to `..\originalinstallpath\x86\other` 
    `(this avoid mdac insall freezing)`
    3. Create this folder structure (any place): 
    - `Microsoft SQL Server\80\Tools\Binn`
    - `Microsoft SQL Server\MSSQL\Binn`
    6. Find out sqlunirl.dll on `SP4` path and copy to **Binn** folder above
    7. Copy `dll` files on `..SP4\x86\setup` to `Microsoft SQL Server\MSSQL\Binn` (folder above)
    8. Copy folder structure (created on step 3) to `C:\Program Files (x86)`
    -Give full access to user logged to **Microsoft SQL Server** folder
    9. Change install compatiblity `..\originalinstallpath\x86\setup\setups­ql.exe` 
    - `XP SP2`
    - `Run as administrator`

    Tutorial:

    https://www.youtube.com/watch?v=xKoS6VyBaKU

    • Edited by S.Info Monday, September 28, 2015 12:13 PM
    Monday, September 28, 2015 12:11 PM
  • I also had the same issue and easiest way to install with compatibility settings

    I was able to run with compatibility of Windows XP SP 3

    Right click the installer > Click Properties> Under Compatibility tab> choose OS (Windows XP Service Pack 3)

    Saturday, May 27, 2017 9:13 AM