When you upgrade a database by using the Database Maintenance (98.290.00) screen in Microsoft Dynamics SL 2011, you notice that the process stops responding, and you receive the following error message:
Process completed unsuccessfully.
Additionally, you may receive the following error message in the DBBuild.log file:
Could not find stored procedure 'Ut_TableUpgrade'
To work around this issue, use Microsoft SQL Server Management Studio to change the Remote Query Timeout value to 0. Then, log on to the Database Maintenance (98.290.00) screen by using Windows Authentication instead of SQL Authentication. To do this, follow these steps:
Open SQL Server Management Studio.
In the Object Explorer pane, right-click the instance of Microsoft SQL Server that hosts the Microsoft Dynamics SL databases, and then choose Properties.
In the Select Page pane, click Connections.
Type 0 in the Remote Query Timeout box, and then click OK.
Log on to Database Maintenance (98.290.00) by using Windows Authentication.
Note It is not important whether the Microsoft Dynamics SL databases use Windows Authentication or SQL Authentication. It only is important how you log on to Database Maintenance (98.290.00).