Skip Navigation

Configure the database server

  • You will need the following information before you configure the database server:
    • The database server name.
    • The SA user password.
    • The name of the ngdelivery database.
  • Place the BlastConfiguration folder that you obtained from 
    AtHoc
     sales in a folder on your local computer. This folder contains the 
    BlastConfiguration.bat
     and 
    BlastConfiguration.sql
     files.
  1. Open the 
    BlastConfiguration
     folder on your local system.
  2. Right-click the 
    BlastConfiguration.bat
     file. Click 
    Edit
     and open the file using Notepad.
  3. Add the database server instance name, ngdelivery database server name, and the SA user password to the 
    BlastConfiguration.bat
     file as shown in the following example:
    @echo off @echo Configuring the Blast Plugin rem update the database information in the below statement. Remove the <> from <value> and add the respective values. for %%G in (*.sql) dosqlcmd -S <
    DatabaseServerInstanceName
    > -d <
    NGDeliveryDBName
    > -U sa -P "<
    SAUserPassword
    >" -i "&&G" PAUSED
  4. Save and close the 
    BlastConfiguration.bat
     file.
  5. Open the 
    BlastConfiguration.sql
     file.
  6. Verify that the @deviceType value is 
    'ucmIpPhone'
    .
    DECLARE @deviceType NVARCHAR(50) SELECT @deviceType='
    ucmIpPhone
    ' IF NOT EXISTS (SELECT * FROM NGDeliveryAccount.dbo.DatacenterSiteDetail . . .
When you log in to the database server, there is a 
ucmlpPhone
 entry in the 
deviceType
 column in the 
ngdeliveryaccount
 > 
DatacenterSiteDetail
 table.