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

  I found it interesting how tech issues like SQL Search can really disrupt workflows. Has anyone tried adjusting the search settings or checking for recent updates? It seems like small moto x3m changes could make a big difference!

  swiftchief January 22, 2026 10:08

  - 0 +

Add comment

Please sign in to leave a comment.