sql error -64,233

• jamessdb

  Mr or Mrs. 500

  Points: 524

  More actions

  July 21, 2010 at 12:34 am

  #148093

  Hi,

  one of out test server frequently we are getting this error message

  Sqlserver 2005 dev(default) edition and sql2008 dev (named)instances are installed in this,

  Earlier this is not happenig but Now a days(i.e after sql2008 installation) only it is throughing error

  in checked the TCP/IP Named Pipe, local & remote connections are Enabled for the both instances.

  error

  A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)

  A connection was successfully established with the server, but then an error

  occurred during the pre-login handshake. (provider: TCP Provider, error: 0 -

  An existing connection was forcibly closed by the remote host.) (Microsoft

  SQL Server, Error: 10054) for remote connection

  For Error -233

  Any successions to fix this issue permanently.

• lakshmi2np

  Old Hand

  Points: 373

  More actions

  July 21, 2010 at 3:08 am

  #1196019

  Hi,

  Please check the below link.

  This should work.

  http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/c84ae5d6-7be4-4238-be8a-9982f6aa4c2c/

  Thanks.