Understand the Credentials Library
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 adding, editing, and deleting credentials in the Credentials Library. See the section Add, edit, and delete credentials within the Credentials Library.
Set up a user account on a SQL server
- Open Enterprise Manager.
- In the console tree, double-click Microsoft SQL Servers, click SQL Server Group, and then SQLComputerName (Windows NT).
- Double-click Databases, and then double-click your database of choice.
- Right-click Users, and then click the New Database User menu.
- Next to Login name, type:
- Next to User name, type your user name.
- Select the Public check box, and then select all of the following objects:
Important: Do not select
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 Server & Application Monitor 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.