New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.

Check and upgrade SQL database compatibility level before Upgrading to DNN 7.x using DNN SQL

Since DNN Platform / evoq 7.0 of the SQL Server 2008 is a minimum requirement for DNN Platform and evoq editions. When upgrading the database or changing to another MS SQL Server compatibility level is not changed automatically , and has to be done manually. For this one can on the Execute SQL feature in DNN create a query in query system to obtain the compatibility level .

For this purpose, the following command can be executed ( <databasename> be replaced by the database name ! ):

Select compatibility_level
From sys.databases WHERE name = ' <databasename> ';


As output we get the following values ​​:

110 = MS SQL Server 2012/2012 R2
100 = MS SQL Server 2008/ 2008 R2
90 = MS SQL Server 200580 = MS SQL Server 2000

and is approximately as shown :



In this case, the compatibility level on MS SQL Server 2005 is set and should be set to at least 100, so that the minimum requirements for DNN 7.0 are met.

However, that we can change this with safety , we need a MS SQL Server 2008 or later . We should then opt for the highest degree of compatibility . The SQL Server version we can check the 'System Info ' function without prompting with the system.

If we assume that a MS SQL Server 2012 is used , we should now set the compatibility level to 110. This can also be performed using the Execute SQL function under System as a script query.


The query should look like this ( <databasename> must be replaced by the database name! ) and 'Run as script' have to be enabled:

ALTER DATABASE <databasename>

We can now perform the previous code again to check whether the change was made.
Now upgrading to DNN 7.x can be start .

 Post is cross postet from my personal blog on


Lucas Jans
To help me plan my budget for 2014, when can we anticipate that SQL Server 2012 (compatability_level 110) will be required for DNN?
Lucas Jans Friday, November 8, 2013 12:57 PM (link)
cathal connolly
@Lucas, we tend to move quite late in the mainstream support cycle ( as the issue is that many hosting providers run "old" versions until they're forced to move to a more recent one due to support ending. From time to time such as from 2000->2005 we move faster as 2005 had features we badly need to use, but at the moment we've only just moved to 2008 as a prerequisite and aren't even talking about moving yet -though as sql 2008 mainstream support ends next year we'll look at it then. As sql 2012 has a mainstream support date of 11/07/2017 , i'd be very surprised if we even start discussing it before 2017 (we usually assess what hosting providers are on and if too many are on the old version and planning on using the extended support date we put the decision off again)
cathal connolly Friday, November 8, 2013 1:58 PM (link)
Matthias Schlomann
@ Lucas, I use the 110 compatibility_level only demonstartion, since this is also supported in DNN 7.x. As a prerequisite of at least 100 compatibility_level to use 7.x for DNN. Cathal has indeed already posted on the Lifetime cycle, so I will not comment on this further.
Matthias Schlomann Friday, November 8, 2013 3:19 PM (link)
Tim McAllister
Cathal, is that to say that the latest version of DNN is not compatible with SQL Server 2012?

Tim McAllister Friday, November 28, 2014 10:47 AM (link)
cathal connolly
@Tim - DNN works with all editions of SQL from SQL2008 and above (I personally use sql 2012 and sql 2014 on a daily basis). In addition DNN works on sql azure.
cathal connolly Friday, November 28, 2014 11:36 AM (link)

Comment Form

Only registered users may post comments.


Aderson Oliveira (22)
Alec Whittington (11)
Alessandra Daniels (3)
Alex Shirley (10)
Andrew Hoefling (3)
Andrew Nurse (30)
Andy Tryba (1)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (37)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Bogdan Litescu (1)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (213)
Chris Paterra (55)
Clint Patterson (108)
Cuong Dang (21)
Daniel Bartholomew (2)
Daniel Mettler (181)
Daniel Valadas (48)
Dave Buckner (2)
David Poindexter (12)
David Rodriguez (3)
Dennis Shiao (1)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (80)
Francisco Perez Andres (17)
Geoff Barlow (12)
George Alatrash (12)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (274)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Kelly Ford (4)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matt Rutledge (2)
Matthias Schlomann (16)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Miguel Gatmaytan (3)
Mike Horton (19)
Mitchel Sellers (40)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Oliver Hine (1)
Patricio F. Salinas (1)
Patrick Ryan (1)
Peter Donker (54)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Sacha Trauwaen (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott Schlesier (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Steven Fisher (1)
Tony Henrich (3)
Torsten Weggen (3)
Tycho de Waard (4)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (40)
Will Strohl (180)
William Severance (5)
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out