locked
SQL Express 2005 to Windows 2016 RRS feed

  • Question

  • Hello guys, I tried installing SQL Express 2005 in Windows Server 2016 but it's not installing.

    Any workaround on this? We have a legacy software that needs SQL Express 2005.

    Please help. Thanks.


    Every second counts..make use of it. Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.

    Thursday, January 11, 2018 4:36 AM

All replies

  • Hello,

    No, there is no work around, you can not install it on Windows Server 2016.
    SQL Server 2005 is already out-of-support since a long time and it's not possible to install it on newer OS version; it's even not mentioned on Using SQL Server in Windows 8 and later versions of Windows operating system

    Why do you want to use 2005 and not a current version like 2016/2017?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • Edited by Olaf HelperMVP Thursday, January 11, 2018 4:43 AM
    • Proposed as answer by AV111 Thursday, January 11, 2018 5:03 AM
    Thursday, January 11, 2018 4:43 AM
  • Can you use docker ?

    and SQL Server 2005 is more than decade old. have you try to use later SQL Server version with your legacy app. 

    FYI - https://www.sqlskills.com/blogs/glenn/operating-system-support-for-sql-server-versions/


    පුෂ්පකුමාර

    Thursday, January 11, 2018 4:53 AM
  • Hi cguan,

    >>Any workaround on this?

    Instead of installing SQL Server 2005 on Windows Server 2016, you could create a VM with earlier version of Windows on the server then run SQL Server 2005 within it.

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, January 11, 2018 5:49 AM
  • Hi cguan,

    >>Any workaround on this?

    Instead of installing SQL Server 2005 on Windows Server 2016, you could create a VM with earlier version of Windows on the server then run SQL Server 2005 within it.

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Hi Lin, actually this is one of my contingency plan. Thanks.

    Every second counts..make use of it. Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.

    Thursday, January 11, 2018 6:08 AM
  • Can you use docker ?

    and SQL Server 2005 is more than decade old. have you try to use later SQL Server version with your legacy app. 

    FYI - https://www.sqlskills.com/blogs/glenn/operating-system-support-for-sql-server-versions/


    පුෂ්පකුමාර

    Haven't use docker before, will it work without any issues? Thanks.

    Every second counts..make use of it. Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.

    Thursday, January 11, 2018 6:09 AM
  • Hello,

    No, there is no work around, you can not install it on Windows Server 2016.
    SQL Server 2005 is already out-of-support since a long time and it's not possible to install it on newer OS version; it's even not mentioned on Using SQL Server in Windows 8 and later versions of Windows operating system

    Why do you want to use 2005 and not a current version like 2016/2017?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    The SQL is linked to a custom app and it will take a lot of man hours to rebuilt-it to work on the new version. We're actually planning to migrate it but it might need some time for the migration to happen.

    The server is also a decade old also, that's why I want to move it while waiting for the migration thing.

    Thanks.


    Every second counts..make use of it. Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.

    Thursday, January 11, 2018 6:12 AM
  • Glad to help.

    If you have any other questions, please let me know.

    Regards,
    Lin


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, January 15, 2018 7:11 AM