Re: SQL clients dropping connections on WAN

From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 07/12/04

  • Next message: David Bock: "Re: SQL clients dropping connections on WAN" 
    Date: Mon, 12 Jul 2004 14:02:31 GMT

    Hi David,

    How about turning OFF AUTO_CLOSE? Does it take effective on your issue?

    Secondly, I suspect it is an network issue instead of SQL Server issue, may
    be something in firewall or network configuration needs checking.
    Unfortunately, I am not an expert on Network, I hope the following
    documents could be helpful

    How to troubleshoot connectivity issues in SQL Server 2000
    http://support.microsoft.com/default.aspx?scid=kb;en-us;827422

    Moreover, would you please show me detailed information of that time-out
    error message? Detailed information, I believe, will bring us closer to the
    resolution

    Thank you for your patience and cooperation. If you have any questions or
    concerns, don't hesitate to let me know. We are here to be of assistance!
     

    Sincerely yours,

    Mingqing Cheng
    Microsoft Developer Community Support
    ---------------------------------------------------------------
    Introduction to Yukon! - http://www.microsoft.com/sql/yukon
    This posting is provided "as is" with no warranties and confers no rights.
    Please reply to newsgroups only, many thanks!

  • Next message: David Bock: "Re: SQL clients dropping connections on WAN"

    Relevant Pages

    • ODBC Connection with SQL Managed Provider
      ... on a "network drive". ... database using the Microsoft .NET Framework 1.1 Data Provider for SQL ... authorizing the user against a table in the SQL server database. ... for the app to display the "splash" screen (which is the first thing it does ...
      (microsoft.public.dotnet.framework.adonet)
    • RE: SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow per
      ... even gone as far as swapping network cables and updating NIC card drivers to ... If the box itself checked out fine, then move on to runnign SQL Server on ... Perfmon, Disk I/O, Pages, Profiler traces, checked locks/blocks, long running ... slow on these boxes to me. ...
      (microsoft.public.sqlserver.setup)
    • Odd connection problem (proxy + internal)
      ... system and can not be placed facing the internet. ... that belongs to our network and also connects to this accounting ... DSN's) to our internal SQL server. ... by installing the Winsock proxy on the SQL server and mapping the ip ...
      (comp.databases.ms-sqlserver)
    • Re: changing db location on sql2000
      ... Tibor Karaszi, SQL Server MVP ... Therefore I wish MS had let us decide if it was ok to use a usb or network share or whatever to store the data. ... Since your USB drive was showed as a network share, SQL Server could not use it for storing database files. ... If your database is very large, you may consider using SAN, NAS etc which are fast and scalable network storage solutions. ...
      (microsoft.public.sqlserver.setup)
    • Re: What is the best way to administering two separate forests?
      ... Now that you mentioned a trust relationship, it actually makes sense to do ... development and SQL Server management for them. ... network and network resources i.e. Exchange, SQL Server, applications, etc. ... We will just have a separate logical network with a separate ...
      (microsoft.public.win2000.networking)