Can't access

Document ID : KB000087863
Last Modified Date : 14/04/2018
Show Technical Document Details
Affects Release version(s): 7

Error Message :
ARA error on login: Cannot open database "{database_name}" requested by the login. The login failed.
Login failed for user 'automic'.

When an ARA client database is manually deleted and the customer.config file is not updated, you will see errors similar to those above in the ARA log.

When a database is manually deleted, there is still a reference to the database in the customer.config file.

Each client in ARA has its own database.
Cause type:
Root Cause: Manually deleting an ARA client databse does not clean up references to the database in the customer.config file.
Update the customer.config file.

The <system> data below references client 100 for an ARA7 database. 
This section needs to be removed from the customer.config if you drop the ARA7 client database.

<system client="100" password="araservice" user="100/ARASERVICE/AUTOMIC">
            <queuetrigger agent="AGENTNAME" login="UC4_RL.LOGIN.ALL"/>
               <add connectionString="Data Source=tcp:localhost,1433;Initial Catalog=ARA7;User ID=SA;Password=vwaswara03" name="MainDatabase"/>
               <add connectionString="ReportDatabase" name="ReportDatabase"/>


Fix Status: No Fix

Fix Version(s):
Additional Information:
Workaround :