DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
  • Search Forums
    Advanced Search
Prev
Next
Forums Our Community General Discussion

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

 1 Replies
 1 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Author
Messages
justadev99
New Around Here
Posts: 1
New Around Here
2/9/2022 3: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: 546
Veteran Member
MVP
MVP
You're an MVP!
2/9/2022 8: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.

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

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