DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
Prev
Next

SQL Server 2019 with DNN Platform v.07.03.04 (45)?

Forums > General Discussion
Sort:
You are not authorized to post a reply.





justadev99

New Around Here



Posts:1
New Around Here




2/9/2022 2:53 PM

    SQL Server 2012 is getting ready to be end of life.   We are looking at upgrading to SQL Server 2019, but really 2014 and 2016 would do just as well in a pinch because the site will be shutdown in the next year or so.

    Because we're on DNN Platform v.07.03.04 (45) - there is no official support for it in the documentation, does anyone have any experience running such an older version on any SQL Server version > 2012?  Did you run into issues, etc?

    Thanks

     






    Sebastian Leupold

    Veteran Member



    Posts:539
    Veteran Member




    2/9/2022 7:42 PM
      I don't see any problems using latest version of SQL server, the SQL code used by DNN is not very specific. ONLY, if you really experience unexpected behavior, you may set database compatibility level to 100, which should avoid any different use of newer features.
      Run
      ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = 100
      to perform this change.
      You are not authorized to post a reply.

      These Forums are dedicated to the discussion of DNN Platform.

      For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

      1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy. 
      2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
      3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
      4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
      5. No Flaming or Trolling.
      6. No Profanity, Racism, or Prejudice.
      7. Site Moderators have the final word on approving / removing a thread or post or comment.
      8. English language posting only, please.

      Would you like to help us?

      Awesome! Simply post in the forums using the link below and we'll get you started.

      Get Involved