none
SQL Server 2008 - Connection error

    Question

  • Hello,

             I have the following environment on Windows Server 2008 Build 6001.

     

     

    Microsoft SQL Server Management Studio (expires in 180 days)                10.0.1019.17 ((SQL_PreRelease).070524-1510 )

    Microsoft Analysis Services Client Tools                                                 2007.0100.1019.017 ((SQL_PreRelease).070524-1510 )

    Microsoft Data Access Components (MDAC)                                           6.0.6001.16637 (longhorn.070810-2300)

    Microsoft MSXML                                                                                   3.0 6.0

    Microsoft Internet Explorer                                                                      7.0.6001.16637

    Microsoft .NET Framework                                                                      2.0.50727.1414

    Operating System                                                                                  6.0.6001

     

    I am facing connection problems when i try connecting to the DB server from the same machine. The error says " A connection was successfully established with the server, but then an error occured during the login process. (Provider: shared memory provider, error:0 -No process is on the other end of the pipe) (Microsoft SQL Server Error: 233)

     

    The following is the extract from ERRORLOG.

     

    2007-09-24 21:47:54.55 Server      Microsoft SQL Server code name "Katmai" - 10.0.1019.17 (Intel X86)
     May 24 2007 15:26:55
     Copyright (c) 1988-2007 Microsoft Corporation
     Developer Edition on Windows NT 6.0 <X86> (Build 6001: Service Pack 1, v.253)

    2007-09-24 21:47:54.63 Server      (c) 2005 Microsoft Corporation.
    2007-09-24 21:47:54.63 Server      All rights reserved.
    2007-09-24 21:47:54.64 Server      Server process ID is 1752.
    2007-09-24 21:47:54.64 Server      Authentication mode is MIXED.
    2007-09-24 21:47:54.67 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
    2007-09-24 21:47:54.75 Server      This instance of SQL Server last reported using a process ID of 3556 at 9/24/2007 9:37:44 PM (local) 9/25/2007 4:37:44 AM (UTC). This is an informational message only; no user action is required.
    2007-09-24 21:47:54.75 Server      Registry startup parameters:
      -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
      -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
      -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
    2007-09-24 21:47:54.88 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2007-09-24 21:47:54.88 Server      Detected 2 CPUs. This is an informational message; no user action is required.
    2007-09-24 21:47:56.41 Server      Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
    2007-09-24 21:47:57.99 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2007-09-24 21:48:01.20 Server      Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
    2007-09-24 21:48:03.04 Server      The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted.  If you would like distributed transaction functionality, please start this service.
    2007-09-24 21:48:03.61 Server      Database mirroring has been enabled on this instance of SQL Server.
    2007-09-24 21:48:05.08 spid4s      Starting up database 'master'.
    2007-09-24 21:48:08.04 spid4s      SQL Trace ID 1 was started by login "sa".
    2007-09-24 21:48:08.47 spid4s      Starting up database 'mssqlsystemresource'.
    2007-09-24 21:48:08.56 spid4s      The resource database build version is 10.00.1019. This is an informational message only. No user action is required.
    2007-09-24 21:48:10.34 spid4s      Server name is 'WIN-X1XJNZWELC2'. This is an informational message only. No user action is required.
    2007-09-24 21:48:10.48 spid8s      Starting up database 'model'.
    2007-09-24 21:48:11.92 spid8s      Clearing tempdb database.
    2007-09-24 21:48:13.31 Server      The certificate [Cert Hash(sha1) "D92E794EAEFE17FDE3ED5C50124B729427FEBD48"] was successfully loaded for encryption.
    2007-09-24 21:48:13.37 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
    2007-09-24 21:48:13.37 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
    2007-09-24 21:48:13.44 Server      Server is listening on [ ::1 <ipv6> 1434].
    2007-09-24 21:48:13.44 Server      Server is listening on [ 127.0.0.1 <ipv4> 1434].
    2007-09-24 21:48:13.48 Server      Dedicated admin connection support was established for listening locally on port 1434.
    2007-09-24 21:48:13.58 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2007-09-24 21:48:15.96 spid8s      Starting up database 'tempdb'.
    2007-09-24 21:48:16.71 spid11s     Starting up database 'msdb'.
    2007-09-24 21:48:16.71 spid13s     Starting up database 'ReportServerTempDB'.
    2007-09-24 21:48:16.71 spid12s     Starting up database 'ReportServer'.
    2007-09-24 21:48:16.90 spid14s     The Service Broker protocol transport is disabled or not configured.
    2007-09-24 21:48:16.90 spid14s     The Database Mirroring protocol transport is disabled or not configured.
    2007-09-24 21:48:17.61 spid14s     Service Broker manager has started.
    2007-09-24 21:48:18.30 spid4s      Recovery is complete. This is an informational message only. No user action is required.
    2007-09-24 21:48:18.63 spid21s     SQLSQM.EXE cannot be launched. This can either be caused if the required information in the registry is missing or corrupt or SQLSQM.EXE cannot be found.
    2007-09-24 21:48:22.05 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:48:22.05 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:48:27.20 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:48:27.20 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:48:37.20 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:48:37.20 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:49:02.20 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:49:02.20 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:49:42.21 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:49:42.21 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:50:47.21 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:50:47.21 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:51:52.21 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:51:52.21 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:52:52.22 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:52:52.22 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:53:57.22 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:53:57.22 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:55:02.22 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:55:02.22 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:56:07.23 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:56:07.23 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:57:12.23 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:57:12.23 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:58:17.23 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:58:17.23 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:59:22.24 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:59:22.24 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:59:27.24 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:59:27.24 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 21:59:42.24 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 21:59:42.24 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:00:07.24 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:00:07.24 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:00:47.25 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:00:47.25 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:01:52.25 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:01:52.25 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:02:02.25 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:02:02.25 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:02:12.25 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:02:12.25 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:02:37.26 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:02:37.26 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:03:22.26 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:03:22.26 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:03:27.26 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:03:27.26 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:03:37.27 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:03:37.27 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:04:02.27 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:04:02.27 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:04:47.27 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:04:47.27 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:05:52.27 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:05:52.27 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:06:02.28 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:06:02.28 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:06:17.28 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:06:17.28 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:06:42.28 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:06:42.28 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:07:27.29 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:07:27.29 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:08:32.29 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:08:32.29 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:09:37.29 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:09:37.29 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:10:42.29 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:10:42.29 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:11:47.30 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:11:47.30 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:12:52.30 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:12:52.30 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:13:02.30 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:13:02.30 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:13:12.31 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:13:12.31 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:13:32.31 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:13:32.31 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:14:17.31 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:14:17.31 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:15:22.31 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:15:22.31 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:15:32.32 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:15:32.32 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:15:42.32 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:15:42.32 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:16:07.86 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:16:07.86 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:16:47.86 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:16:47.86 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:17:52.86 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:17:52.86 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:18:02.87 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:18:02.87 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:18:17.87 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:18:17.87 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:18:42.87 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:18:42.87 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:19:27.88 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:19:27.88 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:20:32.88 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:20:32.88 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:21:37.88 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:21:37.88 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:22:16.75 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:22:16.75 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:22:42.88 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:22:42.88 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:23:29.47 spid51      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2007-09-24 22:23:29.47 spid51      Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2007-09-24 22:23:29.49 spid51      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2007-09-24 22:23:30.35 spid51      Using 'xpsqlbot.dll' version '2007.100.1019' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
    2007-09-24 22:23:30.68 spid51      Using 'xpstar.dll' version '2007.100.1019' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
    2007-09-24 22:23:30.84 spid51      Using 'xplog70.dll' version '2007.100.1019' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    2007-09-24 22:23:47.89 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:23:47.89 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:24:03.90 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:24:03.90 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:24:18.26 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:24:18.26 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:24:52.89 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:24:52.89 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:25:02.89 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:25:02.89 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:25:12.90 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:25:12.90 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:25:32.90 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:25:32.90 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:26:17.90 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:26:17.90 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:27:22.90 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:27:22.90 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:27:32.91 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:27:32.91 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:27:42.91 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:27:42.91 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:28:07.91 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:28:07.91 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:28:52.91 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:28:52.91 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:29:02.92 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:29:02.92 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:29:17.92 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:29:17.92 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:29:42.92 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:29:42.92 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:30:27.92 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:30:27.92 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:31:27.93 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:31:27.93 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:32:32.93 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:32:32.93 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:33:37.93 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:33:37.93 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:34:37.94 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:34:37.94 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:35:37.95 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:35:37.95 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:36:37.97 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:36:37.97 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    2007-09-24 22:37:42.97 Logon       Error: 17802, Severity: 20, State: 1.
    2007-09-24 22:37:42.97 Logon       The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]

     

    rgds

    Sankar Natarajan

     

     

     

     

    Tuesday, September 25, 2007 7:25 AM

