I'm trying to move site to new server (server 2022) but kept sql at 2017, copied dnn directory and restored database, set permission on folder to IISAPPPOOL\sitename
webconfig use: error Can't find: Requested URL: /Install/InstallWizard.aspx comment: don't want install - moving old site
webconfig use: error: Connection To The Database Failed
Database has IISAPPPOOL\sitename and set as dbowner Used udl to test db connection, OK and SSMS has no problems DNN 9.2.2 - Wanted to export but that doesn't work in 9.2.2 Using dnndev.me to test
Can DNN 9.2.2 run on Server 2022. How do I solve db connection error?
I too am looking to move the IIS only part (from Windows Server 2008 R2 to Windows Server 2022).
Currently running DNN 9.10.02 (0)
did you create a SQL Server account for IISAPPPOOL\appPoolName (IIS AppPoolName is by default same as IIS website name)?
you also need to grant at least full modify permission to it for your database (or dbowner permission)
To correct some typos in Sebastian's post: The application pool identity is "IIS AppPool\AppPoolName" (mind the space between IIS and AppPool). Use Integrated Security to connect. If IIS and SQL Server are not running on the same machine but in the same Windows Domain, then you have to use "DOMAIN\ServerName$" for the login and database user, and mind the firewall rules. If they are on different Windows Domains or not domain members (e.g. in a DMZ), then you have to use an SQL Server login.
db_owner is a bit much for the daily operation of a DNN website (although you need this for installing/upgrading DNN or extensions), but db_datareader and db_datawriter is too less. Read more here: Secure your DNN Database by some simple steps (dnncommunity.org).
Happy DNNing! Michael
I finally fixed this. The error "Can't find: Requested URL: /Install/InstallWizard.aspx" means that DNN can't read web.config. Wish I had kept URL that explained this and probable source of error. On live site DNN web.config redirects autodiscover to mail server. On test site, not necessary but did not remove xml from web.config. After removing that line, everything worked. Difficult to troubleshhot as web.config was valid xml but DNN doesn't 'understand' or skip xml it doesn't understand. The cryptic error message did not help. Thank you Sebastian and Michael for suggestions. Will try to upgrade to DNN v9.10.2 (Using Suggested Upgrade Path) and then upgrade SQL Express to 2019. If everything works, will take site live and let you know.
Trying to upgrade from 9.2.2 to 9.3.2
"progress":58,"details":"ERROR occured - Installing Library - DNNCE_SiteExportImport_09.03.02_Install.zip","check0":"Done","check1":"Retry Errors 1"
2022-03-28 17:13:36,054 [s311074][Thread:19][ERROR] DotNetNuke.Data.SqlDataProvider - System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'oa_Export_GetActiveTabModules' in the database. at System.Data.SqlClient.SqlConnection.OnError(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& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:06341db9-5dbc-420c-80f1-8d15790d41c9 Error Number:2714,State:3,Class:16 2022-03-28 17:13:36,076 [s311074][Thread:19][ERROR] DotNetNuke.Data.SqlDataProvider - System.Data.SqlClient.SqlException (0x80131904): Procedure or function dbo.oa_Export_GetActiveTabModules has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(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& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:06341db9-5dbc-420c-80f1-8d15790d41c9 Error Number:8144,State:3,Class:16 1. Should I stay at version 9.2.2?
2. Should I try upgrading by removing "export" module from upgrade package?
3. there is no table oa_Export_GetActiveTabModules or stored procedure but there is a function
Is there a way to fix this?
This is very interesting... I can't find the string oa_Export_GetActiveTabModules in any SQL script, and also not in my database (DNN 9.10.2, even in portals that have been installed in DNN 6.0.0 and upgraded). Therefore I guess it is part of a third party extension.
oa_Export_GetActiveTabModules
Have you created an individual upgrade package that contains upgrades for certain modules or other extensions? In this case I would recommend to use the standard upgrade package and install the extension(s) after upgrade.
There could also be some leftovers in the /install/modules, /install/skins ... folder, please check them before upgrading.
The important first step is to find out where this function comes from (or to which component it belongs). You can also try (in a testing environment) to delete the function before upgrading and then check if it is there after the upgrade.
I guess (no, I am quite sure) that Sebastian will read it here. The .resources files in the install folder (and below) are nothing but renamed .zip files normally. They contain the installer packages for the appropriate extensions. This is what I meant by "individual" upgrade package. You may drop the installation packages (as .zip files) in the correct folder (/modules for modules, /skins for skins (=themes), /language for language packs etc.) before starting the upgrade. These extensions will then also be updated during the upgrade process (when the file extension is .zip). When the file extension is .resources, they won't be installed during the upgrade, but you can install these components from the Extensions screen - you will find them as "Available extensions" (as far as I remember). But sometimes there are leftovers from older installations, so I check these folders always before running an upgrade. Happy DNNing! Michael
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:
Awesome! Simply post in the forums using the link below and we'll get you started.