Get the PDF

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 IPAWSConfiguration folder that you obtained from

AtHoc

sales in a folder on your local computer. This folder contains the

IPAWSConfiguration.bat

and

IPAWSConfiguration.sql

files.

Open the

IPAWSConfiguration

folder on your local system.

Right-click the

IPAWSConfiguration.bat

file. Click

Edit

and open the file using Notepad.

Add the database server instance name, ngdelivery database server name, and the SA user password to the

IPAWSConfiguration.bat

file as shown in the following example:

@echo off
@echo Configuring the IPAWS Plugin
rem update the database information in the below statement. Remove the <> from <value> and add the respective values.
for %%G in (IPAWSConfiguration.sql) do sqlcmd -S <DatabaseServerInstanceName> -d <NGDeliveryDBName> -U sa -P "<SAUserPassword>" -i "&&G"
PAUSE

Save and close the

IPAWSConfiguration.bat

file.

Open the

IPAWSConfiguration.sql

file.

Verify that the @deviceType values are

IPAWS

and

IPAWSNWEM

DECLARE @deviceType1 NVARCHAR(50)
DECLARE @deviceType2 NVARCHAR (50)
DECLARE @SQL AS VARCHAR (MAX)

SELECT @deviceType1='IPAWS'
SELECT @deviceType2='IPAWSNWEM'

IF NOT EXISTS (SELECT * FROM NGDeliveryAccount.dbo.DatacenterSiteDetail a INNER JOIN ProductInfo b ON a.SiteId=b.SiteId WHERE a.DeviceType=@deviceType1)
    BEGIN
        INSERT INTO NGDeliveryAccount.dbo.DatacenterSiteDetail([DataCenterId],[SiteId] ,[DeviceType],[CreatedOn])
        SELECT 1,siteid , @deviceType1,GETUTCDATE() FROM ProductInfo
    END
IF NOT EXISTS (SELECT * FROM NGDeliveryAccount.dbo.DatacenterSiteDetail a INNER JOIN ProductInfo b ON a.SiteId=b.SiteId WHERE a.DeviceType=@deviceType2)
    BEGIN
        INSERT INTO NGDeliveryAccount.dbo.DatacenterSiteDetail([DataCenterId],[SiteId] ,[DeviceType],[CreatedOn])
        SELECT 1,siteid , @deviceType2,GETUTCDATE() FROM ProductInfo    
    END
IF COL_LENGTH('NGDeliveryAccount.dbo.DatacenterSiteDetail', 'ResourceType') IS NOT NULL
BEGIN
    SET @SQL = 'UPDATE NGDeliveryAccount.dbo.DatacenterSiteDetail SET ResourceType =''RATE'' WHERE DeviceType = ''IPAWS''OR DeviceType = ''IPAWSNWEM'''
    EXEC(@SQL)
END

When you log in to the database server, there are

IPAWS

and

IPAWSNWEM

entries in the

DeviceType

column in the

ngdeliveryaccount

DatacenterSiteDetail

table and the ResourceType is

RATE

Section:

Install and configure the plug-in for NDS