Katmai: SQL Server Error: 233 - by Kannan_MSFT

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 306625 Comments
Status Closed Workarounds
Type Bug Repros 3
Opened 10/24/2007 6:08:51 PM
Access Restriction Public


I have a fresh install of Vista.  Tried to install SQL Server July CTP x86. After installing everything tried to connect through SQL Server Management Studio and I get 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)

Have setup windows authentication.
Sign in to post a comment.
Posted by occamsmonkey1 on 11/3/2007 at 10:53 AM
I'm seeing the same issue but on a fresh 2008 RC0 install. The event viewer is showing:

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>]

This is a connect with the bundled SMS, not Orcas.
Posted by Microsoft on 11/2/2007 at 3:02 PM
We have not heard back from you, but with the data provided we are confident this is a known issue and has to do with versions of the runtime namely System.Data.SqlClient namespace successfully connecting to different SQL Server 2008 pre-release CTPs.

Orcas (Visual Studio) Beta 2 works with SQL Server 2008 July CTP

See this post for the entire support matrix: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1821403&SiteID=1
Posted by Microsoft on 10/30/2007 at 11:08 AM
Are you able to collect the ERRORLOG when the error happens? I want to confirm whether it is expected or not.

Posted by Microsoft on 10/26/2007 at 11:03 AM
We have seen this issue before. Mostlikely, it is because the newer version of .NET(orcas), has a protocol version higher than latest SQL Server 2008 CTP. Could you send us the SQL Server Errorlog to confirm so.
This issue will be resolved in next Katmai CTP. At meantime, Orcas can only connect to shipped SQL Server, such as SQL Server 2005.