Selecting the SQL host and instance

Use this procedure to set which SQL Server host and the instance that you want the NetBackup MS SQL Client to access. It accesses the SQL Server host when it logs into SQL Server.

To select the SQL host and instance

  1. From the Windows Start menu, select Programs > Symantec NetBackup > NetBackup Agents > NetBackup MS SQL Client.

  2. Select File > Set SQL Server connection properties.

  3. In the SQL Server connection properties dialog box, from the Host drop-down list, select the SQL Server host.

    You can type a host name if it does not appear in the drop-down list. If you select a remote host and click Apply, the Host type is shown as "remote".

  4. From the Instance drop-down list, select the SQL Server instance.

    You can type an instance name if it does not appear in the drop-down list. You can designate the default instance either by setting the Instance box to <default> or to empty (not spaces).

  5. If the SQL Server host and instance use standard or mixed security, you also need to set the user ID and password. These items are set in the user ID, Password, and Reenter password boxes.

  6. Click Apply to save your changes.

  7. Click Close.