For the MPBM app to run correctly there are three items that need to be correctly configured:
- The connection to the BudgetModule database, which is the main database of the application
- The connection(s) to the application database(s)
- The server address, which is where the application is installed (often in the format http://{server-address}/{application-name})
BudgetModule database
The connection to the BudgetModule database is specified in during the installation and is filled automatically.
This is also tested during the installation, so after running a fresh successful installation this should be correctly set.
For this refer to Installation of MPBM App.
Connection to application databases
The MPBM application can connect to multiple different application databases (evolution databases).
The connections to these databases are stored in the BudgetModule database in a table called "_as_MPBM_ServerInfo".
In this table a couple of things are required:
- Name, the name of the connection
- Connection string, this is a string containing all connection info in the below format
- Server, this is the sql server instance
- Database, this is the database name
- Username, this is the sql user's username (this is often sa)
- Password, this is the sql user's password
Note: the server/database/username/password are both in the connection string as in the table.
Server={server-name};Database={database-name};User Id={username}; Password={password}; Connection Timeout=300
Server address
The server address should point to the server where the MPBM app is installed.
So this should be of the format http://{server-ip}/MPBMApi
The server address is found in two places:
- The "_as_MPBM_ApiServer" table in the BudgetModule database, where it should be inserted with a name and customerid 0 and apitype 2
- In the file C:\inetpub\wwwroot\MPBMApp\app\core\config\config.json, it should contain two lines
- One with the server address + /server/0
- One with the server address
