2

how to install SQL 2000 in windows server 2016 OS, Is it possible ,please give me a solution.

Improve this question
4
  • 5
    Nope. Install on an operating system that officially supports 2000, and then upgrade the operating system. Or don't use SQL Server 2000.
    – Aaron Bertrand
    Commented Feb 12, 2017 at 19:06
  • our application software's back end created with SQL 2000 did not support other version of sql
    – EASA
    Commented Feb 12, 2017 at 19:12
  • SQL 2000 is not supported on Windows Server 2016. You can create a virtual machine with windows XP using Hyper-V and install SQL 2000 on it.
    – Scorpion99
    Commented Feb 12, 2017 at 19:43
  • Do you have other Server instances and versions of SQL that you can use? 2008 +
    – Sir Swears-a-lot
    Commented Feb 12, 2017 at 19:52

1 Answer 1

Reset to default
4

I would highly recommend that you take the time and effort required to connect your app to a newer version of SQL, preferably one that is officially supported. i.e 2012+. (SQL 2000, 2005 and 2008 and 2008R2 are all officially obsolete.)

If you have issues with deprecated features or connectivity, SQL 2008R2 supports database compatibility back to 2000. It's still obsolete, but is still a much more sophisticated product than 2000.

Edit: Technically Support for 2008 & 2008R2 is still available from Microsoft through their MS Lifecycle Support Site.

In most cases apps are oblivious to which version of SQL they are on as long as they can connect and the features and functions still work.

Even if you can't do a backup and restore, you should be able to create a new db and use SSIS to import the data. If this is a current application I highly recommend you go back to the vendors for assistance and ask/insist they support current db's. Requiring a 17 yr old db to be able to install or run their software is terrible.

If this is a legacy app and no longer supported I suspect you have a much bigger issue looming than just moving a db.

If this is a legacy app and you just want to keep it running but need to replace hardware, I would consider virtualising the server.

Improve this answer
3
  • 1
    I have an app where the developers constrained it to only install on an instance of SQL Server where the version is 2008 or 2008R2. So stupid.
    – Hannah Vernon ♦
    Commented Feb 12, 2017 at 22:40
  • 1
    I'm sure it made sense.. on the day.. to someone... somewhere... ;)
    – Sir Swears-a-lot
    Commented Feb 13, 2017 at 1:08
  • Your comment about SQL Server 2008 and SQL Server 2008 R2 no longer being supported is not fully correct. If you have an Enterprise Agreement with Microsoft then you have support for both products (Extended Support) until 7/9/2019 with the correct SPs: MS Lifecycle Support Site. You can even apply for 6 years of additional Premium Assurance should you have such requirements.
    – John K. N.
    Commented Feb 13, 2017 at 10:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.