Server Cluster - SQL Server Connection problem -- sql server clustering

Rakesh
9/26/2004 6:43:03 AM

Hi All,

we are having following Servers:

1) Webserver
2) Application Server
3) DataBase Server

All are running on Windows 2000 Advanced Servers

Application server and Database server are in a one domain namely ABC.com
and are in cluster mode.

Even the MS SQL 2000 enterprise Edition instance installed in the DATABASE
CLUSTER MODE . Name given to the instance is ABCSQL.

But when we try to connect SQL server through Sample Application (
developed in .NET 1.03075) from Web server to Application server
error is thrown like SQL Server name doesn't find or access Denied.

I think it is not able to identify the Cluster instance or not able to
connect the port.

Please any body can help me to solve the problem.

Thanks in Advance

Geoff N. Hiten
9/26/2004 7:10:47 PM

First, troubleshoot basic connectivity. Can your application server ping
the database host server by IP address and by name. Try it again using the
virtual server IP and name. Next, connect to the SQL instance using one of
the client tools (Enterprise Manager, Query Analyzer). You may need to
upgrade the MDAC version on your application server. Older versions are not
instance aware.

--
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 : Server Cluster - SQL Server Connection problem