How to connect to Azure Database

How to connect to Azure Database

If you want to store the Forecast 5 database on an Azure 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 your azure server name and the database name (it is new database, you can create any name that has no spaces or odd characters, e.g. $, % '):

<ConnectionString>Data Source=forecast5server.database.windows.net;Initial Catalog=Forecast5;Persist Security Info=True;Integrated Security=SSPI;</ConnectionString>


Or you can add the SA username and password:


<ConnectionString>Data Source=forecast5server.database.windows.net;Initial Catalog=Forecast5;User Id=myUsername;Password=myPassword;</ConnectionString>

5. Save the config and reopen Forecast 5.



    • Related Articles

    • Database creation: NullReferenceException

      Issue: When trying to create a new database, you are receiving the following error but the database is still created in SQL:  NullReferenceException Object reference not set to an instance of an object. Cause: This is caused by attempting to connect ...

    • Cannot open database "...." requested by the login. The login failed.

      Issue: When trying to open Forecast 5, you are receiving the error below: SqlException Cannot open database "Forecast5V3_2018" requested by the login. The login failed. Login failed for user 'Navsoft\JohnDoe'. at ...

    • Automating SQL database backups

      Because Forecast 5 is not yet a cloud solution and currently uses an SQL database to store your forecasts on either your local PC or server, it is important that you arrange for your SQL database to be backed up. If you use the standard local ...

    • Sending Your Database To Support

      To send your database to support for investigation, please follow the steps below: 1. C:\ProgramData\Forecast 5 Ltd 2. Copy the data folder to your desktop in a zip folder. 3. Attach the zip folder to an email and send to support@forecast5.com

    • SQLException: Failed to update database... because the database is read-only

      Issue/Error: When opening Forecast 5, you are receiving an error: Forecast5 cannot continue because of an exception occured: SqlException. Failed to update database "[database name]" because the database is read-only. Forecast 5 will fail to open. ...