provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
- From: jobs <jobs@xxxxxxxxxx>
- Date: Sat, 14 Jul 2007 13:11:46 -0700
Hello.
I have a sql server install / database on the web server. Work great,
all my asp.net 2.0 code on that server can access the database with no
problem.
I can access the database on the web server from my development
machine through sql authentication from the sql server client with no
problem.
However, if I attempt to access the database over the network from my
dev box through ado.net (asp.net/vb.net) using that same user I get
the following errror.
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)
The wierd thing is from Visual Studio. net 2005 on my dev box, i am
able to create a connection to that web servers database and query the
data using the same user.
Here's my connection string in the web.config:
web.config:
<add name="PKBConnectionString" connectionString=
"Data Source=192.168.xx.xx Catalog=xxx;Persist Security Info=True;
User ID=xxx;Password=xxxx" providerName="System.Data.SqlClient"/>
class:
Sub New()
p_cnn = New
SqlConnection(ConfigurationManager.ConnectionStrings("xxxConnectionString").ConnectionString)
p_cnn.Open() ' where the code is failing.
End Sub
Thanks for any help or information.
.
- Follow-Ups:
- Prev by Date: First connection from Vista client to SQL Server 2005 times out
- Next by Date: Re: provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
- Previous by thread: First connection from Vista client to SQL Server 2005 times out
- Next by thread: Re: provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
- Index(es):
Relevant Pages
|
Loading
