CM MatchPoint SQL Intallation

CM MatchPoint SQL Intallation

Prerequisites

1 - CM Matchpoint support SQL Server version since Express edition 2012 ore higher
2 - The server must allow SQL Sever and Windoes Authentication Mode

The installer contains the full DB and requires a folder to be place (we sugest to define a folder like this C:\CMMatchpoint\Data)

Install Steps

Install CM MatchPoint DB Files

1 - From the Installer Select "Server Installation"



2 - Select "Install SQL DB Components"


3 -  Set the Folder where the DB files will be copied to




4 - When the process finish check the folder it will contain the CM MatchPoint DB Files




Attach CM MatchPoint DB Files to SQL Server

5 - Attach the CM MatchPoint DB files to the SQL Server
       - Open SQL Server Management Studio and connect to the SQL server
       - Right Click the Server and Select "Attach Database"
 
 - Locate the CM MatchPoint DB files



When complete the CM MatchPoint database should appear in your SQL Server


Create CM MatchPoint DB user

6 - Select the Security\Login section in SQL Server and create a new login


7 - Define password and permission




When Complete the "mpuser" will appears in the Logins



Troubleshot

Since windows 10 there are some security settings that do not allow to attach the DB due to permission
If you get the error below, this means the CM MatchPoint DB files does not have granted permission to the user you are working with


Solution

Grant permission to the user






    • Related Articles

    • CM MatchPoint Upgrade Guide

      Important: Before you start the installation, make a copy of the MatchPoint server libraries MPDTA, MPPGM, MPLNGEN, MPCOM. Upgrade Guide CM MatchPoint 6.1 to 6.5 1. INI-Settings With the Release 6.5 we are distributing new INI-Files for CM ...

    • CM MatchPoint 7.0 is Available

      Go to the link below to go to Dowbload page for CM MatchPoint 7.0 Build 004 (June 2021) MatchPoint V7.0 Build 004 What’s is New: IBM Web Services Promoter: CM MatchPoint now includes a new module "WebServices promoter", this new module allows CM ...

    • MatchPoint 6.5 is Released

      Go to the link below to download CM MatchPoint 6.5 Build 005, this is the latest release which include all the updates up to December 2019 MatchPoint 6.5 Build 005 What’s is New: JAVA Back-end: The New release back-end has been moved from RPG to ...

    • CM MatchPoint 5.5 is released

      Go to the link below to download CM MatchPoint 5.5 Build 002 MatchPoint 5.5 Build 002

    • How to Configure CM Matchpoint IBM Disptcher

      This scenario explains how you can configure CM MatchPoint TCP/IP protocol services according to the end users needs. TCP/IP does not use, or require, the QCMN subsystem. Therefore, these instructions are based on QCMN not being present. You must ...