Update the config file - point Forecast 5 to a new server or database.

Update the config file - point Forecast 5 to a new 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:

<ConnectionString>Data Source=(LocalDB)\MSSQLLocalDB;AttachDBFileName=C:\ProgramData\Forecast 5 Ltd\Data\Forecast5V3_2015.mdf;Initial Catalog=Forecast5V3_2015;Integrated Security=True;</ConnectionString>

4. Replace with the line below and enter the correct database name by changing the coloured lines below to the server name and the database name:

Note: below is an example of a default SQLExpress instance. DESKTOP-MHDPC00 is the PC/Server you are connecting to. SQLExpress is the instance you are connecting to.

<ConnectionString>Data Source=DESKTOP-MHDPC00\SQLEXPRESS;Initial Catalog=Forecast5v3_2015;Persist Security Info=True;Integrated Security=SSPI;</ConnectionString>

Or you can add the SA username and password:

<ConnectionString>Data Source=DESKTOP-MHDPC00\SQLEXPRESS;Initial Catalog=Forecast5v3_2015;User Id=myUsername;Password=myPassword;</ConnectionString>

4. Save the config and reopen Forecast 5.

Note: you can find the server name by opening SQL Server Management Studio:

    • Related Articles

    • Working with connections in Intelligence Reporting

      Creating New Database Connection A Data Connection holds the relevant connection information to connect to a supported ODBC or OLEDB compliant data source. This data connection object is then used for all connections to this data source. By adding a ...
    • Using Velixo Reports in Citrix/Terminal Server enviroments

      Overview  This is a best practices guide for installing and configuring Velixo Reports in a Citrix or Terminal Server environment. The document applies to standalone Citrix/Terminal servers and to Citrix server farms. MSI-Based Installation ...
    • Sharing Report Shortcuts using Intelligence Reporting

      Problem When you create a report shortcut, it creates and points to a file within the AppData directory of the user that created the shortcut, which in turn points to the BICore.exe on the machine. When another user tries to run the report shortcut, ...
    • Replicating Auto-Connection Details on Terminal Server Profiles

      Problem: You are trying to replicate the auto-connection details on load balanced terminal servers or across multiple user profiles without requiring to send out all the details to the users. Solution: Configure the auto-connection on an ...
    • Moving Forecast 5 from one machine to another

      If you have a Single Computer License and you change computers, there are two ways to do keep your forecasts: Method 1: For those using Localdb - Moving the Data Folder On your old PC, go to C:\ProgramData\Forecast 5 Ltd - please note this is ...