Remote connection errors

From: Ralphh (Ralphh_at_discussions.microsoft.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 13:19:01 -0800

When trying to connect to 2 of my SQL Servers I am getting General Network
Error. I have run Portqry against both of my servers and they both return
that ms-sql-s Sevice is listening on port 1433. When I try running ODBCPing
I get the following results:

COULD NOT CONNECT TO SQL SERVER

SQLState: 08S01 Native Error: 11
Info. Message: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General
network error. Check your network documentation.

SQLState: 01000 Native Error: 10054
Info. Message: [Microsoft][ODBC SQL Server Driver][TCP/IP
Sockets]ConnectionWrite (send()).

Any advise to get around this issue would be appreciated.

Relevant Pages

  • List SQL servers in a network
    ... Most of the solutions use SQLDMO to list all sql servers in the network like ... public static string[] GetAvailableSQLServers ... - this does not work with Windows XP (see SQLDMO documentation: ...
    (microsoft.public.dotnet.general)
  • Re: sql servers part of workgroup
    ... I don't think automatic log shipping is possible without a domain. ... As for backups to network drives then make sure the network share has ... > I have a client that has a couple of SQL Servers that are> part of a workgroup. ... > Now they want to do some activity such as log shipping,> network backups, etc.. ...
    (microsoft.public.sqlserver.server)
  • Need help On NTBACKUP
    ... Happy X-mas ans holidays ... i have 3 sql servers in my network. ...
    (microsoft.public.windows.server.general)
  • System Area Network Beginners Questions
    ... Network and linking several SQL servers using the VIA protocol. ...
    (microsoft.public.sqlserver.connect)