Sunday, February 12, 2012

Anyway to tell if this is a network issue!

A person using a vb6 windows app can not log into the server from their
machine. They get the error (you failed to connect to the SQL Server) could
be from
1.Not logged on correctly
2.Don't have rights
3.Network down
Client unable to establish connection error # -2147467259.
When the user goes to a different machine they are able to connect ok.
Thanks.
--
Paul G
Software engineer.check the client network utility and make sure it is set to tcp\ip (Not
named pipes)
also check to make sure the nic card on the client machine is set to the
same settings as the server (You probably dont want 'auto' )
Greg Jackson
PDX, Oregon|||Hi pdxJaxon, thanks for the response. Just wondering how to check if the the
nic card on the client machine is set to the same settings as the server?
Also I did a search on Google and found that if the client and server have
different versions of MDAC (Microsoft data access components) it could cause
the error, not quite sure how to find this out.
Also not familiar with the client network utility just wondering how to
access it?
--
Paul G
Software engineer.
"pdxJaxon" wrote:
> check the client network utility and make sure it is set to tcp\ip (Not
> named pipes)
> also check to make sure the nic card on the client machine is set to the
> same settings as the server (You probably dont want 'auto' )
>
> Greg Jackson
> PDX, Oregon
>
>|||Are you the one who wrote this app? Many things involved here:
1. Does the app use ODBC? ODBC driver is local on machine so it works on
the machine having ODBC setup correctly.
2. Is the server local? It may not the case but if 2 machines have
different TCP setup it could cause error.
3. The app uses trusted connection?
4. SQL on server setup with mix or SQL authentication?
There are more. It is hard to tell with this little of info.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:EBEFD042-19C5-40DE-8371-3347520EF9F2@.microsoft.com...
>A person using a vb6 windows app can not log into the server from their
> machine. They get the error (you failed to connect to the SQL Server)
> could
> be from
> 1.Not logged on correctly
> 2.Don't have rights
> 3.Network down
> Client unable to establish connection error # -2147467259.
> When the user goes to a different machine they are able to connect ok.
> Thanks.
> --
> Paul G
> Software engineer.

No comments:

Post a Comment