in

Dotnetpanel Forums

Community support forums for DotNetPanel products
Dotnetpanel Forums » DotNetPanel » General Discussion » System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default set

System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default set

Last post 05-25-2009 6:23 AM by Rubal. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 05-14-2009 7:39 AM

    System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default set

    Reply Contact

    Hi,

    I want to insert some text file data depending on business conditions to database table.

    I ran three files, one of them is successfullycompleted and two are not processed showing below error

    Exception.message

    2009-05-13 09:34:45,720 [1] ERROR My_Application- A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)

    Exception.StackTrace

    2009-05-13 09:34:45,720 [1] ERROR My_Application- at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning()

    at System.Data.SqlClient.TdsParserStateObject.WriteSni()

    at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)

    at System.Data.SqlClient.TdsParser.SendPreLoginHandshake(Byte[ instanceName, Boolean encrypt)

    at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

    at System.Data.SqlClient.SqlConnection.Open()

    at AgentDebtDataLoad.CommonDB.SqlInsertToTable(String procName, String insParams)

    at AgentDebtDataLoad.LoadTextData.PreApprovalLoadProcess(String preApprovalDirectory, String delimitter)

    Exception.Source

    2009-05-13 09:34:45,720 [1] ERROR My_Application- .Net SqlClient Data Provider

    Can u please help me about this thing??? 

     

  • 05-25-2009 6:23 AM In reply to

    • Rubal
    • Top 10 Contributor
    • Joined on 03-16-2006
    • India
    • Posts 838

    Re: System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default

    Reply Contact

    Do you have remote connection enabled with your SQL install. Refer : http://support.microsoft.com/kb/914277

     

    Rubal Jain // Email - Rubal @ Rubal [dot] Net

    Windows Server Setup, Configuration, Troubleshooting, Basic Security & Hardening
    DotNetPanel - Helm Control Panel Setup, Installation, Configuration, Troubleshooting

    Authorised DNP Reseller. Get 20% Discount on all DNP Licenses.
    Authorised SmarterTools, Declude, SimpleDNS (JHSoft), Gene6 FTP, Helicon, Kayako, Icewarp Merak, MailEnable, Deerfield Reseller.

    DotNetPanel & SmarterTools Monthly Leased Licenses available.

    DotNetPanel Professional Server setup includes installation of PHP, Perl, Python, ASP.Net Frameworks, SQL Express, MySQL, SmarterMail, Stats etc and complete integration with control panel just $199/server. Contact for further details.
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems