Fail to connect SQL2005

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Agnes

    #1

    Fail to connect SQL2005

    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**



  • Cor Ligthert [MVP]

    #2
    Re: Fail to connect SQL2005

    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" <agnes@dynamict ech.com.hkschre ef in bericht
    news:%23bBncAn7 GHA.4404@TK2MSF TNGP04.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**
    >
    >
    >

    Comment

    • Agnes

      #3
      Re: Fail to connect SQL2005

      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
      "Cor Ligthert [MVP]" <notmyfirstname @planet.nl¼¶¼g© ó¶l¥ó·s»D:ulB3p 9n7GHA.4304@TK2 MSFTNGP03.phx.g bl...
      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" <agnes@dynamict ech.com.hkschre ef in bericht
      news:%23bBncAn7 GHA.4404@TK2MSF TNGP04.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**
      >>
      >>
      >>
      >
      >

      Comment

      Working...