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

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 14:53:11 +0530

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: Need helps with SQL Server Express
    ... In this case, you will have to make sure that TCP/IP is enabled (SQL Server Configuration Manager, SQL Server Network Configuration, Protocols --> TCP/IP). ... When SQL Server is installed and the TCP/IP protocol is enabled, the specific SQL Server instance will be visible on the network. ... I would recommend having different Windows Groups and assign specific access rights (i.e. server roles, database roles, etc) on these groups. ... I strongly disagree that whoever has Microsoft SQL Server Management Studio Express can go into the database and make changes to everything:) ...
    (microsoft.public.sqlserver.setup)
  • RE: sql server on another computer
    ... Your .NET 2.0 application failed to connect to your remote SQL Server ... For TCP/IP protocol, please check the current using TCP port and see if you ... If you decide to use Named Pipes protocol, ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server does not exist or access denied
    ... User SQL Server ... Configuration Manager to ensure that the TCP/IP protocol is enabled. ... can also verify the port setting while you are there. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Connecting to a sql server database
    ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)
  • Re: Invalid OLEVERB structure error 80040000 on DTS job
    ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >- I copied this DTS package from a 32 bit Windows Server 2003 system. ... >I would only get that error message in the Job History logs though. ...
    (microsoft.public.sqlserver.dts)