SQL search doesn't give results anymore

• 

  Experiencing the same. Relevant config info from “current log”:

  [
    {
      "eventType": "session.started",
      "headers": {
        "productId": "sql-search",
        "productVersion": "3.9.1.6302",
        "createdTimeUtc": "2025-12-10T10:51:05Z"
      },
      "payload": {
        "hostMachine": {
          "software": {
            "operatingSystem": {
              "is64Bit": true,
              "kernelVersion": "10.0.14393.6343",
              "name": "Microsoft Windows Server 2016 Standard",
              "platform": "Win32NT",
              "servicePack": "",
              "compatibilityVersion": "10.0.14393.0",
              "systemDrive": "C:"
            },
            "processInformation": {
              "filename": "Ssms.exe",
              "fileVersion": "20.2.37.0",
              "fullPath": "C:\\Program Files (x86)\\Microsoft SQL Server Management Studio 20\\Common7\\IDE\\Ssms.exe",
              "productVersion": "20.2.37.0"
            }
          }
        }
      }
    }
  ]

  Related log errors:

  2025-12-10 05:51:26.876 -05:00 [Error]  [ServerObjectIndexer]: Exception while indexing server: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
     at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(SQLiteConfigOpsEnum op)
     at System.Data.SQLite.SQLite3.StaticIsInitialized()
     at System.Data.SQLite.SQLiteLog.PrivateInitialize(String className)
     at System.Data.SQLite.SQLiteLog.Initialize(String className)
     at System.Data.SQLite.SQLiteConnection..ctor(String connectionString, Boolean parseViaFramework)
     at System.Data.SQLite.SQLiteConnection..ctor(String connectionString)
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand()
     at RedGate.SQLSearch.Indexing.SQLite.ServerObjectStorage.Initialise()
     at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index(CancellationToken token)
  2025-12-10 05:51:26.895 -05:00 [Error]  [DatabaseObjectIndexer]: Exception while indexing database SampleDB: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
     at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, Byte[] vfsName, SQLiteOpenFlagsEnum flags, Int32 extFuncs, IntPtr& db)
     at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
     at System.Data.SQLite.SQLiteConnection.Open()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand()
     at RedGate.SQLSearch.Indexing.SQLite.DatabaseObjectStorage.Initialise()
     at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken token)
  2025-12-10 05:51:27.337 -05:00 [Error]  [ServerObjectIndexer]: Exception while indexing server: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
     at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, Byte[] vfsName, SQLiteOpenFlagsEnum flags, Int32 extFuncs, IntPtr& db)
     at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
     at System.Data.SQLite.SQLiteConnection.Open()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand()
     at RedGate.SQLSearch.Indexing.SQLite.ServerObjectStorage.Initialise()
     at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index(CancellationToken token)
  2025-12-10 05:51:27.338 -05:00 [Error]  [DatabaseObjectIndexer]: Exception while indexing database SampleDB: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
     at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, Byte[] vfsName, SQLiteOpenFlagsEnum flags, Int32 extFuncs, IntPtr& db)
     at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
     at System.Data.SQLite.SQLiteConnection.Open()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand()
     at RedGate.SQLSearch.Indexing.SQLite.DatabaseObjectStorage.Initialise()
     at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken token)
  2025-12-10 05:51:28.507 -05:00 [Error]  [DatabaseObjectIndexer]: Exception while indexing database SampleDB: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
     at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, Byte[] vfsName, SQLiteOpenFlagsEnum flags, Int32 extFuncs, IntPtr& db)
     at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
     at System.Data.SQLite.SQLiteConnection.Open()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand()
     at RedGate.SQLSearch.Indexing.SQLite.DatabaseObjectStorage.Initialise()
     at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken token)
  2025-12-10 05:51:28.509 -05:00 [Error]  [ServerObjectIndexer]: Exception while indexing server: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
     at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, Byte[] vfsName, SQLiteOpenFlagsEnum flags, Int32 extFuncs, IntPtr& db)
     at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
     at System.Data.SQLite.SQLiteConnection.Open()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen()
     at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand()
     at RedGate.SQLSearch.Indexing.SQLite.ServerObjectStorage.Initialise()
     at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index(CancellationToken token)

  Mike Patrick December 10, 2025 11:09

  - 0 +
• 

  I opened a support request and got a pretty fast response:

  I've been advised that this is a bug when you're using SQL Search with SQL Prompt installed and it's been escalated to the developers.
  
  Using SSMS 21/22 or downgrading to SQL Prompt 11.2.0 will get around this issue for the time being.
  https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_11.2.0.19838.exe

  Downgrading SQL Prompt (from 11.2.1 to 11.2.0) resolved my issue.

  Note, from my preceding post, I'm on a fairly old OS and not-very-new SSMS, so YMMV.

  Mike Patrick December 10, 2025 12:34

  - 0 +
• 

  IN SSMS 22 , SQL search is indeed working, but I had to delete SQL search first and re-install it.

  SQL prompt also isn't showing in SSMS 22, and I can't install it again, because SQL prompt is greyed out. But if I uninstall I will losse all my preferences I guess. Is there any easy way to keep those?

  For now I will work with SSMS 19 where the Toolbelt is working, and only use SSMS 22 for the Search

  MenuGuy December 10, 2025 13:46

  - 0 +
• 

  Same issue encountered. Uninstalled SQL prompt and re-installed SQL prompt v11.2.0 and getting search results now. 

  Terry V. December 10, 2025 23:08

  - 0 +

Add comment

Please sign in to leave a comment.