I am installing a fresh dnn3.3.7 using the install version of the zip. Created the database - set the connect string ,set the database owner in web config ( not using dbo) then ran the install
system bombs out on updating the 03.02.03.SqlDataProvider.
errors state that tables users, userportals etc are not found in the database.
if I install using dbo rather then my database owner the install runs ok.
Some time ago I did install 3.3.5 using database owner other then dbo and it install ok.
part of log inserted ----
System.Data.SqlClient.SqlException: Cannot alter table 'UserPortals' because this table does not exist in database 'oztrali_park'.
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)
/* Update the User Portals Table */
/*********************************/
IF EXISTS (select * from dbo.sysobjects where id = object_id(N'Hosting_oziweb.[UserPortals]') and OBJECTPROPERTY(id, N'IsTable') = 1)
BEGIN
ALTER TABLE UserPortals
ADD Authorised bit NOT NULL CONSTRAINT DF_UserPortals_Authorised DEFAULT 1
END
System.Data.SqlClient.SqlException: Invalid object name 'Users'.
Invalid object name 'UserPortals'.
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)
----------------------
usersportals is not altered with the Authorised field and vw_users is not created.
further errors in 03.02.04, 03.03.00,03.03.01,
any one have any ideas on this problem