named pipes and sql cluster

Good day,
There is a 2-node microsoft sql 2000 cluster in active/active mode. .
Default instance is on node A, another named instance is on node B.
Client uses BDE while connecting. When the node A fails over to the
node B, it's not possible to connect to the default instance while
using trusted logins. When sql login is used, users can connect..
I can connect via Query Analyzer, but via tcp/ip only(when named pipes
aren't used) at this very moment.
As far as I understand, BDE uses named pipes with trusted logins.
Are there any workarounds?
Thank in advance,
Andrew.
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
Windows NT 5.2 (Build 3790: Service Pack 1)
Andrew,
What is the service pack level for your SQL Server 2000 clustered instance?
As of SQL Server 2000 SP3 -- Named Pipes Support Cannot Be Removed on a Virtual Server That Is Running SQL Server 2000 SP3
Here is the link that explains this
http://support.microsoft.com/default.aspx?kbid=831127
Note: If you are already on SP3a --> On a virtual server that is running SQL 2000 SP3a, an administrator can disable Named Pipes support through SQL Server Enterprise
Manager in SQL Server 2000 SP2 or earlier.
Recommendation:
Although Named Pipes support is not required for a virtual server, Microsoft recommends that both network libraries must be present on the system because of the
following reasons:
Having both network libraries available permits an administrator or an alternative interprocess communication (IPC) mechanism to repair the system.
Clients can continue to work with the virtual server, even if only one server-side network library is available.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hi Uttam,
sp3a was installed..
named pipes aren't disabled. I can see them enabled while viewing the
sql servers logs.
Moreover, i can't connect to the moved instance via named pipes using
Query Analyzer as well. Not only our application can't connect.
Andrew.
Uttam Parui[MS] =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):

> Andrew,
> What is the service pack level for your SQL Server 2000 clustered instanc=
e?
> As of SQL Server 2000 SP3 -- Named Pipes Support Cannot Be Removed on a V=
irtual Server That Is Running SQL Server 2000 SP3
> Here is the link that explains this
> http://support.microsoft.com/default.aspx?kbid=3D831127
> Note: If you are already on SP3a --> On a virtual server that is runnin=
g SQL 2000 SP3a, an administrator can disable Named Pipes support through S=
QL Server Enterprise
> Manager in SQL Server 2000 SP2 or earlier.
> Recommendation:
> Although Named Pipes support is not required for a virtual server, Micros=
oft recommends that both network libraries must be present on the system be=
cause of the
> following reasons:
> Having both network libraries available permits an administrator or an al=
ternative interprocess communication (IPC) mechanism to repair the system.
> Clients can continue to work with the virtual server, even if only one se=
rver-side network library is available.
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no right=
s=2E
> Are you secure? For information about the Strategic Technology Protectio=
n Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their =
Microsoft software to better protect against viruses and security vulnerabi=
lities. The easiest way
> to do this is to visit the following websites: http://www.microsoft.com/p=
rotect
> http://www.microsoft.com/security/guidance/default.mspx

Named Instance

hi,
i wanted to have my 2 node server cluster as active-active. DO i need to put
the named pipes in both servers before i install sql2000 or just on the one
that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2.
do i need to put both of them in CNU and install sql on first node and
proceed to another? pls advice.. just a bit blur on that part.Also when do i
need to remove this named pipes? JUST after installation and sqlspa3
completed?
TIA
Hi
During the SQL Server Install on a cluster, the setup creates the instances
and copies the binaries to all nodes. It is not a good idea to have any SQL
server installed intances prior to configuring clustering.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rupart" wrote:

> hi,
> i wanted to have my 2 node server cluster as active-active. DO i need to put
> the named pipes in both servers before i install sql2000 or just on the one
> that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2.
> do i need to put both of them in CNU and install sql on first node and
> proceed to another? pls advice.. just a bit blur on that part.Also when do i
> need to remove this named pipes? JUST after installation and sqlspa3
> completed?
> TIA