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.