Under Configured connectors, select your connector, and then click Start.In the Name field, enter a new name, or keep the existing name.Select the SolarWinds Security Event Manager MSSQL Auditor connector, and then click Add Connector.Select an agent, and then click Manage node connectors.Under Refine Results, expand the Type group, and then select the Agent check box.On the SEM Console, navigate to Configure > Nodes.In the Manage Auditor Service section, click Start Auditor Service, and then click OK.Ĭonfigure the MSSQL Auditor Connector on a SEM Agent.The account only requires Execute permissions for any stored procedures with the xp_trace prefix. SolarWinds recommends using an account in the sysadmin role on your database. To use an account other than the Local System Account to run MSSQL Auditor on your database server, select This Account in the Run Service As and provide the appropriate credentials.Repeat step 1 for any additional servers you need to monitor.To specify an instance other than the default, enter your server name in the following format: Enter the name of the SQL server to monitor in the SQL Server\Instance field, and then click Add Server.If you did not select Launch SolarWinds MSSQL Auditor after installing the application, you can launch the application from the SolarWinds Security Event Manager program group in your Start menu. When the installation is finished, select Launch SolarWinds MSSQL Auditor, and then click Finish. To begin the installation, double-click the EXE file.Īccept the End User License Agreement if you agree, and then click Next.Ĭlick Change to specify an installation folder, or accept the default, and then click Next. Install MSSQL Auditor on a SEM Agentĭownload the MSSQL Auditor for Windows from the SolarWinds Customer Portal.
When completed, install the MSSQL Auditor for Windows on your server.
To enable the SolarWinds SEM Agent access to details about your database configuration changes, install the following software on your database server: When configured and enabled, the software provides your SolarWinds SEM Agent access to details about any database configuration changes to your database server. Configure your database serversĭownload MSSQL Auditor for Windows from the Customer Portal and install the software on your server. You can now configure SQL audit events and use our new SQL Audit Events connector to parse those events. MSSQL Auditor runs as a service in conjunction with the SEM Agent service. This configuration allows you to monitor your local or remote SQL Server databases.
You can track successful or failed attempts to access your database tables and schemas by installing MSSQL Auditor for Windows on a SEM Agent running SQL Server 2008 or later with Profiler. Configure SEM to monitor Microsoft SQL databases for changes to tables and schemas
0 kommentar(er)
