...
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.
| Code Block |
|---|
Server={server -name};Database={database -name};User Id={username, mostly sa}; 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
