SQL Server 2008 - Connection error
-
Tuesday, September 25, 2007 7:25 AM
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
All Replies
-
Tuesday, September 25, 2007 4:17 PM( I will move this to one of the SQL Server 2008 forums )
-
Sunday, September 30, 2007 2:19 AM
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...
-
Thursday, October 04, 2007 9:08 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 11:35 PM
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: <local machine>]</Data>
<Binary>8A450000140000000C00000057004B0053002D0030003000340038002D0030003800000000000000</Binary>
</EventData>
</Event> -
Friday, October 19, 2007 3:38 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.
-
Saturday, November 03, 2007 1:57 AM
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
