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.
- 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). - 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
- Network Not Discoverable
If Forecast 5 cannot find your database or server, there are a few causes and solutions: - Check the server name and database name are correct.
- Ensure that the SQL Server is running (through SQL Services or SQL Configuration Manager)
- Ensure that TCP/IP and Named Pipes have been enabled.
- 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