Best Known Method for installing Avalanche 6.x using MSSQL Server 2008 R2 Express DB or 2012 Express Advanced

Version 4

    Verified Product Versions

    Avalanche 6.1Avalanche 6.0Avalanche 5.3Avalanche 6.2

    Note: BK for Avalanche 6.0 fresh install with local MS SQL Server 2008 R2 Express DB is attached via PDF


    Note: We currently support Windows Server 2012 R2 through 2016


    Important Reminders:

    • Contact your salesperson for the download link to the latest release of Avalanche.
    • Download Microsoft SQL Server 2012 Express or higher from Microsoft's website. (Currently support through 2016)
    • You will want to install everything as an Administrator.


    How To Install SQL Server Express 2012 for Avalanche 6.2.x


    Run the installer for SQL (In this example I am using SQL Server 2012 Express Advanced SP3).

    Click New SQL Server stand-alone:



    Agree to the terms and click Next



    Allow tasks to complete.  You will see the splash screen change and flash several times.

    Typically, leaving the default features to install is ok to do.  What is important is to make sure that Database Engine Services, SQL Server Replication, Management Tools Basic and SQL Client Connectivity SDK  are selected.  Click Next.



    Select Default instance and click Next



    On the following screen simply click Next



    Select Mixed Mode, set your password (Note:you will need this during install of Avalanche) and click Next



    Check Install only and click Next



    Click Next



    Wait for installation progress to complete.  This will take between a half hour to an hour typically.



    Click Close



    Close out the Installation Center



    Next open the SQL Server Configuration Manager



    Open the SQL Server Network Configuration tree, select Protocols for MSSQLSERVER, select and right TCP/IP and click Enable.



    Click OK on the message box that appears.



    Select SQL Server Services, right click SQL Server (MSSQLSERVER) and click Restart.  Then close the Sql Server Configuration Manager



    Installing Avalanche 6.x


    You can obtain the download link for the latest release from your sales contact.

    Install as administrator.

    Note: Issues have been seen during the install if UAC (User Account Controls) has not been disabled.


    Start your installer, click Run, select your language when you are prompted and click OK.



    Go over the Pre-Install checklist if necessary and click Next.



    Select the destination of install and click Next.



    Select New Installation and click Next.



    Select desired features and click Next.  (It is recommended to leave these at default, but anything left out can be installed later by re-running the installer)



    Enter in the requested information.  Hostname is localhost (if you have installed SQL to the same machine), Username is sa (if you chose default instance and mixed mode during SQL install) and Password is the password you setup for your database.  Click Next.



    Select Yes to the next two popups.



    Click Next.


    Click Next.



    Wait for installation to complete.



    Click Finish.



    Your installation is now complete.  You can launch your console.  We recommend using Chrome to do this.