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 fromAtHocsales in a folder on your local computer. This folder contains theBlastConfiguration.batandBlastConfiguration.sqlfiles.
- Open theBlastConfigurationfolder on your local system.
- Right-click theBlastConfiguration.batfile. ClickEditand open the file using Notepad.
- Add the database server instance name, ngdelivery database server name, and the SA user password to theBlastConfiguration.batfile 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 <> -d <DatabaseServerInstanceName> -U sa -P "<NGDeliveryDBName>" -i "&&G" PAUSEDSAUserPassword
- Save and close theBlastConfiguration.batfile.
- Open theBlastConfiguration.sqlfile.
- 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.