远程连接的SQL数据库可以从一个客户端访问而不是从另一个客户端访问 [英] Remote Connected SQL Database Can Be Accessed From One Client But Not The Other

问题描述

我已经构建了一个winforms应用程序，该应用程序安装在客户端计算机上，其中SQL Server数据库托管在服务器上，客户端通过远程连接进行访问。



应用程序正常运行按计划在服务器和一个客户端上，但当我尝试从第二个客户端访问相同的数据时，我收到登录前握手错误。



研究我发现了一些解决方案，有些说明我需要启用IPV4和IPV6，其他人说我需要启用远程连接，这不是问题，因为其他客户端已经访问它。



任何人都可以给我任何关于问题的指示吗？



运行的客户端运行：64位处理器，Windows 8 OS。

不运行的客户端：32位处理器，Windows Vista。



Clents也可通过ClickOnce访问应用程序本地网络。

应用程序目标操作系统当前设置为x64 />
我将切换到任何CPU和x86，并在我到办公室时报告是否有任何变化。

I have built a winforms application which is installed on client machines with an SQL Server Database hosted on a server which clients access via remote connection.

The application works as planned on the server and one client but when I try o access the same data from a second client I get a "pre-login handshake" error.

On researching I found a number of solutions, some stating that I needed to enable IPV4 and IPV6 which I did, others stating that I needed to enable remote connection which was not the problem as the other client already accesses it.

Can anyone give me any pointers as to what the problem might be?

The client that works runs: 64 bit processor, Windows 8 OS.
The client that doesn't runs: 32 bit processor, Windows Vista.

Clents also access the app via ClickOnce over a local network.
Application target OS is currently set to x64.
I will switch to any CPU and x86 and report if there are any changes when I get to the office.

推荐答案

亲爱的，检查防火墙设置。或者在要访问的客户端计算机上尝试连接数据库服务器。还要检查应用程序和代码中使用的身份验证模式。

Dear, Check the firewall settings. Or on the client machine where you want to access try to connect with the database server. Also check for the Authentication mode that is used in application & in code.

这篇关于远程连接的SQL数据库可以从一个客户端访问而不是从另一个客户端访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！