Have used DNN in the past but stopped around 6.x in 2010. Getting back to it and downloaded the latest package 8.0.4.226 from DNNsoftware download site. Installed the Web Matrix via the links on DNNsoftware site. Got an error and never got to the wizard, so overwrote the files from a downloaded zip file directly from DNNSoftware site. Made it to the install wizard and selected Default, then the next screen started and immediately displayed the following. There are no videos for v8.x with Web Matrix so I haven't a clue as to why I can't get this to work. Any help appreciated. I can't seem to include all the error in this post so here's the starting error.
0:07 Minutes | 18% 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. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 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& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:28bd9268-ca20-4f39-9bed-e227d2924a3b Error Number:325,State:1,Class:15 CREATE