All replies

  • ( I will move this to one of the SQL Server 2008 forums )

     

    Tuesday, September 25, 2007 4:17 PM
  • I am receiving the same errors.

     

    I just upgraded from Beta 3 to RC-0 - once the upgrade was complete and rebooted this error started occuring because of Sharepoint Connections.  I also can't connect to the SQL Instance through SSMS.

     

    I've tried rebooting & restarting services - no affect...

     

    Sunday, September 30, 2007 2:19 AM
  •  Joseph Leathlean wrote:

    I am receiving the same errors.

     

    I just upgraded from Beta 3 to RC-0 - once the upgrade was complete and rebooted this error started occuring because of Sharepoint Connections.  I also can't connect to the SQL Instance through SSMS.

     

    I've tried rebooting & restarting services - no affect...

     

     

    me to.

    I installed (ex-novo) Windows Server 2008 EE RC0 Build 6001 and after I installed SQL Server 2008 CPT July. When I try to connect to the server, I receive the same login errors.

     

    Thursday, October 04, 2007 9:08 AM
  •  

    And I.

     

    SQL 2008 July CTP x64

    Windows Server 2008 RC0 x64

     

    Error recorded in event log:

     

    Log Name:      Application
    Source:        MSSQLSERVER
    Date:          5/10/2007 12:26:00 p.m.
    Event ID:      17802
    Task Category: Logon
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      WKS-0048-08.intergen.org.nz
    Description:
    The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.  [CLIENT: <local machine>]
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MSSQLSERVER" />
        <EventID Qualifiers="49152">17802</EventID>
        <Level>2</Level>
        <Task>4</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2007-10-04T23:26:00.000Z" />
        <EventRecordID>2743</EventRecordID>
        <Channel>Application</Channel>
        <Computer>WKS-0048-08.domain.org.nz</Computer>
        <Security />
      </System>
      <EventData>
        <Data>730a0003</Data>
        <Data> [CLIENT: &lt;local machine&gt;]</Data>
        <Binary>8A450000140000000C00000057004B0053002D0030003000340038002D0030003800000000000000</Binary>
      </EventData>
    </Event>
    Thursday, October 04, 2007 11:35 PM
  •  

    I have the same error, but I tried to connect with SSMS from another machine.

     

    Previously in the Server 2008, I did able the TCP/IP connections and remote connections with Configuration Manager and Surface Area.

     

    I added to firewall: smss.exe (for internet) , sqlservr.exe (for my network) and sqlbrowser.exe (for my network).

     

    In the other machine, I installed SQL Server Katmai ... and I added the ssms.exe to firewall.

     

    I connected to SQL Server on Server 2008 and it was successfully .... I attached a database ....

     

    Warm regards.

     

    Friday, October 19, 2007 3:38 PM
  • I have same problem, and i got some infomation from this thread. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2300504&SiteID=1

    but I neither got next SQL CTP nor roll back System.Data.dll,  who can solve this?

     

    SQL Server Management Studio using System.Data.SqlClient to connect to SQL Server. The SqlClient version can be updated via installing Visual Studio 2008 and/or Vista SP1 Beta. Below is the supported connectivity matrix between System.Data.SqlClient and Katmai:

     

     

    SQL Server 2008 June CTP

    SQL Server 2008 July CTP

    next SQL Server 2008 CTP

    Visual Studio 2008 RTM
    (System.Data.SqlClient)

    No

    No

    Yes

    Visual Studio 2008 Beta2 (System.Data.SqlClient)

    No

    Yes

    No

    Vista SP1 Beta
    (System.Data.SqlClient)

    No

    No

    Yes

    Windows Server 2008 RC0
    (System.Data.SqlClient)

    No

    No

    Yes

    Visual Studio 2005 SP1
    (System.Data.SqlClient)

    Yes

    Yes

    Yes

    Visual Studio 2005
    (System.Data.SqlClient)

    Yes

    Yes

    Yes

     

     

    Saturday, November 03, 2007 1:57 AM