Skip to main content
Kofax

How to connect to ShareScan LocalDb with SQL Server Management Studio Express

  1. Last updated
  2. Save as PDF

The ShareScan LocalDb installation is not installed with a typical Instance name, making it difficult to determine how to connect to it using the Management Studio.

To correctly connect Management Studio to LocalDb:

  1. Determine the connection string for LocalDb.
    1. Open regedit
    2. Go to HKEY_Machine\Software\Nuance\ShareScan or HKEY_Machine\Software\Wow6432Node\Nuance\ShareScan
    3. Find "localDbId" key and copy the value [eg: SH8FB6AC]
    4. Open SQL Manager Studio
    5. Use connection string np:\\.\pipe\LOCALDB#xxxxxxxx\tsql\query where xxxxxxxx is the localDbId key.
      1. [eg np:\\.\pipe\LOCALDB#SH8FB6AC\tsql\query]
  2. Download and install SQL Management Studio Express on the ShareScan server. [LocalDB prevent SQL connections to the db outside of the installed server]
  3. Open Management Studio and insert the string taken in Step 1 into the Server name field (ie: np:\\.\pipe\LocalDB#xxxxxxxx\tsql\query).
  4. Authentication should be set to Windows Authentication (default setting).
    1. you can use SQL authentication with SA user where the PWD: e+C0py2007_@x
  5. Click Options.
  6. Under Connection Properties, change Network protocol to Named Pipes.
  7. Click Connect.