Upgrade: Database Installer Failed - Timeout during database upgrade


Database times out during upgrade with the following error in the upgrade log file:

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.



Option 1.

You can re-run the installer again to determine if the timeout was due to a sporadic networking issue.

Option 2.

If the timeout continues you can temporarily change the SQL Remote Connection timeout value on your SQL. You can find this setting in SQL Server Management Studio by right clicking on he server name in the Object Explorer window, and selecting properties. Screen_Shot_2016-05-09_at_4.48.41_PM.png


Then, from the menu on the left side of the window select "Connection". Under "Remote server connection" make sure the "Allow remote connections to this server" box is checked. You can change the default value for "Remote query timeout" to "0" for the duration of the DB upgrade. 


Option 3.

If the installer times out again you can run the installer locally on the Database server rather than remotely from the Console or Device Services server. 

NOTE: The installer requires .NET 4.5.2 to run properly. If you do not have .NET 4.5.2 the installer will prompt you to installer it, and will possibly prompt you for a server reboot once it is installed. If you do not want to reboot the server please continue running the installer remotely. 

Have more questions? Submit a request


Article is closed for comments.