1.12 Setting Up MSDE

Microsoft SQL Server 2000 Desktop Engine (MSDE) is a reduced version of Microsoft SQL Server. AppManager for Avaya Communication Manager supports the use of MSDE Service Pack 4 in limited environments, such as those with only one Communication Manager.

Before you can create the Avaya CM supplemental database, install or configure MSDE if you do not use a full version of Microsoft SQL Server. For more information, see Understanding the Avaya CM Supplemental Database.

To set up MSDE for use with AppManager for Avaya Communication Manager:

  1. Download the MSDE package from the Microsoft Web site:


    Microsoft SQL Server 2000 Service Pack 4 SP4 is a cumulative service pack containing all of the fixes from previous service packs, including fixes for SQL Server 2000 Desktop Engine (MSDE) components.

  2. Follow the instructions on the download page to save SQL2000.MSDE-KB884525-SP4-x86.EXE to disk. After saving it, run it from the disk and accept the license agreement. By default, the package extracts itself to the C:\SQL2KSP4 folder.

  3. Open a command prompt window and navigate to C:\SQL2KSP4.

  4. You use command-line arguments to install MSDE. See the ReadmeSql2k32Sp4.htm file for explanations of the various options. The following is just one possibility:

    setup SAPWD=mypassword SECURITYMODE=SQL /L*v c:/MSDELog.log

    The preceding argument installs MSDE to the default instance, sets up mixed mode security, and sets the sa password. The /L*v c:/MSDELog.log at the end causes a verbose installation log to be written to the c:\MSDELog.log file. Note the forward slashes used in the filename when specifying it on the command line.

    The MSDE installation does not automatically start the MSSQLSERVER service.

    NOTE:By default, this installation of MSDE does not enable network protocols, which means you cannot connect to it remotely. According to the MSDE documentation, you can specify DISABLENETWORKPROTOCOL=0 on the command line to enable network protocols. You can also use the SQL Server network configuration utility.

  5. From the Control Panel, double-click Administrative Tools, and then double-click Services. Confirm that the MSSQLSERVER service is set for Automatic startup. Set the SQLSERVERAGENT service to Automatic startup.

  6. On the desktop, right-click My Computer and select Properties. In the System Properties dialog box, click the Advanced tab and then click Environment Variables. Confirm that C:\Program Files\Microsoft SQL Server\80\Tools\Binn is in the PATH environment variable. It should have been added to the path by the MSDE installation. If not, add it yourself.

  7. To enable network protocols, navigate to the C:\Program Files\Microsoft SQL Server\80\Tools\Binn folder and run svrnetcn.exe.

  8. Move the TCP/IP protocol from the Disabled list to the Enabled list and click OK.

  9. Reboot the computer to ensure the PATH environment variable is propagated to all services. Rebooting also automatically starts up the MSSQLSERVER and SQLSERVERAGENT services.