Avalanche powered by Wavelink

This page refers to an older version of the product.
View the current version of the User Guide.

Allowing Remote Access to the Database

If you currently use PostgreSQL or Microsoft SQL Server on the same computer as Avalanche, you do not need to configure the server for remote access. However, if your database server is on a different machine from where you will upgrade Avalanche, it must be configured to allow remote access.

To configure a PostgreSQL database for remote access:

1.On the machine where the database is running, navigate to:

[PostgreSQL installation directory]\9.x\data

-Or-

[Avalanche installation directory]\db\data

2.Using a text editor, open pg_hba.conf.

3.Add the following line:

host all all 0.0.0.0/0 md5

Where 0.0.0.0/0 is the range of addresses you will accept a connection from. For example, 10.10.29.0/24.

4.Save your changes and close the file.

5.Restart the PostgreSQL Server database service.

To configure the Microsoft SQL Server database for remote access:

1.Launch SQL Server Management Studio.

2.In Object Explorer, right-click on your server and select Properties.

3.Click Connections.

4.Under Remote server connections, select Allow remote connections to this server.

5.Click OK to save the changes. Changing this setting does not require restarting the server.

6.Ensure TCP/IP protocols are enabled and your firewall is set to allow port 1433. For information on enabling TCP/IP, see Setting Up Microsoft SQL Server.