Creating Link to the Database

How to create a link to from the archive database to the ToolsNet database and connect them.

Installation is applicable to SQL Server.

The Archive Installer has guiding text for each field.

In the Archive Installer dialog box, go to the Create Link tab and enter the fields as stated below.
DatabaseInstaller path - The path is by default set to C:\ProgramData\Atlas Copco\ToolsNetDatabase\ToolsNetDatabase scripts\AtlasCopco.DatabaseInstaller.exe. If you want to configure it to another path, enter a new path in the path field, or.select Browse to access the location.
ToolsNet database instance - Enter an IP address or archive database server of where the archive information is to be stored.
ToolsNet database name - Enter the ToolsNet database name. For normal installation use AtlasCopco_ToolsNet_Database
User Name - Enter the name of the user to be used for the archive database.
Password - Enter the password used for the archive database installation.
Applicable to installations up to ToolsNet 8.18.

Linked Server Name - Two options are available for this field.
- If the Archive database instance has the same IP address or archive database server as ToolsNet database instance, then the entry field will be disabled and the message No link will be created will be displayed.
- If the Archive database instance has a different IP address or archive database server as ToolsNet database instance, then it is possible to enter the linked server name in the field.
Archive database instance - Enter the archive target database source, it should be the IP address or archive database server where it is stored.
Archive database name - Enter the archive database name.
Applicable to installations up to ToolsNet 8.18.

Linked Server provider - The field will have the default entry SQLNCLI11.
Start date - Select the start date, for when the archive will run from.
End date - Select the end date, for when the archive will run to.
Select Create link to configure the link between the source and the target.
- If the installation has been successful a dialog box will be displayed. Select OK .
- If the installation has been unsuccessful, an installation error dialog box will be displayed. Select OK and go back and check the entered fields.