X hits on this document

436 views

0 shares

0 downloads

0 comments

42 / 200

42

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.

Document info
Document views436
Page views436
Page last viewedSun Dec 04 22:05:22 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments