Hi

I am installing DNN 5 and getting an error with the install script I have attached the log file (DotNertNuke.Schema.log) output below. I am thinking it is a SQL issue but not sure as no expert.

I am running DNN 5 on UtilDev Cassini with MS SQLExpress 2008.

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.ReadByteArray(Byte[] buff, Int32 offset, Int32 len)
   at System.Data.SqlClient.TdsParserStateObject.ReadInt64()
   at System.Data.SqlClient.TdsParser.ProcessDone(SqlCommand cmd, SqlDataReader reader, RunBehavior& run, 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='public')  begin    declare @exec nvarchar(2000)     declare @name varchar(150)     declare sp_cursor cursor for select o.name as name     from dbo.sysobjects o     where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 )     and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0     and o.name not like N'#%%'     and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_')     open sp_cursor     fetch sp_cursor into @name     while @@fetch_status >= 0       begin        select @exec = 'grant EXECUTE on ' +  @name  + ' to [public]'        execute (@exec)        fetch sp_cursor into @name       end     deallocate sp_cursor  end

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.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantUserDefinedFunctionsPermission(String ScalarPermission, String TablePermission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='public')  begin    declare @exec nvarchar(2000)     declare @name varchar(150)     declare @isscalarfunction int     declare @istablefunction int     declare sp_cursor cursor for select o.name as name, OBJECTPROPERTY(o.id, N'IsScalarFunction') as IsScalarFunction     from dbo.sysobjects o     where ( OBJECTPROPERTY(o.id, N'IsScalarFunction') = 1 OR OBJECTPROPERTY(o.id, N'IsTableFunction') = 1 )       and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0       and o.name not like N'#%%'       and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_')     open sp_cursor     fetch sp_cursor into @name, @isscalarfunction     while @@fetch_status >= 0       begin         if @IsScalarFunction = 1           begin            select @exec = 'grant EXECUTE on ' +  @name  + ' to [public]'            execute (@exec)            fetch sp_cursor into @name, @isscalarfunction            end         else           begin            select @exec = 'grant SELECT on ' +  @name  + ' to [public]'            execute (@exec)            fetch sp_cursor into @name, @isscalarfunction            end       end     deallocate sp_cursor  end
 

I have tried a number of things including rebooting and even reinstalling SQLExpress incase setting had be entered incorrectly, but I can create a working site in VWD2008 so SQLExpress must be working, I think?

Since posting I have got further with install, and managed to get install script tp complete successfully without error and follow the link to my newly installed portal, but to my dismay when I tried to login it failed and came back with 'Handling Error' or 'failed to connect - The connection was refused when attempting to contact localhost.'

I am running on Xp Home SP2 if this will make a difference?

Thanks for the reply.

Chris

same error on my non-english (Regional Settings) test machine. i have fixed @isscalarfunction to @IsScalarFunction and @istablefunction to @IsTableFunction from the 05.00.01 source code. i uploaded fixed version of the DotNetNuke.SqlDataProvider.dll to my website for my customers. if you want it you can download from here and manually upload to your bin folder.