This section will cover how to run Database Installer. First, MiSP will need to point the SQL server to the CP database.

1. Open" Microsoft SQL Server Management Studio".

2. Select "Database Engine" as "Server Type".

3. Type  "Server name" from CounterPoint in field.

4. Select "SQL Server Authentication" as auth type.

5. Type SQL user credentials in fields

6. Click connect.

 

Connect to Server SQL Server Login:

 

7. Navigate and select CP database name.

8. Make sure CP database name is highlight in blue.

 

Machine generated alternative text: Object Explorer Connect • RR-SANDBOX-OI (SQL Server 140.1000.16f E) Databases System Databases Database Snapshots CPSystem_CPSQL_1 Database Diagrams 1" Tables Views External Resources I" Synonyms Programmability Service Broker Storage Security Security Server Objects Replication Ilii PolyBase Always On High Availability •iii Management Integration Services Catalogs GEJ SQL Server Agent E] XEvent Profiler

 

9. Leave "Microsoft SQL Server Management Studio" running as user open "File Explorer".

 

Now, The CPHive installer must execute the SQL server scripts needed to create the 3 tables needed to help the SQL server monitor changes between Counterpoint and iPaaS.com. The installer will have to use the Deliverator to execute these scripts. In some instances, installer may to execute some scripts manually.

 

1. Open File Explorer

2. Navigate to wwwroot folder. (example path: Local Disk:C-Interpub-wwwroot)

3. Select "CPHive" Folder.

4.  Select "Database Installer" Folder.

5.  Right-click "Deliverator"(Application).

 

 

 

6. Select "Run as Administrator".

7. Right click the (…) button next to "CounterPoint Connector String".

8. Select  SQL server name in "select or enter a server name".

9. Select "use a specified username or password".

10. Type in SQL user credentials.

11. Select CP database in "Select database in the server" field.

12. click ok.

 

Size Quick access Desktop j' Downloads Documents Pictures CPHive CPWebhooks Databaselnstaller JD Scripts This PC Desktop Documents l' Downloads Music Pictures Videos Local Disk (C:) DVD Drive sqlS Network Name Scripts DS_Store Installer I Red Rook Date modified 7/9/2021 3:12 PM 7/9/2021 3:11 PM 7/9/2021 11:46 AM Type File folder File folder DS STORE File Installing: Databaselnstaller Cou-terPoi-t Cornedion :PeßÄ Ho: True:l_"« Folder. Res

 

 

 

Date modified * Quick access Desktop Downloads Documents Pictures CPHive CPWebhooks Databaselnstall Scri pts This pc Desktop Documents Downloads Music Pictures Videos Local Disk (C:) DVD Drive (D•J Network Name Installer Ped Rook Type Size Data Link properties Provo Ca-nec±ion Spec$ fdowhg to comed to SQL Serve "a: I Seled alter name idom&ion to log to the sever : O Use Windows NT Hegräed se:uty @ Use a pectic uw password name: sa • See x Installing: Databaselnstaller Connedion .Persi< Secuty Sw-ceeRRSANDBO Company Ras Folder. Fies I Te*Gd ase Te*GoY Using 'he filename as a Canedim

 

13. Right click the (…) button next to "Company Alias Folder".

14. Follow the folder path specified in the Top-Level Director Level in CounterPoint.

 

♂ un 一 0 一 n 【 Q 3

 

 

 

Installing: Databaselnstaller

 

15. Select the database alias folder specified in CounterPoint.

16. click ok.

 

—ax MGR View Environment Settings Serol n urrter Regatered user Derm a counterpoint Home Point of Sale Inventory Customers Purchasing Sales History Ecommerce Timecards Data Interchange Setup Date & den&ün User Database D.tüsesee System WrsOns 711642021 AL' Crystal Cert&atöns sm 64 Database versOn L 3S.1?_—•••; narr* sa Database server RN-SANDBOX-OI Provder SQLNCUII Items Report Receivings Enter Profile Codes Packet errors O Packets sent Save Envionrr•nt Fe Total errors O Total reads 6127 Total wries 30183 Tax Categories Copyright 2020 NCR

 

 

 

Installing: Databaselnstaller

 

17. Click Verify on both "CounterPoint Connector String" and  "Company Alias Folder".

18. Click "Install".

 

Size Quick access Desktop j' Downloads Documents Pictures CPHive CPWebhooks Databaselnstaller JD Scripts This PC Desktop Documents l' Downloads Music Pictures Videos Local Disk (C:) DVD Drive sqlS Network Name Scripts DS_Store Installer I Red Rook Date modified 7/9/2021 3:12 PM 7/9/2021 3:11 PM 7/9/2021 11:46 AM Type File folder File folder DS STORE File Installing: Databaselnstaller Cou-terPoi-t Cornedion :PeßÄ Ho: True:l_"« Folder. Res

 

19. Click ok on version warning.

20. Write down any errors during install.

 

Note: If errors prevent install, see  CPHive Database Manual Install article before continuing to next step.