Page History

...

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:

1. The "_as_MPBM_ApiServer" table in the BudgetModule database, where it should be inserted with a name and customerid 0 and apitype 2
   
   Image Added
2. In the file C:\inetpub\wwwroot\MPBMApp\app\core\config\config.json, it should contain two lines
   
   1. One with the server address + /server/0
   2. One with the server address
      
      
   Image Added