tags:

views:

14

answers:

1
Q: 

Various connection time to SQL Server accross a LAN

I am connecting to a SQL Server Express 2005 on another PC on our company LAN.

On my PC (which has Windows7) the connection is immediate. On our tester PC (who has Windows XP), the connection takes about 5 to 6 seconds every time. This is the same network and the same server.

I am not talking about a connection through an application, but also through the control panel or anything else.

Any suggestion where this time difference may be coming from, what setup option might be involved or how we can speed up the connection on the XP PC?

A: 

Is the XP computer using an IPv4 address while you and the server are using IPv6? Could be an issue with the routers/switches along the way.

Peter Hanneman  2010-07-02 13:00:59
It is not that? The server and the network are not configured to use IPv6. We found the problem however. It was in the conversion between the computer name and the IP address.We use "computer name\sqlexpress" to create the connection. Replacing with "ip address\sqlexpress" sovled the problem. Thanks for your suggestion that helped us figuring the answer.
Philippe Lignon  2010-07-02 13:37:29
That was going to be my next suggestion based on your answer to the previous question. :)
Peter Hanneman  2010-07-02 13:44:51

related questions

Best way to manage database connection for a Java servlet
C# Web Server Connection Problem
PHP's sleep function and client connections
VistaDB Connection Issue Programmatically using SQLConnection and ConnectionString
Common WCF Exception : Connection Unexpectedly Closed
DTS Packages & a Connection to Access
How to determine total number of open/active connections in ms sql server 2005
connecting web parts in sharepoint
Connection to Oracle without a username or password
Best Portable way to connect to SQL server using c++
Connection Forcibly Closed error
Determining when an EDGE connection comes back after a dropout on an iPhone
How can I re-use an existing database connection in phpBB3?
Help:How to make ODBC connection in web.Config file.
Java HttpURLConnection: Can it cope with duplicate header names?
Artificially create a connection timeout error
How to use system_user in audit trigger but still use connection pooling?
Why would a "java.net.ConnectException: Connection timed out" exception occur when URL is up?
java.net.SocketException: Connection reset
Graph Algorithm To Find All Connections Between Two Arbitrary Vertices
HELP SSL GURUs!!! ... Problems with SSL Connection
SQLServer Native Client Error "Connection Busy With Results From Another Command" in SSIS
Fast database access test from .Net
Oracle - What TNS Names file am I using?
How do I connect to a database and loop over a recordset in C#?