Steps to take before installing AMC using an External SQL Database?

Version 1

    Environment

    AMC 5.x and SQL server 2005 and SQL Server 2008 not  SQL Server Express

     

    Question
    What steps do I need to take before installing AMC using SQL Database?

     

    Solution

    You must complete the following tasks before you can install Avalanche with SQL Server:

    *Install Microsoft SQL Server and obtain DBMS licenses.

    *Create the Avalanche databases. The databases must be named avalanche5x and avastats5x (The naming will depend on the version of AMC you are installing (i.e avalanche50  and avastats50).

    *Create the login role for the databases. Avalanche does not support Windows Authentication for the SQL Server login.

    *If you are installing Avalanche in a different location than the database server, you must configure the server to allow remote access.

    *Install the Microsoft SQL Server Native Client and SQL Server Command Line Query Tool for your edition of SQL Server on the machine where you will be installing Avalanche.

     

    Use the Client and Query Tool specific to your edition, downloads are available from www.microsoft.com

     

    *If you are using SQL Server 2005, this will be the Microsoft SQL Server Native Client (sqlncli.msi) and the SQL Server Command Line Query Tool (SQLServer2005_SQLCMD.msi).

    *If you are using SQL Server 2008, this will be the Microsoft SQL Server 2008 Native Client (sqlncli.msi) and the Microsoft SQL Server 2008 Command Line Utilities(SqlCmdLnUtils.msi).

     

    NOTE: When you install the utilities for SQL Server 2008, you must add the path to the sqlcmd.exe file to your system PATH variable.

    *If there is a Guest account on the computer where you plan to install, it should be disabled before installing Avalanche.