Home » database

Tag: database

Manually Update the config file to change Forcast 5 server or database

If you have a network license and you wish to store the Forecast 5 database on a server, you will need to update the config file to point to the correct server and database.

  1. On the server, go to this path: C:\ProgramData\Forecast 5 Ltd
  2. Edit the file Forecast5Config.xml in notepad.
  3. Find the line below and enter the correct database name by changing the coloured lines below to the server name and the database name:

Data Source=(LocalDB)\MSSQLLocalDB;Initial Catalog=Forecast5v3_2015;Persist Security Info=True;Integrated Security=SSPI;

Or you can add the sa username and password:

Data Source=(LocalDB)\MSSQLLocalDB;Initial Catalog=Forecast5v3_2015;User Id=myUsername;Password=myPassword;

4. Save the config and reopen Forecast 5.