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:
Open the SQL Management Studio and login with the user sa to the correct server and database instance.
Select the database that is used for the database query and click the New query button.
Type following commands:
ALTERDATABASE Databasename
SET MULTI_USER
Click the Execute button.
Execute the database query in the Smartnames view.