Windows 2000 - MS Access XP and Sql Server 2005.

[tf85]

Hi

I can't connect a client computer with windows 2000 to sql server 2005 :
I have 2 kinds of PC clients : with Widows XP Pro (every thing is OK), and
Windows 2000 Pro (no connection to Sql Server)
My problem is only with 2 computers turn with Windows 2000 :
The client turns with Windows 2000, MS Access XP-SP3 (with ADP project)
The Server : Windows 2003 server + Sql Server 2005.
I have this message :
"Test connection failed because of an error in initializing provider.
[DBNMPNTW]connection broken."

Can I do some thing to resolve this problem ?
Thanks for help

 

[Sylvain Lafontaine]

The [DBNMPNTW] library is the library for the named pipes protocol; so the
first thing to do would be to try with the TCP/IP protocol instead: try
adding tcp: before the name of the server. If necessary, add the port
number «,1433 » (with the comma, without the «», change 1433 if this is not
the right port to use) at the end. Installing the latest MDAC could also
help in your case:

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&displaylang=en

In your case, if changing for the tcp/ip doesn't work, we must look into a
variety of possibilities. First, what kind of stuff are you using: are you
using an Alias for the server; which protocol (tcp or np); if tcp or np, if
there is a blocking firewall for the relevant port(s) (the ports used by tcp
or np are not the same); static or dynamic ports; is tcp and/or np
configured for reception on the SQL-Server; are you trying to access the
default instance or a named instance; is the browser service or the
discovery service activated, what kind of authentification (Windows or
sql-server) are you using; etc, etc., etc.

Here a some more info to help you with your problem:

http://blogs.msdn.com/sql_protocols...e-the-target-machine-actively-refused-it.aspx

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

http://msdn2.microsoft.com/en-us/library/ms345318.aspx

http://www.datamasker.com/SSE2005_NetworkCfg.htm