Remote Connected SQL Database Can Be Accessed From One Client But Not The Other

Question

0.00/5 (No votes)

See more:

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.

Posted 16-Oct-14 12:35pm

zillaitor

Add a Solution

Comments

Sergey Alexandrovich Kryukov 16-Oct-14 18:37pm

What do you mean by "client"? If this is the database user, identity (user name and password, user account), this is just the authentication.
—SA

zillaitor 16-Oct-14 18:52pm

Thanks for replying Sergey.
By client I just mean a machine which installs the application and accesses the database via remote connection.
All instances of the application use the same connection string which already works on one client so I don't think its the authentication.

RossMW 16-Oct-14 19:24pm

What is your meaning of remote connection. ie (on the lan or remote via a firewall). If via the firewall then the remote computer may not recognise the connection attributes or have access to the security you are using.

[no name] 16-Oct-14 21:11pm

If one client can connect and work just fine and another client cannot, then it has nothing to do with your code and everything to do with your setup. Check your server setup, firewalls, event logs, compare differences from the one that works and the one that does not, see http://dbaspot.com/sqlserver-server/458011-error-occurred-during-pre-login-handshake-microsoft-sql-server-error-10054-a.html

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MukeshSagar · Answer 1 · 2014-10-16T20:12:00

Solution 1

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.

Posted 16-Oct-14 20:12pm

MukeshSagar