SQL Server Common Solutions

SQL Server Common Solutions

As Forecast 5 uses Microsoft SQL Server as a database to store your forecasts, this can also come with some common installation or set up issues.
To help with trouble shooting, we have compiled a list of common issues and solutions to help get you going.
  1. Permissions
    The biggest issue is often due to a lack of permissions, either to the PC itself or the SQL Server (if stored on a shared server).
    1. Check that you have administrative permissions to the PC and the SQL Server. Without this, you are unlikely to be able to proceed and Forecast 5 needs those permissions to connect.
      This article explains how to add permissions through SQL but you will first need admin permissions to complete this: https://support.forecast5.com/portal/en/kb/articles/unable-to-access-forecast-5-after-update

  2. Network Not Discoverable
    If Forecast 5 cannot find your database or server, there are a few causes and solutions:
    1. Check the server name and database name are correct.
    2. Ensure that the SQL Server is running (through SQL Services or SQL Configuration Manager)
    3. Ensure that TCP/IP and Named Pipes have been enabled.
    4. Ensure any firewalls have been temporarily disabled during install
      This article gives more details: https://support.forecast5.com/portal/en/kb/articles/typeinitializationexception-a-network-related-or-instance-specific-error-error-26

    • Related Articles

    • How to upgrade your Forecast 5 database to SQL Express on your local PC

      It is common for larger users of Forecast 5 to upgrade to SQL Express from the standard LocalDb. Upgrading to SQL Express or higher is strongly recommended for multi-user sites, licenses with consolidations and integrations, and network/server ...

    • 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 ...

    • Failed SQL Installation - An error occurred during the setup process of the feature.

      Issue: When trying to install SQL Express, you receive this error: The following error has occurred: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. Cause: This usually happens when installing ...

    • 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. On the server, go to this path: C:\ProgramData\Forecast 5 Ltd Edit the file ...

    • Import Error: SQL Exception: Incorrect Syntax near "s"

      Issue: Receiving this error message when trying to import records, sections or folders. SQL Exception Incorrect Syntax near "s" Unclosed quotation mark after the character string 'WHERE' This error is caused because there is a single quote character ...