If you install 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 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:
Inaccurate
Incomplete
Not what I expected
Other