VB and SQL express connection string

[Ricardo Furtado]

I'm trying to create a new connection to an SQL Express Database from inside
Visual Basic .Net
If i try to choose an sql Database created with SQL Server Management Studio
or try to create a new database, the error message is the same:

"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default setting SQL Server does not allow remote connections.
(provider: SQL Network interfaces, error: 26 - Error locating Server/Instace
Specified"

This message seems very explicit but, even though i'm not able to solve the
problem

Can you Help?

My thanks in advanced

 

[sloan]

http://www.connectionstrings.com/?carrier=sqlserver
has most/all examples.


The "does not allow remote connections" is like a generic message.

"You car is making a noise. It might be the brakes".

There's a good chance it could be the brakes..but it could be a host of
other things.

...

Under start/ programs/ sql server 2005 /
somewhere there is a surface area configuration tool.

You didn't say whether the db is trying to be created on your own box, or a
remote box.

If it is a remote box, then find that surface configuration tool.

But keep the brakes/car analogy in mind.