When Attaché is first run, if a connection to the database is not able to be made automatically, the database connection string can be entered manually using the Database Host Setting Tool that is included in the standard Attaché installation package.
To manually enter the database connection string:
Close Attaché.
Go to the Attaché application directory on the mapped drive of the computer where the Attaché application was installed, (normally C(or network drive):\Apps\AttacheBI).
Right-click the Database Host Setting Tool executable file (AttDBHostSettings.exe) and select Run as administrator.
The Database Host Setting Tool dialog box will open.Type in the Database connection string details.
Note: The Database Host Setting Tool contains detailed information and examples regarding the correct string format. In particular, note that the TCP/IP address of the host server must be specified using a DNS notation. Do not use a dotted IP address.Click the OK button to save the string and close the Database Host Setting Tool.
Open Attaché on the local workstation. If the connection was successful, the login screen will appear.
📌Notes:
In some circumstances, you may not be able to designate the host server using a DNS-based hostname. If you cannot connect for this reason, please raise a new case online and reference the title of this article.
Attaché will not be able to establish a connection to the Attaché database if the server and workstation are on different subnets.