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