Hello,
I'm trying to set up a local DNN site for development.
I downloaded the Install Package available here:
http://www.dnnsoftware.com/community/download
following the instructions I found here:
http://www.adefwebserver.com/DotNetNukeHELP/DNN5_DevelopmentEnvironment/Default.htm
When I attept to install the site, I get the following error:
0:00 Minutes | 18pct ERROR
occured - System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near MERGE. You may need to set the compatibility level of the current database to
a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL
option of ALTER DATABASE.Incorrect syntax near source. at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection, Action1 wrapCloseInAction) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj, Boolean and dataReady) at ...{much more}
I'm using sql server 2012 express (sql server 10.0.2531), with the compatibility level set to 100 (sql server 2008).
I'm not sure how to get past this as I am somewhat new to DNN.
Thanks!
Michele