Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Timeout
Message
De
23/05/2003 11:56:59
 
 
À
23/05/2003 11:40:11
David Brunelle
Université de Sherbrooke
Sherbrooke, Québec, Canada
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00792261
Message ID:
00792275
Vues:
26
It looks like the name lookup is very slow, you may need to increase the connection timeout in ADO or whatever you're using. Try using the TCP/IP address instead of the computer name. You can also set up a TCP/IP alias from client computers to SQL Server (run "cliconfg" from the command prompt and map a name to an IP address).

Roman


>Hi, I just installed an SQL server 2000 on a server that is connected in our intranet. When I try to connect to it via another computer, it first always gives me a timeout error, but if I retry right after that, it connects without problems. This is a major problem because I have plenty of application that requires this server to run now that the development stage of my applications are almost all finished. Does anybody have an idea of what could be causing this problem. Note, no matter how long it waits for the timeout, the second time it always work.
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform