"Process completed unsuccessfully" error message on the "Database Maintenance (98.290.00)" screen during a Microsoft Dynamics SL database upgrade

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

Workaround

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:

  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, click Connections.

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

  5. 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).

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×