What are the challenges you face when working across database platforms? Take the survey
Options

attempt to write a readonly database

My SQLSearch doesn't work, but I can't determine if this is because I can't write to the installation directory, or if this is because it's trying to write back to a database?

25 Feb 2021 15:29:55.651 [161] ERROR ServerObjectIndexer - Exception while indexing server: 
code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
Tagged:

Best Answer

Answers

  • Options
    @PatrickW2

    I've heard back from the product team. It looks like you are not able to write to the SQLite database, which is used as the index of the database schema. We write to it when we update it after a schema change.

    The SQLite database is saved in %localappdata%\red gate\SQLSearch3\Indexes where you could check the permission for your user account.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.