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)

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

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

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

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

Grant permission to the user