Re: An error about "[dbnmpntw]ConnectionOpen(CreateFile())".

From: arxing (cjx_at_nbdx.cn)
Date: 06/23/04

  • Next message: Jeff Cochran: "Re: SQL Injection prevention" 
    Date: Wed, 23 Jun 2004 21:28:14 +0800

    But if I don't installed SQL Client on the machine I am connecting, what can
    I do?

    thanks.

    "Hari" <hari_prasad_k@hotmail.com> дÈëÓʼþ
    news:elatIOQWEHA.1128@TK2MSFTNGP10.phx.gbl...
    > Hi,
    >
    > Use the SQL Client Configuration utility (from the machine u are
    connecting)
    > to create alias server name for the sql server using the TCP/IP protocol
    > specifying IP and port number.
    > And use this Alias name to connect to SQL server using TCP/IP
    >
    > --
    > Thanks
    > Hari
    > MCDBA
    > "arxing" <cjx@nbdx.cn> wrote in message
    > news:eAfe$8PWEHA.4092@TK2MSFTNGP11.phx.gbl...
    > > Hi:
    > > When I tried to connect SQL Server Databse which was on another
    > machine,
    > > using Microsoft OLEDB Provider for SQL Server, error 0x80040005 was
    > > returned, and the error message was
    > > "[dbnmpntw]ConnectionOpen(CreateFile())".
    > >
    > >
    >
    >

  • Next message: Jeff Cochran: "Re: SQL Injection prevention"

    Relevant Pages

    • Re: Cannot connect a remote sql server
      ... Try disabling the firewall on the client. ... I would also make sure the SQL Browser service is running and that the login credentials you're using have rights to the default database. ... I've also written a long chapter on connecting that has helped a lot of people establish and maintain connections. ... I don't know if this matter but the server I'm trying to connect to is SQL Server 2000. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
      ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
      (microsoft.public.sqlserver.connect)
    • RE: Website Administration has errors
      ... The application is configured to use SQL Server ... permission issue when the webadmin site page try connecting to the target ... since the web admin site will use the ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • SQL Express Remote Connections
      ... TCP/IP is enabled (because i can get there from the local subnet) and if i go to the properties of the connection and go to IP Addresses they are all active but only the primary host ip is enabled. ... 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. ...
      (microsoft.public.sqlserver.setup)
    • It can be Done
      ... I just installed a 3 SQL Server 2005 instances on a 2 node Active/Passive cluster. ... IWiz will then offer you a choice of Group on where you can install teh Fail Over Clustered Instance of SQL. ...
      (microsoft.public.sqlserver.clustering)