Hi folks,

I just tried to install the new DNN version on my server and got the following installation error:

Do you have any idea what went wrong. Several stored procedures could not be installed, because they seem to have invalid column names.


Installation protokoll

Installing DotNetNuke
Version: 04.03.05

Installation Status Report
00:00:00.093 - Installing Version: 3.1.0
00:00:00.249 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.437 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:03.531 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:08.374 - Installing MemberRole Provider:
00:00:08.374 - Executing InstallCommon.sql
00:00:08.828 - Executing InstallMembership.sql
00:00:09.296 - Executing InstallProfile.sql
00:00:09.499 - Executing InstallRoles.sql
 Error!
00:00:09.890 - Upgrading to Version: 3.1.1 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.01.01.log for more information)
00:00:10.968 - Upgrading to Version: 3.2.0 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.02.00.log for more information)
00:00:11.093 - Upgrading to Version: 3.2.1 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.02.01.log for more information)
00:00:11.187 - Upgrading to Version: 3.2.2 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.02.02.log for more information)
00:00:11.202 - Upgrading to Version: 3.2.3 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.02.03.log for more information)
00:00:12.531 - Upgrading to Version: 3.2.4 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.02.04.log for more information)
00:00:12.593 - Upgrading to Version: 3.2.5 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.02.05.log for more information)
00:00:12.640 - Upgrading to Version: 3.2.6 Success
00:00:12.687 - Upgrading to Version: 3.2.7 Success
00:00:12.702 - Upgrading to Version: 3.3.0 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.03.00.log for more information)
00:00:12.734 - Upgrading to Version: 3.3.1 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.03.01.log for more information)
00:00:12.765 - Upgrading to Version: 3.3.2 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.03.02.log for more information)
00:00:12.812 - Upgrading to Version: 3.3.3 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\03.03.03.log for more information)
00:00:12.937 - Upgrading to Version: 4.0.0 Success
00:00:13.218 - Upgrading to Version: 4.0.1 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\04.00.01.log for more information)
00:00:13.296 - Upgrading to Version: 4.0.2 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\04.00.02.log for more information)
00:00:13.312 - Upgrading to Version: 4.0.3 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\04.00.03.log for more information)
00:00:13.327 - Upgrading to Version: 4.0.4 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\04.00.04.log for more information)
00:00:14.140 - Upgrading to Version: 4.0.5 Success
00:00:14.140 - Upgrading to Version: 4.0.6 Success
00:00:14.156 - Upgrading to Version: 4.0.7 Success
00:00:14.156 - Upgrading to Version: 4.3.0 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\04.03.00.log for more information)
00:00:14.187 - Upgrading to Version: 4.3.1 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\04.03.01.log for more information)
00:00:14.218 - Upgrading to Version: 4.3.2 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\04.03.02.log for more information)
00:00:14.343 - Upgrading to Version: 4.3.3 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\04.03.03.log for more information)
00:00:14.609 - Upgrading to Version: 4.3.4 Success
00:00:14.640 - Upgrading to Version: 4.3.5 Error! (seeE:\_myNuke\Providers\DataProviders\SqlDataProvider\04.03.05.log for more information)
00:00:14.796 - Performing General Upgrades

Error Stack

[InvalidOperationException: The stored procedure 'dbo.GetTabByName' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters() +878728
   System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
   DotNetNuke.Data.SqlDataProvider.GetTabByName(String TabName, Int32 PortalId) +120
   DotNetNuke.Entities.Tabs.TabController.GetTabByName(String TabName, Int32 PortalId, Int32 ParentId) +24
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication() +63
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeDNN(String strProviderPath, String strDatabaseVersion) +1348
   DotNetNuke.Services.Upgrade.Upgrade.InstallDNN(String strProviderPath) +1284
   DotNetNuke.Framework.Install.InstallApplication() +1171
   DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) +274
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


DotNetNuke.Schema.log

System.Data.SqlClient.SqlException: Ungltiger Spaltenname (=Invalid Column name) 'UserId'.
Ungltiger Spaltenname 'RoleId'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

Thanks a lot for every answer.
Greetings. Carsten

The database was just created and empty before I installd DNN.

Thanks for fast reply.
Carsten

I'm having the exakt same problem. I'm trying to install on XP Professional, with SQL Express.

Another funny thing is that when I use the "new" connection string, the connection fails, but when I use the 2000/2005 connection with user=sa, the connection works...

BR,
Johan