Installing the SolutionPack for Microsoft SQL
- Make sure the core modules, such as the Module-Manager, are up-to-date on all servers since not all module dependencies are validated during theSolutionPackinstallation. The installation guide for your product provides more information.
- Ensure you create awatch4netuser prior to installing the SolutionPack. You may need this to ensure correct credentials are added to Microsoft SQL Server Devices Management during the installation process.
- Log in to your product and click .
- ClickSolutionPacksand selectSOLUTIONPACK CENTER.
- Select theSolutionPack for Microsoft SQL Serverin theBrowse and Install SolutionPackswindow.
- Read the summary information and clickInstall.
- Type the instance name.
- Assign a server for each of the components.
- ClickNext.The window displays pre-configured alerts details.
- From thePre-Configured Alertsdrop-down menu, select existing settings that have been specified for other components, or selectAdd a new alerting on data collection.
- ClickNext.The window displays the data collection details.
- Make a selection in theData Collectiondrop-down menu.Select existing settings that have been specified for other components or selectAdd a new data collection.
- If you selectAdd a new Data collection, type information about the data collection. In theHostname or IP address to send datafield, uselocalhoston default port 2020.This is the Collector host where the Load Balancer Connector is installed.
- Select theFrontend Web Serviceoption.Select existing settings that have been specified or chooseAdd a new Frontend Web Service.
- If you selectConfigure Collector advanced settings, you have the option to select different polling periods.The default polling period is 15 minutes. Consult with your database administrator to set the polling period based on the number of SQL Server instances that are being polled by this collector manager instance. For example, you have the option to select 5 minutes, 15 minutes, 30 minutes, or one hour.
- ClickNext.
- If you selectAdd a new Web-Service Gateway, type information about the web-service gateway.
- In theAdministration Web-Service instance, select an existing instance or create a custom instance.
- ClickInstall.
- ClickOK.Monitor the installation logs to ensure that the installation completes successfully.
- Click .
- ClickMicrosoft SQL Server.
- ClickAdd new device.Threshold based alerts are disabled by default. To manually enable threshold based alerts, go to .
- Select the server and collector instance where you want to store the configuration details for this device.
- Set these values:
- Enter the Hostname or IP address of the SQL server.
- Specify theDatabase PortandDatabase Instancename. For example, typeDefaultfor the SQL Server Instance name or type the named instance.
- Specify the mode of authentication used for the SQL Server:SQL AuthenticationorWindows Authentication
- If using SQL Server authentication, type the username and password for the SQL Server.
- If using Windows authentication, provide the Windows domain, username, and password. Use either the local or domain username.
- ClickValidate and Addto check connectivity with the SQL Server.
- ClickOK.
- ClickSave.