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
[Avalanche installation directory]\db\data
2 Using a text editor,
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.
When upgrading with an existing installation Microsoft SQL Server 2008 or 2012 on a machine not local to the enterprise server, the following tools must also be installed:
• Microsoft SQL Server 2012 Native Client
• Microsoft ODBC Driver 11 for SQL Server
• Microsoft Command Line Utilities 11 for SQL Server
In some instances, you may need to verify the path to Microsoft Command Line Utilities. After installing, the
sqlcmd.exe file should be located at
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\. To ensure connectivity from the computer you're installing Avalanche on, open a command prompt and type
sqlcmd -S[Server Address] -U[Microsoft SQL Server User Login] -P[Login Password]. If a
1> appears, you will be able to connect to the database during the Avalanche upgrade. If not, additional troubleshooting is needed.
Was this article useful?
The topic was:
Not what I expected