I'm tyring to connect to the sql server on my lcoal machine and have this error.
"An error has occured establishing connection to the server. Failure may be caused by the fact that under the default settings SQL server does nto allow remote connections.(provider:Named Pipes Provider,error 40 - could not open a connection to sql server)"

Can someone help me fix this?

Thanks

can you post your code

Is it SQL express or the full version?
If so what version is it?

The code is as follows:

Dim strConn As String = "Integrated Security=True;" & _
"Initial Catalog=Cargo;" & _
"Data Source=localhost"

It's the SqlServer express edition downlaoded from the net. Do I need to make changes to the settings in the configuration Manager?

Thanks.

Try instead of localhost --> localhost\SQLEXPRESS

yes, try that

If that doesnt work you may need to mess about with the config (sql express is set up to be secure by default, so only the local machine can connetc to it. some code doesnt like this)

do like this.

connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
connection = New SqlConnection(connetionString)

jannet.

Erm, you know this thread is like 2 years old?