I got this error twice while attempting to install
DNN3 using MSSQL 7 as a back end database. Does DNN require SQL2000 at
a minimum?
Installing DotNetNuke
Version: 03.00.13
Current Settings
| Default Provider |
SqlDataProvider |
| Connection String |
Server=DC2;Database=dnn2;uid=dnnuser;pwd=****; |
| .NET Framework Version |
1.1.4322.573 |
| Windows User |
SE\IWAM_HHI-4F50O980RVH |
| Host Name |
dc2 |
Installation Status Report
00:00:00.500 - Installing Version:
3.0.12
00:00:00.510 - Installing Script:
DotNetNuke.SetUp.SqlDataProvider
00:00:00.600 - Installing Script:
DotNetNuke.Schema.SqlDataProvider
00:00:19.505 - Installing Script:
DotNetNuke.Data.SqlDataProvider
00:00:20.206 - Installing MemberRole
Provider:
00:00:20.206 - Executing InstallCommon.sql
00:00:22.639
- Executing InstallMembership.sql
00:00:24.151 - Executing
InstallProfile.sql
00:00:25.713 - Executing InstallRoles.sql
00:00:27.115
- Upgrading to Version: 3.0.13
00:00:27.876 - Performing General
Upgrades
00:00:29.558 - Loading Host Settings:
00:00:30.059 - Configuring
SuperUser:
00:00:30.539 - Installing Desktop Modules:
00:00:30.539
- Installing Announcements:
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
Server Error in '/dnn2' Application.
The stored procedure 'dbo.AddDesktopModule' doesn't exist.
Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code.
Exception Details:
System.InvalidOperationException: The stored procedure
'dbo.AddDesktopModule' doesn't exist.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
|
Stack Trace:
[InvalidOperationException: The stored procedure 'dbo.AddDesktopModule' doesn't exist.]
System.Data.SqlClient.SqlCommand.DeriveParameters() +1268
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +41
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues)
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter)
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName)
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues)
DotNetNuke.Data.SqlDataProvider.AddDesktopModule(String FriendlyName, String Description, String Version, Boolean IsPremium, Boolean IsAdmin, String BusinessControllerClass) +233
DotNetNuke.Entities.Modules.DesktopModuleController.AddDesktopModule(DesktopModuleInfo objDesktopModule) +37
DotNetNuke.Services.Upgrade.Upgrade.AddModuleDefinition(String DesktopModuleName, String Description, String ModuleDefinitionName, Boolean Premium, Boolean Admin, String Controller, String Version) +130
DotNetNuke.Services.Upgrade.Upgrade.ParseDesktopModules(XmlNode node) +293
DotNetNuke.Services.Upgrade.Upgrade.InstallDNN(String strProviderPath) +1178
DotNetNuke.Framework.Install.InstallApplication() +1004
DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) +220
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
|