Christine_Chavez_6412

Cannot open database "{database_name}" requested by the login. The login failed.

Discussion created by Christine_Chavez_6412 on Apr 6, 2017

An error pops up when you login on ARA: 
Cannot open database "{database_name}" requested by the login. The login failed. 
Login failed for user 'automic'.

On ARA Log:
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "{database name}" requested by the login. The login failed. 
Login failed for user 'automic'. 

Cause:
This happens when an ARA client database has been manually deleted and the customer.config file was not updated.
When a database is manually deleted, there is still a reference to this database in the customer.config file.

Each client in ARA has its own database.

Solution:
Example, the <system> data below reference client 100 for ARA7 database. 
this section needs to be removed from customer.config if you drop ARA7

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

Outcomes