I have done a few DNN installations in the past and had no major issues but for the last 2 days have been trying to get a new DNN5 installation completed with no luck.
At first I tried a fresh installation of DNN5 and everything is fine until you get to the database scripts (MS SQL2000) where things get stuck in a loop giving the following error:
Installing Database - Version 5.0.0...Upgrading Database to Version ERROR: See C:\xxx\aaaaaaa\www\Providers\DataProviders\SqlDataProvider\05.00.00.log for more information...Success
undefined...Success
undefined...Success
undefined...Success
undefined...Success
undefined...Success
This just keeps looping giving the undefined...Success error indefinately. The log referred to is empty when viewed.
OK. So I gave up on this and decided to try installing DNN4.09 and then upgrading that to DNN5. The DNN4 installation went faultlessly so I then tried upgrading that to DNN5 and again the problems start.
This time I get the following error:
Upgrading DotNetNuke
Current Assembly Version: 05.00.00
Current Database Version: 04.09.00
Upgrade Status Report
00:00:00.015 - Upgrading to Version: 5.0.0
00:00:00.046 - Executing Script: 04.09.01.SqlDataProvider Error! (see 04.09.01.log for more information)
00:00:00.484 - Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
00:00:07.828 - Performing General Upgrades
00:00:08.406 - Installing Optional Modules:
00:00:08.421 - Installing Optional Skins:
00:00:08.421 - Installing Optional Containers:
00:00:08.421 - Installing Optional Languages:
00:00:08.421 - Installing Optional Providers:
00:00:08.421 - Installing Package File AspNetMembershipProvider_05.00.00_Install:
Followed by:
--------------------------------------------------------------------------------
Server Error in '/' Application.
--------------------------------------------------------------------------------
and the usual Web.Config customErrors mode="Off" page error
However this time the log entries referred to actually contain (respectively) entries including:
System.Data.SqlClient.SqlException: Server user 'xxxx_dbo' is not a valid user in database 'msdb'.
and
System.Data.SqlClient.SqlException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
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)
.......
.......
.......System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Any ideas?