Configuring 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 can use the following database platforms:

SQL Server 2008

SQL Server 2012

SQL Server 2014

SQL Server 2016

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.

This page describes how to configure SQL Server. For details about installing SQL Server, see the Ivanti Community article Installing MSSQL Server.

To configure SQL Server

1.Install your desired, supported version of Microsoft SQL Server and Microsoft SQL Server Management Studio. 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.Open SQL Server Management Studio and log in.

3.Navigate to Security > Logins.

4.Right click and select New Login from the context menu.

5.Enter a username.

6.Select the SQL Server authentication option.

7.Enter the database password and confirm it.

8.Clear the Enforce password expiration option.

9.Click OK.

10.Right-click on the new login, and select Properties.

11.Click Server Roles.

12.Select dbcreator.

13.Click OK.

14.Open the SQL Server Configuration Manager, and navigate to SQL Server Network Configuration > Protocols.

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

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

17.Scroll to IPAll, and enter 1433 for the TCP Dynamic Ports field. 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.

18.Click OK, and dismiss the warning dialog box that pops up.

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

When upgrading from Avalanche 5.3 when Microsoft SQL Server is not local to the Enterprise Server, the following tools must also be manually 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 installation, 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. If not, additional troubleshooting is needed.