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

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

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