Skip to main content

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

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. Use Answer ID  to determine the connection string for LocalDb.
  2. Download and install SQL Management Studio Express. See Answer ID .
  3. Open Management Studio and insert the string taken in Step 1 into the Server name field (ie: \\.\pipe\LocalDB#SSDAB123\tsql\query).
  4. Authentication should be set to Windows Authentication (default setting).
  5. Click Options.
  6. Under Connection Properties, change Network protocol to Named Pipes.
  7. Click Connect.