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