Views:


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:

  1. Disable the Windows firewall on the SQL Server 2008 node.
  2. 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:

  1. Open a command prompt with administrator permissions.
  2. Enter sqlps.exe at the command prompt to start SQL Server PowerShell.
  3. 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