attempt to write a readonly database

PatrickW2

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

Mine was here -> \SQLDataCompare\SQLSearch 3\Indexes - but yes, that was it, I had no permissions on this dir

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.