Microsoft SQL Server Connectivity Issues

The various editions of Microsoft SQL Server install with different defaults. This can cause the SQL Server to be unavailable for backing up databases by the Infrascale MSSQL Server Agent. There are several ways to address this issue out lined below:

Using the SQL Server Surface Area Configuration Tool

  1. Run the SQL Server Surface Area Configuration Tool from the start menu.
  2. Choose the 'Surface Area Configuration for Services and Connections' near the bottom of the page
  3. For each database in the list that you are intending to have backed up, the following will need to be configured:
    1. Choose the 'Remote Connections' component for the database being configured.
    2. Choose the 'Using both TCP/IP and named pipes' option under the 'Local and remote connections' option on this page.
    3. Choose the [Apply] button on this page to save your settings.
    4. Acknowledge the warning message that the database engine must be restarted.
    5. Choose the 'Service' component for the database being configured.
    6. Choose the [Stop] button on the Service page.
    7. After the service is stopped, choose the [Start] button.
  4. Repeat the sub-steps for the step above for any other database server/engines that you want to have backed up.
  5. Choose the 'Service' Component under the 'SQL Server Browser'.
    1. Make sure the 'Startup type:' is set to 'Automatic'
    2. Choose the [Apply] button to save the configuration.
    3. If needed, press the [Start] button to start the SQL Server Browser service.
  6. Choose the [OK] button to close the 'SQL Server Surface Area Configuration' tool.

Using the 'SQL Server Configuration Manager' Tool

  1. Run the 'SQL Server Configuration Manager' tool from the Start Menu.
  2. Set the 'SQL Server Browser' service to the start mode of 'Automatic' and the state of 'Running'.
  3. For each database server to be backed up, enable the 'Shared Memory', 'Named Pipes' and the 'TCP/IP' protocol names.
  4. Optional: Double check the client expressed protocols, by selecting the 'Properties' contect menu on the 'Client Protocols' component.
    1. Ensure that the 'Shared Memory', 'Named Pipes' and 'TCP/IP' protocols are enabled.
    2. Choose the [OK] button to save your changes.
  5. Close the 'SQL Server Configuration Manager'