SQL 2005 Cluster

Question

Is there any special setup for a clustered environment? I'm getting the following error in the backup log after a failure: avsql Error <7403>: sqlconnectimpl_smo::connect Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server . ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I've confirmed that the server does allow remote connections and times out after 10 minutes. Other than it being a cluster, I can't come up with anything different about this.

Amol · Accepted Answer

If you are only willing to backup SQL Part on the Cluster then follow the below steps

1> Login to Active Node
2>Install Avamar Cluster Client Agent
3>Select the SQL Cluster Group
4>Select the SQL Plugin at the time of installation
5> After installation Completes, Open Cluster Administrator, SQL Cluster Group->Bring Avamar Cluster Agent Online

As soon as the cluster agent is turned on (Virtual Client i.e Network Name) gets registered in MCS GUI

Please browse the client from MCS GUI and perform backup. Please attach the complete logs if you have any problem

Regards
Amol Powar

Amol · Answer

How is the setup done on cluster?1> Is Avamar Client and Avamar Cluster Client installed on both active and passive node?2> Is the client activated from Cluster Administration ?3> Can we browse the SQL Database from MCS GUI ?Please provide the steps taken to configure SQL on cluster

Limbaugh · Answer

Thanks. Turns out the Cluster Agent hadn't been installed. Once installed everything seems to be running along.

Avamar

Was this post helpful?