I changed the servername value in config file from (local) into 127.0.0.1 and teh error fixed but I faced new Error.The Error log is:
Installing DotNetNuke
Version: 04.04.01
Installation Status Report
00:00:00.140 - Installing Version: 4.4.0
00:00:00.203 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.421 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeD:\Nuke\WebSite\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:09.656 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeD:\Nuke\WebSite\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:16.453 - Installing MemberRole Provider:
00:00:16.468 - Installing Script: InstallCommon.sql
00:00:17.031 - Installing Script: InstallMembership.sql
00:00:17.546 - Installing Script: InstallProfile.sql
00:00:17.687 - Installing Script: InstallRoles.sql
00:00:18.015 - Upgrading to Version: 4.4.1 Success
00:00:18.171 - Performing General Upgrades
Server Error in '/Nuke' Application.
--------------------------------------------------------------------------------
Invalid object name 'vw_Tabs'.
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.Data.SqlClient.SqlException: Invalid object name 'vw_Tabs'.
Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:
2) Add the following section to the configuration file of your application:
<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
The DotNetNuke.Data.log is empty but DotNetNuke.schema.log content 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 nuke.[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
System.Data.SqlClient.SqlException: Invalid object name 'TabPermission'.
Invalid object name 'Tabs'.
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 nuke.[vw_TabPermissions]
AS
SELECT
TP.TabPermissionID,
TP.TabID,
P.PermissionID,
TP.RoleID,
CASE TP.RoleID WHEN - 1 THEN 'All Users' WHEN - 2 THEN 'Superuser' WHEN - 3 THEN 'Unauthenticated Users' ELSE R.RoleName END AS 'RoleName',
TP.AllowAccess,
P.PermissionCode,
P.ModuleDefID,
P.PermissionKey,
P.PermissionName,
T.PortalId
FROM TabPermission AS TP
INNER JOIN Tabs AS T ON TP.TabID = T.TabID
LEFT OUTER JOIN Permission AS P ON TP.PermissionID = P.PermissionID
LEFT OUTER JOIN Roles AS R ON TP.RoleID = R.RoleID
System.Data.SqlClient.SqlException: Invalid object name 'FolderPermission'.
Invalid object name 'Folders'.
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 nuke.[vw_FolderPermissions]
AS
SELECT
FP.FolderPermissionID,
F.FolderID,
F.FolderPath,
P.PermissionID,
FP.RoleID,
CASE FP.RoleID WHEN - 1 THEN 'All Users' WHEN - 2 THEN 'Superuser' WHEN - 3 THEN 'Unauthenticated Users' ELSE R.RoleName END AS 'RoleName',
FP.AllowAccess,
P.PermissionCode,
P.PermissionKey,
P.PermissionName,
F.PortalID
FROM FolderPermission AS FP
LEFT OUTER JOIN Folders AS F ON FP.FolderID = F.FolderID
LEFT OUTER JOIN Permission AS P ON FP.PermissionID = P.PermissionID
LEFT OUTER JOIN Roles AS R ON FP.RoleID = R.RoleID
System.Data.SqlClient.SqlException: Invalid object name 'Files'.
Invalid object name 'Tabs'.
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 nuke.[vw_Tabs]
AS
SELECT
T.TabID,
T.TabOrder,
T.PortalID,
T.TabName,
T.IsVisible,
T.ParentId,
T.[Level],
CASE WHEN LEFT(LOWER(T.IconFile), 6) = 'fileid'
THEN
(SELECT Folder + FileName
FROM Files
WHERE 'fileid=' + convert(varchar,Files.FileID) = T.IconFile
)
ELSE
T.IconFile
END
AS IconFile,
T.DisableLink,
T.Title,
T.Description,
T.KeyWords,
T.IsDeleted,
T.SkinSrc,
T.ContainerSrc,
T.TabPath,
T.StartDate,
T.EndDate,
T.URL,
CASE WHEN EXISTS (SELECT 1 FROM Tabs T2 WHERE T2.ParentId = T .TabId) THEN 'true' ELSE 'false' END AS 'HasChildren',
T.RefreshInterval,
T.PageHeadText
FROM nuke.Tabs AS T
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)
CREATE VIEW nuke.[vw_Users]
AS
SELECT
U.UserId,
UP.PortalId,
U.Username,
U.FirstName,
U.LastName,
U.DisplayName,
U.IsSuperUser,
U.Email,
U.AffiliateId,
U.UpdatePassword,
UP.Authorised
FROM Users U
LEFT OUTER JOIN UserPortals UP On U.UserId = UP.UserId
System.Data.SqlClient.SqlException: Invalid object name 'Files'.
Invalid object name 'ModuleDefinitions'.
Invalid object name 'Modules'.
Invalid object name 'DesktopModules'.
Invalid object name 'ModuleControls'.
Invalid object name 'Tabs'.
Invalid object name 'TabModules'.
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 nuke.[vw_Modules]
AS
SELECT
M.PortalID,
TM.TabId,
TM.TabModuleId,
M.ModuleID,
M.ModuleDefID,
TM.ModuleOrder,
TM.PaneName,
M.ModuleTitle,
TM.CacheTime,
TM.Alignment,
TM.Color,
TM.Border,
CASE WHEN LEFT(LOWER(TM.IconFile), 6) = 'fileid'
THEN
(SELECT Folder + FileName
FROM Files
WHERE 'fileid=' + convert(varchar,Files.FileID) = TM.IconFile
)
ELSE
TM.IconFile
END
AS IconFile,
M.AllTabs,
TM.Visibility,
M.IsDeleted,
M.Header,
M.Footer,
M.StartDate,
M.EndDate,
TM.ContainerSrc,
TM.DisplayTitle,
TM.DisplayPrint,
TM.DisplaySyndicate,
M.InheritViewPermissions,
DM.*,
MC.ModuleControlId,
MC.ControlSrc,
MC.ControlType,
MC.ControlTitle,
MC.HelpURL
FROM ModuleDefinitions AS MD
INNER JOIN Modules AS M ON MD.ModuleDefID = M.ModuleDefID
INNER JOIN DesktopModules AS DM ON MD.DesktopModuleID = DM.DesktopModuleID
INNER JOIN ModuleControls AS MC ON MD.ModuleDefID = MC.ModuleDefID
LEFT OUTER JOIN Tabs AS T
INNER JOIN TabModules AS TM ON T.TabID = TM.TabID
ON M.ModuleID = TM.ModuleID
WHERE (MC.ControlKey IS NULL)
System.Data.SqlClient.SqlException: Invalid object name 'Files'.
Invalid object name 'Files'.
Invalid object name 'Tabs'.
Invalid object name 'Roles'.
Invalid object name 'Roles'.
Invalid object name 'Portals'.
Invalid object name 'Users'.
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 nuke.[vw_Portals]
AS
SELECT
PortalID,
PortalName,
CASE WHEN LEFT(LOWER(LogoFile), 6) = 'fileid'
THEN
(SELECT Folder + FileName
FROM Files
WHERE 'fileid=' + convert(varchar,Files.FileID) = LogoFile
)
ELSE
LogoFile
END
AS LogoFile,
FooterText,
ExpiryDate,
UserRegistration,
BannerAdvertising,
AdministratorId,
Currency,
HostFee,
HostSpace,
PageQuota,
UserQuota,
AdministratorRoleId,
RegisteredRoleId,
Description,
KeyWords,
CASE WHEN LEFT(LOWER(BackgroundFile), 6) = 'fileid'
THEN
(SELECT Folder + FileName
FROM Files
WHERE 'fileid=' + convert(varchar,Files.FileID) = BackgroundFile
)
ELSE
BackgroundFile
END
AS BackgroundFile,
GUID,
PaymentProcessor,
ProcessorUserId,
ProcessorPassword,
SiteLogHistory,
Email,
DefaultLanguage,
TimezoneOffset,
AdminTabId,
HomeDirectory,
SplashTabId,
HomeTabId,
LoginTabId,
UserTabId,
(SELECT TabID FROM Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId,
(SELECT RoleName FROM Roles WHERE (RoleID = P.AdministratorRoleId)) AS AdministratorRoleName,
(SELECT RoleName FROM Roles WHERE (RoleID = P.RegisteredRoleId)) AS RegisteredRoleName
FROM Portals AS P
LEFT OUTER JOIN Users AS U ON P.AdministratorId = U.UserID