Fail to connect SQL2005

13 Oct 2006 2:34 AM

Agnes

my Two vb.net application run very well.
Suddnely, todaymorning, When user want to run One application
There is an error (When I open the database connection)
"An error has occurred while establishing a connection t the server.When
connection to SQL server 2005,this failure may be caused by the fact that
under the default setting SQL Server does not allow remote connection
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server)

**quit odd that Other appliction run very well, and it can open the same
database**

13 Oct 2006 4:25 AM

Cor Ligthert [MVP]

Agnes,

When it did run first, than it is most probably a change in the environment,
something we cannot help you with, you have to go to your system
administrator for that.

Cor

Show quoteHide quote

"Agnes" <ag***@dynamictech.com.hk> schreef in bericht
news:%23bBncAn7GHA.4404@TK2MSFTNGP04.phx.gbl...
> my Two vb.net application run very well.
> Suddnely, todaymorning, When user want to run One application
> There is an error (When I open the database connection)
> "An error has occurred while establishing a connection t the server.When
> connection to SQL server 2005,this failure may be caused by the fact that
> under the default setting SQL Server does not allow remote connection
> (provider: Named Pipes Provider, error: 40 - Could not open a connection
> to SQL Server)
>
> **quit odd that Other appliction run very well, and it can open the same
> database**
>
>
>

13 Oct 2006 4:48 AM

Agnes

I solve the problem now.
One application , the connection string 's datasource which use the
servername (can run well)
and other application use "IP " as datasource (it can't run. )
Now,we correct it.
sorry for bother you
Show quoteHide quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> ¼¶¼g©ó¶l¥ó·s»D:ulB3p9n7GHA.4***@TK2MSFTNGP03.phx.gbl...
> Agnes,
>
> When it did run first, than it is most probably a change in the
> environment, something we cannot help you with, you have to go to your
> system administrator for that.
>
> Cor
>
> "Agnes" <ag***@dynamictech.com.hk> schreef in bericht
> news:%23bBncAn7GHA.4404@TK2MSFTNGP04.phx.gbl...
>> my Two vb.net application run very well.
>> Suddnely, todaymorning, When user want to run One application
>> There is an error (When I open the database connection)
>> "An error has occurred while establishing a connection t the server.When
>> connection to SQL server 2005,this failure may be caused by the fact that
>> under the default setting SQL Server does not allow remote connection
>> (provider: Named Pipes Provider, error: 40 - Could not open a connection
>> to SQL Server)
>>
>> **quit odd that Other appliction run very well, and it can open the same
>> database**
>>
>>
>>
>
>