Connection to SQL problem (1 Viewer)

cherosoullis

Registered User.
Local time
Today, 16:19
Joined
Jun 23, 2006
Messages
47
I have created a database in SQL 2005 Express and I made the connection through server explorer but when I run the application (VB.NET 2005) the myconnection().Open error occurers.
"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 settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I am new in this and I don´t know how to establish the connection can you help me please?
 

SQL_Hell

SQL Server DBA
Local time
Today, 14:19
Joined
Dec 4, 2003
Messages
1,360
must be an error in your connection string or something, the error you received means that your vb.net app cannot find the sql server.

also check the firewall is not blocking you or something like that
 

Users who are viewing this thread

Top Bottom