If all instances use the same logon credentials, use this procedure to specify the default credentials. The plug-in also lets you omit the name and password and use the Log on as account information defined for the NetVault Process Manager service.
1 |
3 |
4 |
• |
Logon security mode: Based on the Authentication Mode set for the SQL Server Instance, you can specify either a Windows Administrator or a SQL Server Administrator account. To specify a Windows Administrator account, select Windows. For a SQL Server Administrator account, select SQL Server. |
IMPORTANT: You can only select SQL Server if the SQL Server Authentication Mode is set to Mixed Mode/SQL Authentication. If you are using a Linux environment, you must enter the SQL Server Administrative (sa) account credentials. If you do not enter the credentials, the plug-in cannot access SQL Server and backup jobs fail. |
• |
Login Details: Depending on the option selected in the Logon security mode section, provide the appropriate account information in this section: |
• |
Administrator User Name: Specify either a Local or Domain Windows Administrator user name. |
• |
Password: Enter the password associated with the user specified in the preceding field. |
• |
Windows Domain: If a Domain Administrator is specified in the Administrator User Name field, enter the name of the domain. You can leave this field blank if a Local Administrator user name is specified. |
• |
Login Timeout (Seconds) (0=Timeout disabled): This option specifies how long to wait, in seconds, before an instance returns from an attempt to log in to a SQL Server Instance. By default, the timeout value is set to 30 seconds; however, you can change the value during a network delay for a particular SQL Server Instance. The maximum that you can use is 800 seconds. If the value is set to 0, the option is disabled. |
• |
Administrator User Name: Specify a SQL Server user with the sysadmin role. If you are using a Linux environment, enter the name for the sa account. The default name is sa. |
• |
Password: Enter the password associated with the user specified in the preceding field. If you are using a Linux environment, enter the password for the sa account. |
• |
Login Timeout (Seconds) (0=Timeout disabled): This option specifies how long to wait, in seconds, before an instance returns from an attempt to log in to a SQL Server Instance. By default, the timeout value is set to 30 seconds; however, you can change the value during a network delay for a particular SQL Server Instance. The maximum that you can use is 800 seconds. If the value is set to 0, the option is disabled. |
The Add Instance option in the context menu helps you add an instance under the All Instances node. This option is available if the All Instances node is selected. This option is similar to the Configure option; however, this option lets you specify the exact name of a SQL Server Instance.
1 |
3 |
4 |
• |
Logon security mode: Based on the Authentication Mode set for the SQL Server Instance, you can specify either a Windows Administrator or a SQL Server Administrator account. To specify a Windows Administrator account, select Windows. For a SQL Server Administrator account, select SQL Server. |
IMPORTANT: You can only select SQL Server if the SQL Server Authentication Mode is set to Mixed Mode/SQL Authentication. If you are using a Linux environment, you must enter the SQL Server Administrative (sa) account credentials. |
• |
Login Details: Depending on the option selected in the Logon security mode section, provide the appropriate account information in this section: |
• |
Administrator User Name: Specify either a Local or Domain Windows Administrator user name. |
• |
Password: Enter the password associated with the user specified in the preceding field. |
• |
Windows Domain: If a Domain Administrator is specified in the Administrator User Name field, enter the name of the domain. You can leave this field blank if a Local Administrator user name is specified. |
• |
Login Timeout (Seconds) (0=Timeout disabled): This option specifies how long to wait, in seconds, before an instance returns from an attempt to log in to a SQL Server Instance. By default, the timeout value is set to 30 seconds; however, you can change the value during a network delay for a particular SQL Server Instance. The maximum that you can use is 800 seconds. If the value is set to 0, the option is disabled. |
• |
Administrator User Name: Specify a SQL Server user with the sysadmin role. If you are using a Linux environment, enter the name for the sa account. The default name is sa. |
• |
Password: Enter the password associated with the user specified in the preceding field. If you are using a Linux environment, enter the password for the sa account. |
• |
Login Timeout (Seconds) (0=Timeout disabled): This option specifies how long to wait, in seconds, before an instance returns from an attempt to log in to a SQL Server Instance. By default, the timeout value is set to 30 seconds; however, you can change the value during a network delay for a particular SQL Server Instance. The maximum that you can use is 800 seconds. If the value is set to 0, the option is disabled. |
• |
Instance Name (Windows only): Type the name of the instance to configure. If it is a named instance, type the full instance name. |
If a specific instance uses different logon credentials, such as those described in Authentication Modes, from the credentials used by default, use this procedure to enter the different credentials. Information that you enter during this process overrides what you specified in Entering logon credentials for all instances on a client.
1 |
3 |
Double-click Plug‑in for SQL Server, and double-click the All Instances node to display the list of SQL Server Instances. |
4 |
5 |
From the context menu, select Configure. |
• |
Logon security mode: Based on the Authentication Mode set for the SQL Server Instance, you can specify either a Windows Administrator or a SQL Server Administrator account. To specify a Windows Administrator account, select Windows. For a SQL Server Administrator account, select SQL Server. |
IMPORTANT: You can only select SQL Server if the SQL Server Authentication Mode is set to Mixed Mode/SQL Authentication. If you are using a Linux environment, you must enter the SQL Server Administrative (sa) account credentials. |
• |
Login Details: Depending on the option selected in the Logon security mode section, provide the appropriate account information in this section: |
• |
Administrator User Name: Specify either a Local or Domain Windows Administrator user name. |
• |
Password: Enter the password associated with the user specified in the preceding field. |
• |
Windows Domain: If a Domain Administrator is specified in the Administrator User Name field, enter the name of the domain. You can leave this field blank if a Local Administrator user name is specified. |
• |
Administrator User Name: Specify a SQL Server user with the sysadmin role. If you are using a Linux environment, enter the name for the sa account. The default name is sa. |
• |
Password: Enter the password associated with the user specified in the preceding field. If you are using a Linux environment, enter the password for the sa account. |
• |
Instance Name: Usually, the plug-in automatically identifies and completes this field, and you cannot change it. If the plug-in is unable to determine the instance name, such as when you are configuring an AlwaysOn Availability Group, specify the exact name of the SQL Server Instance running. When NetVault Backup locates the instance, the instance is displayed on the NetVault Backup Selections page for browsing and inclusion in a backup job. |
9 |
If you need to enter different authentication information for additional SQL Server Instances, repeat Step 4 through Step 8 until all instances are configured. |
a |
c |
d |
Select the first SQL Server Virtual Server in the tree, and then select Configure from the context menu. |
f |
Repeat steps Step b through Step e for all remaining Virtual Clients, ensuring that the proper SQL Server Virtual Server is selected for each Virtual Client. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center