无法使用HeidiSQL连接到LocalDB [英] Unable to connect to LocalDB with HeidiSQL

问题描述

我一直在尝试使用最新版本(此时)的heidisql连接到localdb实例，但无济于事.

I have been trying to connect to a localdb instance with the latest version (at this time) of heidisql to no avail.

我已经按照此答案中的说明进行了操作，但似乎不再起作用了:

I have followed the instructions from this answer here but it doesn't seem to work (anymore):

HeidiSql与MS SQL Server LocalDB的连接

我尝试了以下操作:

1)heidisql -d = LocalDB -h =％pipename％-n = 3 -d = LocalDB

1) heidisql -d=LocalDB -h=%pipename% -n=3 -d=LocalDB

2)heidisql -d = LocalDB -h = np:\.\ pipe \ LOCALDB#41CF9FCB \ tsql \ query -n = 3 -d = LocalDB(我意识到每次启动新的localdb实例时数字都会改变)

2) heidisql -d=LocalDB -h= np:\.\pipe\LOCALDB#41CF9FCB\tsql\query -n=3 -d=LocalDB (i realize that the number changes every time your start a new localdb instance)

3)heidisql -d = LocalDB -h = 41CF9FCB -n = 3 -d = LocalDB

3) heidisql -d=LocalDB -h=41CF9FCB -n=3 -d=LocalDB

有什么想法吗?

编辑

错误消息

推荐答案

对于我的Web.config;

<add name="WEDOBADGEDatabase" connectionString="Data Source=(LocalDb)\development;Initial Catalog=WEDOBADGE;AttachDBFilename=|DataDirectory|\DevelopmentDatabase.mdf;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />

最重要的信息是Data Source=(LocalDb)\development，[用正确的路径&替换(当然)C:\Program Files\Microsoft SQL Server\120\).使用Data Source=(LocalDb)\之后的连接字符串中选择的正确名称(不区分大小写，在我的情况下为development)]试试:

Where the most important piece of information is Data Source=(LocalDb)\development, [replacing (of course) C:\Program Files\Microsoft SQL Server\120\ with the correct path & use the correct name chosen in your connection string after Data Source=(LocalDb)\ (noncase-sensitive, development in my case)] try:

"C:\Program Files\Microsoft SQL Server\120\Tools\Binn\SqlLocalDB.exe" info Development

这应该输出类似于:

Name:               Development
Version:            12.0.2000.8
Shared name:
Owner:              hostname\username
Auto-create:        No
State:              Running
Last start time:    8/2/2016 3:20:57 PM
Instance pipe name: np:\\.\pipe\LOCALDB#CDE5547F\tsql\query

从实例管道名称"( 没有 )的初始np: 中复制\\.\pipe\LOCALDB#CDE5547F\tsql\query.另外，您的管道名称可能与我的管道名称不同.

Copy \\.\pipe\LOCALDB#CDE5547F\tsql\query from the "Instance pipe name", WITHOUT the initial np:. Also, your pipe name is likely to be different than mine.

然后您可以像下面这样在HeidiSQL中创建一个新会话:

Then you can create a new session in HeidiSQL like this:

N.B .:网络类型"，主机名/IP"和使用Windows身份验证"很重要；而其他设置(例如数据库")则由您决定，因此您可以将它们保留为空/跳过等.

N.B.: "Network type", "Hostname / IP", and "Use Windows authentication" are important; whilst other settings (such as "Databases") is up to you, so you could leave them empty / skip, etc.

有关管道名称建议，请转到 https://stackoverflow.com/a/33748584/11895 .

Credits go to https://stackoverflow.com/a/33748584/11895 for the pipe name suggestion.

这篇关于无法使用HeidiSQL连接到LocalDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！