DBNETLIB error

Platform:
Windows 2003 ent ed, SQL Server 2000 sp3a enterprise
We tried to bcp file into our Failover Cluster SQL Server database, but with
serious error:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
SQLState = 01000, NativeError = 5
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
How can I resolove this? Do I need reboot server to perform failover or
change SQL Server Network Library setting?
Thanks.
Maggie
Hi,
do you have Named Pipes enabled?
Danijel
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:F210EFB0-2E65-48F2-8BE7-0EFCAA7847A8@.microsoft.com...
> Platform:
> Windows 2003 ent ed, SQL Server 2000 sp3a enterprise
> We tried to bcp file into our Failover Cluster SQL Server database, but
> with
> serious error:
> SQLState = 08001, NativeError = 17
> Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
> exist or access denied.
> SQLState = 01000, NativeError = 5
> Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (Connect()).
> How can I resolove this? Do I need reboot server to perform failover or
> change SQL Server Network Library setting?
> Thanks.
> Maggie
|||Yes. We have both named pipes and tcpip.
"Danijel Novak" wrote:

> Hi,
> do you have Named Pipes enabled?
> Danijel
> "Maggie" <Maggie@.discussions.microsoft.com> wrote in message
> news:F210EFB0-2E65-48F2-8BE7-0EFCAA7847A8@.microsoft.com...
>
>
|||Try to disable or even remove Named Pipes from the Server Network utility.
It helped in two cases I had in last two months. Maybe it will help you.
take a look at the Q below. It describes the problem with backup but in the
boot there is some words about windows 2003 having some problem with Named
Pipes in connection with MDAC 2.8.
http://support.microsoft.com/kb/827452
Danijel
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:BDD7D99D-77E5-4FFF-8DB2-04BD530EB96E@.microsoft.com...[vbcol=seagreen]
> Yes. We have both named pipes and tcpip.
> "Danijel Novak" wrote:
but[vbcol=seagreen]
not[vbcol=seagreen]
or[vbcol=seagreen]