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

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.


The error is caused by the Forecast 5 database being set to Read-Only


 

Solution:


The solution will be to open the database in SQL Server Management Studio, locating the server Forecast 5 database is on, finding the correct database.

Right-click on the database and select properties.

 

Select Options from the left-hand menu. Under the State heading, find "Database Read-Only" and change to "False. Click Ok.

 


    • Related Articles

    • 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 ...
    • 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 ...
    • Version Control: Unable to access Forecast 5 after update

      Issue: After running the update, Forecast 5 begins to load, the error below flashes and it closes down: "The Forecast 5 Client you are running has a newer version than the database you are connecting to. Ensure that the db user you are connecting ...
    • SqlException Incorrect syntax near ','.

      Error Message: TargetInvocationException Exception has been thrown by the target of an invocation. SqlException Incorrect syntax near ','. at Forecast5.DataAccessLayer.Forecast5Db_SQL2008.Save(IDbTable entity, IEnumerable`1 columns, IEnumerable`1 ...
    • SqlException: Incorrect syntax near...

      Issue / Error Message: When trying to import the record list from excel or hotlink to a spreadsheet, the error message below or similar occurs: SqlException Incorrect syntax near 's' Unclosed quotation mark after the character string ...