Hi Everyone,
I am having problems installing DNN 4.4.1 using the Install package and running MS SQL Server 2000. It is a clean install and I get the following error:
00:00:00.156 - Installing Version: 4.4.0
00:00:00.250 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.421 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeE:\Inetpub\Aaf4\DotNetNuke_4.4.1_Install\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:05.781 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeE:\Inetpub\Aaf4\DotNetNuke_4.4.1_Install\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:17.171 - Installing MemberRole Provider:
00:00:17.171 - Installing Script: InstallCommon.sql
00:00:18.593 - Installing Script: InstallMembership.sql
00:00:19.640 - Installing Script: InstallProfile.sql
00:00:19.906 - Installing Script: InstallRoles.sql
00:00:20.390 - Upgrading to Version: 4.4.1 Success
00:00:20.656 - Performing General Upgrades
The first error in schema.log is:
System.Data.SqlClient.SqlException: Invalid object name 'ModulePermission'.
Invalid object name 'Permission'.
Invalid object name 'Roles'.
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)
CREATE VIEW dbo194353218.[vw_ModulePermissions]
AS
SELECT
MP.ModulePermissionID,
MP.ModuleID,
P.PermissionID,
MP.RoleID,
CASE MP.RoleID WHEN - 1 THEN 'All Users' WHEN - 2 THEN 'Superuser' WHEN - 3 THEN 'Unauthenticated Users' ELSE R.RoleName END AS 'RoleName',
MP.AllowAccess,
P.PermissionCode,
P.ModuleDefID,
P.PermissionKey,
P.PermissionName
FROM ModulePermission AS MP
LEFT OUTER JOIN Permission AS P ON MP.PermissionID = P.PermissionID
LEFT OUTER JOIN Roles AS R ON MP.RoleID = R.RoleID
Does anyone have any help or suggestions on this problem?
Thanks
Robert