Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Server & Application Monitor (SAM) > SAM Documentation > SAM 6.7 Administrator Guide > Certificate Credentials Library for SAM > Understand the Credentials Library for SAM

Understand the Credentials Library for SAM

Updated April 3, 2018

You typically need to associate credentials with component monitors to enable them to retrieve application data. For example, to use a WMI monitor, you must provide valid domain or computer credentials. Or, if your web server requires credentials, you must provide the appropriate credentials to access the protected sections of your site.

You can work with credentials by:

Set up a user account on a SQL server

  1. Open Enterprise Manager.
  2. In the console tree, double-click Microsoft SQL Servers, click SQL Server Group, and then SQLComputerName (Windows NT).
  3. Double-click Databases, and then double-click your database of choice.
  4. Right-click Users, and then click the New Database User menu.
  5. Next to Login name, type:
    domain\username
  6. Next to User name, type your user name.
  7. Select the Public check box, and then select all of the following objects:
  • db_owner
  • db_accessadmin
  • db_securityadmin
  • db_ddladmin
  • db_datareader
  • db_datawriter
  • db_backupoperator

Important: Do not select db_denydatareader or db_denydatawriter. These objects allow members to deny Read or Write permissions to data in the database.

For more information, see http://technet.microsoft.com/en-us/library/cc787483%28v=ws.10%29.aspx

  • SolarWinds SAM uses the same SNMP credentials that you entered during node discovery. There is no need to specify additional credentials for SNMP operations.
  • SolarWinds SAM stores credentials encrypted in the database.
  • The ability to Inherit Windows credentials from node is available in the drop down list.
 
Last modified

Tags

Classifications

Public