Alright -> web.config is properly updated. It is directing to the right SQL server IP address with correct username, PW, and DB. That is confirmed.

Here is the issue I'm running into:

---

The wait operation timed out

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.ComponentModel.Win32Exception: The wait operation timed out

Source Error:

Line 13: Protected Sub StartButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles StartButton.Click
Line 14: If Utilities.VersionHelper.SqlPatchNeeded() Then
Line 15: Utilities.VersionHelper.RunSqlPatch()
Line 16:
Line 17: ' restart application


Source File: E:\Webs\(COMPANY)\(WEBSITE)\WWW\SqlPatch.aspx.vb Line: 15

Stack Trace:



[Win32Exception (0x80004005): The wait operation timed out]

[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +392
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +815
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) +1390
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +538
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +290
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection& c) in C:\BVCommerce\2015.0.3.961\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:543
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile, String& ErrorMessage) in C:\BVCommerce\2015.0.3.961\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:525
BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in C:\BVCommerce\2015.0.3.961\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:42
BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in C:\BVCommerce\2015.0.3.961\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:45
SqlPatch.StartButton_Click(Object sender, EventArgs e) in E:\Webs\MarchIndustries\OogalightsBV2015\WWW\SqlPatch.aspx.vb:15
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +134
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +204
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34249

---

Actually, if you're hitting a SQL timeout then debug mode probably won't help; that will only help if you're hitting an ASP.NET page timeout. In the case of a SQL timeout you will need to manually run the database upgrade scripts. This is fairly common when upgrading from very old versions of 5.X and also with very large databases.

The upgrade scripts are found in the /BVAdmin/BVSql folder. You'll need to run the scripts in each folder sequentially starting from the next version after the version that you're currently running. In your case, that means starting with the SP3 folder. In each folder you should run the scripts in this order:

1. SchemaScript.sql
   
2. DataScript.sql
   
3. NonTransactionalScript (this script is only present in the newest versions)