Speed up of connection to SQL Sever from VB.NET

  • Thread starter Thread starter grs
  • Start date Start date
G

grs

I am running a tiny SQL Server 2000 database on a Small Business
server premium edition. I am connecting (using SQL Server security
logins) to it from 2 XP professional workstations each running the same
simple VB.NET program. (I am not running the server as a domain
controller, just using a workgroup.) From one of the machines, the
opening of the database connection is immediate (small fraction of a
second). From the other it is very slow (20 seconds). I have tried to
fool around with network settings, but both machines seem to be set up
with the same parameters. What am I missing? (I had the same problem
previously when the SQL Server was running on another XP workstation.)
 
I am running a tiny SQL Server 2000 database on a Small Business
server premium edition. I am connecting (using SQL Server security
logins) to it from 2 XP professional workstations each running the same
simple VB.NET program. (I am not running the server as a domain
controller, just using a workgroup.) From one of the machines, the
opening of the database connection is immediate (small fraction of a
second). From the other it is very slow (20 seconds). I have tried to
fool around with network settings, but both machines seem to be set up
with the same parameters. What am I missing? (I had the same problem
previously when the SQL Server was running on another XP workstation.)
Click to expand...

You might be connecting through different net libraries from the different
machines. You can take control of the net library by specifying it in your
connection string (otherwise client-side default settings control it).

http://msdn.microsoft.com/library/d...ystemdatasqlclientsqlconnectionclasstopic.asp

TCP/IP will generally give you the most reliable performance on most
networks.

Network Library=dbmssocn

David
 
Correction to previos post. Should read: Absolutely the same. Just sa
as the login, a password and the database
name.
 
Thanks for the reply. I will try it on site when I get there Wednesday.
These systems were originally set up by people with minimal knowledge
of technical matters. I assume everything was defaulted. But it is
worth a try. I will let you know how things work out.
 
I tried it. There was perhaps some improvement, but it still takes over
10-15 seconds to open the SQL server database from this machine. All
other machines take a fraction of a second. I also created manual HOSTS
and LMHOSTS files. This produced a minor improvement. The network
hardware was tested, and everything checked out. I am stumped. Anyone
have any new ideas?
 
Back
Top