Tabular Data Stream (TDS) version 0x73090003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.
Very confusing error when trying to connect to a Database Engine (SQL Server 2008) using 'usual' windows authentication getting the following error:
A connection was successfully established with the server, but then an error occurred 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)
With this error the initial thought was to check whether Server Protocol such as TCP/IP & Named Pipes are enabled or not in addition to the login privigiles. All seems to intact in place where the referred protocols are enabled & login has relevant privileges. One of the VS2008 expert referred me to ensure both server and client has similar version, that I'm using CTP version of SQL Server 2008 & Visual Studio 2008 and list is as follows:
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
Interestingly, when I was checking the logs such as SQL Server & Event viewer going towards Application event log that revealed following error each time the connect operation is performed:
Tabular Data Stream (TDS) version 0x73090003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.
Atlast the error is resolved after installing .NET framework 3.5 and as all of the above are CTP version except the .NET framework which is shipped with Visual Studio 2008 which has a compatible System.Data.SqlClien managed SQL Server provider with November CTP (CTP5) of SQL Server 2008. You can download the .NET framework from Download site
Further I would like to give you a list of versions that are supported:
|
|
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 |