Page History

...

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, mostly sa}; Password={password}; Connection Timeout=300