Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connection Error

Author  Topic 

vedjha
Posting Yak Master

228 Posts

Posted - 2009-07-10 : 00:17:46
Hello sir

i am trying to connect remote sql server from my machine (Visual Studio dot net C#)
it gives an exception as:

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: TCP Provider, error: 0 - A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied.)

please help me
how to handle this
its urgent

Ved Prakash Jha

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-07-10 : 00:37:09
SQL Server is configured to allow remote login?

You're passing a valid login?

Are you using windows or sql authentication?
Go to Top of Page
   

- Advertisement -