Symptoms
After installing the Catalogic Software agent on the SQL Server 2008 node, the SQL Server 2008 node displays in the File-level management console backup window. When the node is expanded, the SQL Server 2008 instances cannot be browsed and the following error displays in DPX:
cm_recv_rec failed, localPort (55265) , Peer (10.x.x.x:64145), rc (10038), description (The operation cannot be completed because the socket is nonexistent.) , Peerstring (ssbrowse 2.2/3,4 win-x64 )
Additionally, FileBrowser Log (*.fbl) on the SQL Server 2008 node displays the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server
Resolution
Perform the following steps to browse the SQL Server 2008 node:
- Disable the Windows firewall on the SQL Server 2008 node.
- Enable named pipes on all SQL Server 2008 instances.
To enable named pipes in SQL Server 2008:
See the following MSDN article on enabling named pipes in SQL Server 2008:
msdn.microsoft.com/en-us/library/dd206997(v=sql.105).aspx
To enable a server network protocol by using SQL Server PowerShell:
- Open a command prompt with administrator permissions.
- Enter sqlps.exe at the command prompt to start SQL Server PowerShell.
- Execute the following statements to enable both the TCP and named pipes protocols. Replace <computer_name> with the name of the computer running SQL Server. If you are configuring a named instance, replace MSSQLSERVER with the instance name.
Copy
$smo = 'Microsoft.SqlServer.Management.Smo.'
$wmi = new-object ($smo + 'Wmi.ManagedComputer').# List the object properties, including the instance names.
$Wmi# Enable the TCP protocol on the default instance.
$uri = "ManagedComputer[@Name='<computer_name>']/ ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Tcp']"
$Tcp = $wmi.GetSmoObject($uri)
$Tcp.IsEnabled = $true
$Tcp.Alter()
$Tcp# Enable the named pipes protocol for the default instance.
$uri = "ManagedComputer[@Name='<computer_name>']/ ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Np']"
$Np = $wmi.GetSmoObject($uri)
$Np.IsEnabled = $true
$Np.Alter()
$Np# Enable the named pipes protocol for the default instance.
$uri = "ManagedComputer[@Name='<computer_name>']/ ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Np']"
$Np = $wmi.GetSmoObject($uri)
$Np.IsEnabled = $true
$Np.Alter()
$Np