Hi there,

We have been struggling with this for the entire day - wondering if someone knows what could be happening here. Thank you in advance for your support!

We just installed DNN 5.4.2 Community for evaluation purposes on a virtual server running Windows Server 2008 SP2 x86. It connects to a SQL Server 2008 R2 Developer Edution install running on a Windows 7 machine. We used the "auto" option and all was successful. Windows Firewall is OFF on the web server and SQL Server machines

We are able to log in as Admin, and register and log in as a user. However, we are not able to log in as Host (using default password dnnhost). Every time we try to log in as host, it takes a long time, and the error below is shown. The browser session then becomes unusable, and needs to be closed before you can reach the default DotNetNuke page again.

Using SQLProfiler we can see that the last thing that happens before the Event is added is'exec sp_reset_connection', before that 'exec dbo.GetUserProfile @UserID=1'. Looking at the trace the time between the very first SQL Statement that hits the server, and the insert error details statement is about 1 min.

Error Details:

------
DotNetNuke.Services.Exceptions.PageLoadException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)     at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()     at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()     at System.Data.SqlClient.TdsParserStateObject.ReadByte()     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()     at System.Data.SqlClient.SqlDataReader.get_MetaData()     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership)     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)     at DotNetNuke.Data.SqlDataProvider.GetModuleByDefinition(Int32 PortalId, String FriendlyName)     at DotNetNuke.Entities.Modules.ModuleController.GetModuleByDefinition(Int32 portalID, String friendlyName)     at DotNetNuke.Web.UI.WebControls.DnnRibbonBarTool.HasToolPermissions(String toolName)     at DotNetNuke.Web.UI.WebControls.DnnRibbonBarTool.ProcessTool()     at DotNetNuke.Web.UI.WebControls.DnnRibbonBarTool.OnPreRender(EventArgs e)     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     --- End of inner exception stack trace ---
------

Thank you in advance!

Take care and have a great day!

Thank you for your help!

We have deleted and re-unzipped all files, and deleted and re-created the SQL Database. Unfortunately the issue is still happening.

The machine is a Windows Server 2008 DC, so no ASP.NET account, but we are using Network Service. We are now going to try a local SQL Server installation (as in production we have a SQL 2008 R2 and  Exchange 2010 running on a Win2K8 R2 DC. We will try the platform installer as suggested this time.

Take care!