Avalanche powered by Wavelink

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

Setting Up Microsoft SQL Server

As part of the installation process, you must set up databases with Microsoft SQL Server to store and access device information.

Avalanche 6.1 can use the following database platforms:

•SQL Server 2008

•SQL Server 2012

•SQL Server 2014

If you install the Express edition, you must use Microsoft SQL Server Express with Tools.

Microsoft SQL Server Express with Tools is available for free commercial use, but comes with hardware limitations that govern the number of CPU cores, memory, and hard drive space that can be used per instance. If you use a different version of SQL Server, you are responsible for all licensing and fees associated.

The steps below are an overview of what you must do to install SQL Server. For detailed steps about installing SQL Server, see the Wavelink Community article Setting up SQL Server 2008 R2 Express.

To set up SQL Server:

1.Install Microsoft SQL Server 2008, 2012, or 2014. Instructions for doing this can be found on the Microsoft Developer Network Web site.

Ensure you use Mixed Mode authentication. Avalanche supports Microsoft SQL Server's Default instance as well as any custom instances.

2.After completing the installation, open SQL Server Management Studio and log in.

3.Navigate to Security > Logins and select New Login from the context menu.

4.Enter a username.

5.Select the SQL Server authentication option.

6.Enter the database password and confirm it.

7.Clear the Enforce password expiration option.

8.Click OK.

9.Right-click on the new login and select Properties.

10.Click Server Roles.

11.Select dbcreator.

12.Click OK.

13.Navigate to SQL Server Network Configuration > Protocols.

14.Locate your server and right-click to select Enable TCP/IP. Dismiss the warning dialog box that pops up.

15.Double-click TCP/IP and click on the IP Addresses tab.

16.Scroll to IPAll and enter 1433 for the TCP Dynamic Ports field.

17.Click OK. Dismiss the warning dialog box that pops up.

18.Navigate to SQL Server Services, right-click your server, and click Restart.

You do not need to create the databases before you install Avalanche; the databases will be created when you run the Avalanche installer.

In some circumstances, communicating with database requires that you must enable TCP/IP for your instance and set it to port 1433 from SQL Server Configuration Manager. This port will also need to be opened through your network and computer firewalls. If you use named instances, you must also open port 1434.