Requires Aliase Name Connect to Named Instance -- sql server clustering

Dave
3/11/2004 8:11:40 AM

I have two Windows 2000 Advanced server cluster servers
one for developement (DEV) and the other acceptance (ACC)
servers. These cluster servers are set up as
Active/Active. These servers are set up as a Primary
Process server (Node A) and Secondary Process server (Node
B). Several months ago something changed and we were
unable to register the Node B server without set up an
aliase in the Client Network Utlility using TCP/IP as the
Network Library on SQL Server client connect to this
server. We were able to connect to Node A without an
aliase from a SQL Server client connection. I have
several other SQL Servers that are set up as default name
instances that do not require an aliase to connect these
servers.

Please help me resolve this issue.

Thank You,

Geoff N. Hiten
3/11/2004 1:37:58 PM

Older versions of MDAC cannot see named instances. Update MDAC on your
clients to the latest release and this should solve your problem.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

sql server clustering : Requires Aliase Name Connect to Named Instance