无法从 VB.NET 代码连接到 SQL 服务器.但可以从 Sql Server Management Studio 进

Question

我有一个使用 Visual Studio 2008 构建的旧 VB.NET 应用程序。尝试从应用程序连接到SQL Server时，出现以下错误。

A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: TCP Provider, 
error: 0 - An existing connection was forcibly closed by the remote host.)

我可以使用 Sql Server Management Studio 从同一台计算机连接到同一服务器和数据库。

使用的连接字符串采用以下格式

connectionString="Data Source=devServer;Initial Catalog=dbDev;
Integrated Security=SSPI;Trusted_Connection=yes;Persist Security Info=false;
Connect TimeOut=30" providerName="System.Data.Sqlclient"

如果需要更多信息，请告诉我。谢谢你的时间。

Answer 1

这应该可以帮助您使用非常简单的连接字符串。我在与SQL的所有连接中使用相同的基础。我的所有应用程序都只使用这 4 个部分。如果您需要集成的安全方面，那么您也可以添加它，但是，不要忘记集成的安全性将从运行应用程序的本地计算机中获取。

看看这个函数，显然，你不需要函数本身，但它把它分解成几个部分，祝你好运！

Private Function Creating_SQL_Connection_String() As String
Dim server As String = "SQL"
Dim database As String = "YourDatabaseName"
Dim userid As String = "MyAdmin"
Dim password As String = "MyPassword1"
'NOTE - UID = userid
'       PWD = password, this must have ' and ' afaik!
'       You dont need to explicitly set integrated security =false, so we can leave it out, unless you need it.
'       Denominate each section with a ';'
Dim constr As String = "Server=" & server & ";Initial Catalog=" & database & ";uid=" & userid & ";Pwd='" & password & "'"
Return constr
End Function