Managing the Database and Reporting › Using Microsoft SQL Server as the Arcserve Backup Database › Specify ODBC Communication for Remote Database Configurations

Specify ODBC Communication for Remote Database Configurations

If you have another Arcserve Backup server running that uses Microsoft SQL as its database, you can redirect the local database to the remote machine. Arcserve Backup can use ODBC to connect to the Microsoft SQL server. You can direct the ODBC data source to another server if the server has SQL installed and the Arcserve Backup SQL database is properly set up. You also need to make sure the local server user is authenticated in the remote server.

To specify ODBC communication for remote database configurations

1. Open the Windows Control Panel, select Administrative Tools, Data Sources (ODBC), and System DSN.
2. Add a System Data Source labeled as follows:

   Name: ASNT
   Server: MachineName\InstanceName
   

3. Follow the on-screen instructions to test and complete the configuration.