Configuration SQL Server privileges
In the example, the public name is SQLHOST.
SQL Server privileges
When you install SQL Server, you can elect to use either integrated or standard security. Integrated security refers to the usage of Windows authentication in lieu of standard SQL Server-based logins.
Note: Microsoft recommends that you use integrated security because Windows logins, unlike SQL Server-based logins, can be traced using standard Windows security tools. NetBackup for SQL Server supports both integrated and standard security for any level of SQL Server.
If you choose integrated security, then SQL Server ignores the userid and password that you provide in the SQL Server connection properties dialog box of the NetBackup Database Extension GUI. Instead, security validation to perform backup and restore operations and for querying the master database will be based upon the SQL Server privileges that have been granted to the Windows account. The batch file userid and password keywords are also ignored. When integrated security is used SQL Server operations generated by NetBackup for SQL Server will always be validated against the Windows userid.