VB and SQL express connection string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ricardo Furtado - 19 Mar 2008 11:53 GMT

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

Reply to this Message

sloan - 19 Mar 2008 15:24 GMT

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.

> I'm trying to create a new connection to an SQL Express Database from
> inside
[quoted text clipped - 17 lines]
>
> My thanks in advanced

Reply to this Message

VB and SQL express connection string

Free Magazines