ConnectionOpen (PreLoginHandshake()). General Network Error

Hi all,
I'm getting the following error on my SQL on a local machine when running a
client program that connects to sql server located at the same machine. What
does it means? Do i have to configure in SQL settings?
[DBNETLIB]ConnectionOpen (PreLoginHandshake()). General Network Error.
thanks,
joelNormally this message would indicate a timeout of some kind attempting to
connect. Open the SQL Client Network Utility and see if Shared Memory is
enabled. If it is not enable it and see if the problem goes away. Local
connections by default should use shared memory so it would appear that
this is not enabled.
Rand
This posting is provided "as is" with no warranties and confers no rights.

connection string to sql 2005

Dear,

I am trying to connect from a vb.net application (VS 2005) to a sql server 2005 database located remotely,
what is the connection string that I should use?
I used the same one that I was using for connecting to sql 2000 but it is not working.
Thanks.

you can refer to http://www.connectionstrings.com/|||

Hi Goodway,

Could you show us your connection string?

|||

Hi,

Here is an example.

If use windows authentication

Data Source=ServerName\InstanceName;Initial Catalog=DatabaseName;Integrated Security=True

If use SQL authentication

Data Source=ServerName\InstanceName;Initial Catalog=DatabaseName;User Id=username;Password=password

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!