"Process completed unsuccessfully" error when you upgrade a database with the Database Maintenance (98.290.00) screen in Microsoft Dynamics SL

  • Article

This article provides a solution to an error that occurs when you upgrade a database by using the Database Maintenance (98.290.00) screen in Microsoft Dynamics SL 2011.

Applies to:   Microsoft Dynamics SL 2011
Original KB number:   2558944

Symptoms

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 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'

Workaround

To work around this issue, use Microsoft SQL Server Management Studio to change the Remote Query Timeout value to 0. Then, sign in to the Database Maintenance (98.290.00) screen by using Windows Authentication instead of SQL Authentication. To do it, follow these steps:

  1. Open SQL Server Management Studio.

  2. In the Object Explorer pane, right-click the instance of Microsoft SQL Server that hosts the Microsoft Dynamics SL databases, and then choose Properties.

  3. In the Select Page pane, select Connections.

  4. Type 0 in the Remote Query Timeout box, and then select OK.

  5. Sign in to Database Maintenance (98.290.00) by using Windows Authentication.

    Note

    It isn't important whether the Microsoft Dynamics SL databases use Windows Authentication or SQL Authentication. It only important is how you sign in to Database Maintenance (98.290.00).