Skip to main content

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

Article # 3016731 - Page views: 533

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.