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

From: Richard Waymire [MSFT] (rwaymi_at_online.microsoft.com)
Date: 06/25/04


Date: Thu, 24 Jun 2004 16:32:24 -0700

This utility is available even if you didn't install the SQL Client tools -
start -> run -> Cliconfg.exe.

-- 
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"arxing" <cjx@nbdx.cn> wrote in message 
news:O3sk4WSWEHA.4048@TK2MSFTNGP12.phx.gbl...
> 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())".
>> >
>> >
>>
>>
>
> 


Relevant Pages

  • Re: Trying to Move Group - SQL Instance Wont Start
    ... You can do a maintenance install and add the new nodes. ... "maintaining a failover cluster" for recovery from failure scenario 1. ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... While attempting to install SP4, it comes up immediately after I ... to be on one of the nodes that can bring SQL Server online and apply SP3a, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)
  • 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: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)