How can we help you today? How can we help you today?

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
PatrickW2
0

Comments

2 comments

Sort by
  • Tianjiao_Li
    @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.
    Tianjiao_Li
    0
  • PatrickW2
    Mine was here -> D:\SQLDataCompare\SQLSearch 3\Indexes - but yes, that was it, I had no permissions on this dir
    PatrickW2
    0

Add comment

Please sign in to leave a comment.