KB76731492: Automation Engine - Error code = 80004005 appears in the Smartnames view

Summary

In the Smartnames view, when executing a database query, the following error appears: "Error code = 80004005".

Symptoms

In the Smartnames view, when executing a database query, the following error appears: "Error code = 80004005".

In tbe bgmd.log you get the following message: "TNServer :Error code = 80004005 (U) [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied." (Source=Microsoft OLE DB Provider for ODBC Drivers)

Solution

Problem can be caused by the database running in Single User Mode, no queries can be executed in this mode.

Single-user mode specifies that only one user can access the database at a time and is generally used for maintenance actions.

The Database should be running in Multi-user mode to execute database queries. Execute following actions to solve the problem:

1. Open the SQL Management Studio and login with the user sa to the correct server and database instance.
2. Select the database that is used for the database query and click the New query button.
3. Type following commands:
   1. ALTER DATABASE Databasename
   2. SET MULTI_USER
4. Click the Execute button.
5. Execute the database query in the Smartnames view.