Consolidated Monitoring, Analysis and Automated Remediation For Hybrid IT Infrastructures Goliath Performance Monitor Installation Guide v11.5 (v11.5) Document Date: May 2015 www.goliathtechnologies.com 1 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 Legal Notices Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Inc. All rights reserved. www.goliathtechnologies.com Goliath Technologies believes the information in this publication is accurate as of its publication date. The information is subject to change without notice. THE INFORMATION IN THIS PUBLICATION IS PROVIDED “AS IS.” GOLIATH TECHNOLOGIES MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND WITH RESPECT TO THE INFORMATION IN THIS PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Use, copying, and distribution of any Goliath Technologies software described in this publication requires an applicable software license. Linux is a registered trademark of Linus Torvalds. Windows is a registered trademark of Microsoft Corporation. VMware, ESX, ESXi, vCenter, and vSphere are either trademarks or registered trademarks of VMware Corporation. Citrix, Xen, XenServer, and XenCenter are either trademarks or registered trademarks of Citrix Systems Inc. All other trademarks and copyrights referred to are the property of their respective owners. 2 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 Support, Sales, Renewals and Licensing For information on new sales, licensing and support renewals you can email [email protected] For additional information about Goliath Technologies products and services, go to http://www.goliathtechnologies.com For customers and partners with an active support agreement, you can use the support web board or email [email protected] for information about software patches, technical documentation, and support programs. Note: A valid support agreement is necessary to receive new release and software updates. 3 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 Table of Contents I. Deployment Architecture .................................................................................................................... 5 II. Goliath Performance Monitor Installation Prerequisites .................................................................... 6 III. Goliath Performance Monitor Server Installation Steps ..................................................................... 7 IV. Configure VMware & XenServer Monitoring .................................................................................... 14 A. Configure VMware vSphere ESX/ESXi API Integration ................................................................ 15 B. Configure Citrix XenServer API Integration ................................................................................. 17 V. Configure Citrix XenApp Monitoring ................................................................................................. 19 A. Configure XenApp Server ............................................................................................................ 19 VI. Configure Citrix XenDesktop Monitoring .......................................................................................... 23 A. Configure XenDesktop DDC ........................................................................................................ 23 VII. Appendix:........................................................................................................................................... 27 A. Manual Windows Agent Install .......................................................................................................... 27 Manual Agent Installer ...................................................................................................................... 27 B. Command Line ................................................................................................................................... 31 C. GPM Linux/Unix Agent Install ............................................................................................................ 32 Install Steps........................................................................................................................................ 32 D. Installing the Goliath Performance Monitor Plug-in for XenCenter.................................................. 33 E. Installing the Goliath Performance Monitor Plug-in for vCenter ...................................................... 35 F. Connecting to a Remote SQL Server.................................................................................................. 37 Create the Database DSNs................................................................................................................. 40 4 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 I. Deployment Architecture This diagram shows how the Goliath Performance Monitor fits into the environment. 5 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 II. Goliath Performance Monitor Installation Prerequisites Note: On Windows Server 2012, .NET 3.5 SP1 needs to be installed from the Features Wizard as .NET 4.5 is not backwards compatible. To view documents, please have a PDF reader available. GPM can be accessed over the network or WAN to your local computer Table 1 - Goliath Performance Monitor System Requirements Goliath Performance Monitor Server Platform: Virtual Machine or Physical Server OS: Windows Server 2008 R2 – 2012 R2 64bit Network: Static IP Address vCPU: Minimum of 8 vCPUs Memory: Minimum of 12 GB Memory Disk: 25 GB of Disk Space Dependencies: .NET 3.5 SP1 Goliath Performance Monitor Server: TCP ports 80 & 82 both must be open inbound; and port 80 must be enabled outbound for remote access to the console. Systems with Agents Deployed: TCP port 82 must be open outbound Note: These ports can be changed from the default as needed Firewall Embedded: Microsoft SQL 2008 R2 Express Version: Microsoft SQL from 2008-2014, including SQL Express *Microsoft SQL Express 2008 R2 database is the embedded database option included with Goliath Performance Monitor Note: Environments larger than 150 monitored devices require Microsoft SQL Server. Customers Evaluating with XenApp & XenDesktop should use full Microsoft SQL. Database Platform: Virtual Machine or Physical Server OS: Windows NT SP6a and Newer; Unix/Linux, and Mac Performance Specs: 0.1% CPU, 1.5 MB size on Disk, ~24 MB RAM/~50 MB RAM on XenApp Agent VMware API Integration: Service account with admin rights VMware ESX/ESXI Version: 4.0 to 6.0 Citrix XenServer API Integration: Root account needed XenServer Version: 5.5 and newer XenApp / XenDesktop 6 Citrix Versions: XenApp 4.5 - 7.6 | XenDesktop 5.5 - 7.6 XenApp/XenDesktop 7.x: .Net 3.5 SP1 and Service Account with Citrix Admin Rights for the Goliath Performance Monitor Agent required on the broker XenApp: Powershell 2.0 needed. For XenApp 7.x .NET 3.5 needed on all Windows 2012 session hosts. XenDesktop VDI: Powershell 2.0 needs to be installed. For XenDesktop 7.x .NET 3.5 needed on all Windows 8 – 10 Virtual Desktops. Note: Full Microsoft SQL suggested for XenApp & XenDesktop deployments Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 III. Goliath Performance Monitor Server Installation Steps Before you install Goliath Performance Monitor: In order to complete the installation of Goliath Performance Monitor (GPM), please ensure you have the following items available and prepared. 1. Goliath Performance Monitor installation files 2. Your license key 3. Static IP applied to the server hosting Goliath Performance Monitor Use the correct version of the install program: There are two versions of the install program: one for 32-bit versions of Windows (gpmserver_setup32.exe) and one for 64-bit versions of Windows (gpmserver_setup64.exe) Install Goliath Performance Monitor The Setup program will install the Goliath Performance Monitor server on the system you want to be designated as the Server computer. 1. Exit all programs 2. To install GPM, run the downloaded executable, either ‘gpmserver_setup32.exe’ or ‘gpmserver_setup64.exe’ 3. The executable will start the install process and display a Welcome installer 7 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 4. Click ‘Next’ to view the End User License Agreement. Note: It is strongly recommended that you exit all open Windows programs before continuing with the installation 5. Read the agreement and if you agree with the terms, select ‘I agree to the terms of this license agreement’ and click ‘Next’. If you do not agree or do not wish to continue, select ‘I do not agree to the terms of this license agreement’ and click ‘Cancel’ to exit the installer. 6. You are then prompted to provide your information to register the product. 8 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 7. Enter your Goliath Performance Monitor license key provided by Goliath Technologies, or if you have downloaded Goliath Performance Monitor for evaluation, enter ‘EVAL’ as the license key to enable the full featured version for 30 days and select ‘Next’ to continue. 9 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 Note: If you enter a valid license key, you will be given several options to configure your database. (Please refer to Appendix E to configure an external or remote SQL database) If you are performing an evaluation of the product, it automatically connects to the embedded SQL Express 2008 R2 database. 8. Please verify the ‘STATIC IP Address’ or ‘DNS Name’ for the Goliath Performance Monitor Server and ‘Console Port’ select ‘Next’ to continue. 9. Once ‘Next’ is selected, the wizard will verify that the Console Port is available. It is, Goliath Performance Monitor will then connect to it. 10 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 10. The next step lets you select where to install the Goliath Performance Monitor program. On 32-bit versions of Windows, the default location is ‘C:\Program Files\ MonitorIT’. On 64-bit versions of Windows, the default location is ‘C:\Program Files (x86)\MonitorIT. When the location is entered, click ‘Next’ to continue. Note: It is recommended that you use the default location. 11. Now please verify that the following installation settings are correct, if so select the ‘Next’ to proceed with the installation. 11 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 12. During the first part of the installation process, a progress bar will show the progress of installing the Goliath Performance Monitor, as seen in the figure below. 13. Once Goliath Performance Monitor is successfully installed, the remaining database components will be installed and configured. At some points during these additional installations, your screen may go 12 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 blank. This is a normal part of the installation process. Finally, the install program will display a message that the installation is complete. Click ‘Finish’ to exit the install program 15. You have successfully installed Goliath Performance Monitor and can now launch the application. 13 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 IV. Configure VMware & XenServer Monitoring This section will walk you through the discovery and configuration process for adding VMware vSphere ESX/ESXi, Citrix XenServer and their subsequent virtualized guest machines and storage to your Goliath Performance Monitor inventory. For step-by-step instructions on configuring the Goliath Performance Monitor Plug-in for VMware vCenter and Citrix XenServer please see Appendix C (XenCenter) and Appendix D (VMware) Note: It is recommended to begin by configuring your virtual hosts (vSphere ESX/ESXi & XenServer, before deploying Agents. This will populate your Goliath Performance Monitor inventory with all the relative guest VMs and storage per host. 14 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 A. Configure VMware vSphere ESX/ESXi API Integration 1. From the ‘First Time Run Wizard’ , select the icon for ‘Virtual Server’ Note: If the ‘First Time Run Wizard’ does not appear, go to ‘Settings’. Under ‘Tools’ select ‘First Time Run Wizard’ 2. Check ‘VMware and then select the ‘Next’ button 3. You will be prompted for the connection information on the ‘Provide Credentials’ page: 4. Select ‘Next’ once completed 15 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 5. Select the ‘Hosts’ that you wish to add for monitoring and select ‘Next’ 6. Select the option ‘Finish’ and then ‘Next’. Then ‘Finish’ to return back to the ‘Monitor Dashboard’ screen Note: At this point you may continue to add additional hosts by selecting ‘Repeat Virtual’ to repeat the wizard steps to add additional servers. 16 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 B. Configure Citrix XenServer API Integration 1. From the ‘First Time Run Wizard’, select the icon for ‘Virtual Server’ 2. Check ‘XenServer’ and then select the ‘Next’ button 3. You will be prompted for the connection information on the ‘Provide Credentials’ page: 4. Select ‘Next’ once completed 17 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 5. Select the ‘Hosts’ that you wish to add for monitoring and select ‘Next’ 6. Select the option ‘Finish’ and then ‘Next’. Then the button ‘Finish’ to return back to the ‘Monitor Dashboard’ screen Note: At this point you may continue to add additional hosts by selecting ‘Repeat Virtual’ to repeat the wizard steps to add additional servers. 18 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 V. Configure Citrix XenApp Monitoring These steps will take you through the configuration process to begin monitoring Citrix XenApp to automatically collect XenApp Farm Inventory, User Session Data, and enable Health Check Monitoring. Note: Windows 2003 and 2008 users will need to install the PowerShell feature. A. Configure XenApp Server 1. From the ‘First Time Run Wizard’ , select the icon for ‘XenApp & XenDesktop’ 2. Check ‘Citrix XenApp and then select the ‘Next’ button 3. You will be prompted for the connection information on the ‘Configure XenApp Integration’ page: 19 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 4. The ‘Agents’ on the server will be deployed automatically, then click the ‘Next’ button 20 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 5. An ‘Add XenApp Role Servers’ page will appear If you would like to add in your Role Servers select ‘Add’ and enter in the Role Server information and select ‘Apply’. Repeat this process for all Role Servers, when finished select ‘Next’ 21 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 While the role servers deploy you will see a loading screen. When they are finished you will see the status of the deployments. If all were successful select ‘Next’. This will take you to the Finish page, see step __ for further instructions. 6. If you don’t want to add any Role Servers at this time you can select ‘Next’. NOTE: A disclaimer may popup for not adding role servers, select ok to bypass it and continue 7. The Save and Finish screen will now appear. To add more items to your inventory select ‘Configure More’ to repeat steps 1 – 7. Or select ‘Finish’ to return back to the ‘Monitor Dashboard’ screen 22 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 VI. Configure Citrix XenDesktop Monitoring These steps will take you through the configuration process to begin monitoring Citrix XenDesktop for the automatic Broker inventory and user VDI data collection. Note: Windows 2008 Enterprise users will need to install the PowerShell feature. For XenDesktop 7.x, if the DDC is running Windows server 2012 enable .Net 3.5 A. Configure XenDesktop DDC 1. From the ‘First Time Run Wizard’ , select the icon for ‘XenApp & XenDesktop’ 2. Check ‘Citrix XenDesktop and then select the ‘Next’ button 3. You will be prompted for the connection information on the ‘Configure XenDesktop Integration’ page: 23 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 4. 24 The ‘Agents’ on the server will be deployed automatically, then click the ‘Next’ button Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 5. An ‘Add XenDesktop Role Servers’ page will appear If you would like to add in your Role Servers select ‘Add’ and enter in the Role Server information and select ‘Apply’. Repeat this process for all Role Servers, when finished select ‘Next’ 25 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 While the role servers deploy you will see a loading screen. When they are finished you will see the status of the deployments. If all were successful select ‘Next’. This will take you to the Finish page, see step __ for further instructions. 6. If you don’t want to add any Role Servers at this time you can select ‘Next’. NOTE: A disclaimer may popup for not adding role servers, select ok to bypass it and continue 7. The Save and Finish screen will now appear. To add more items to your inventory select ‘Configure More’ to repeat steps 1 – 7. Or select ‘Finish’ to return back to the ‘Monitor Dashboard’ screen 26 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 VII. Appendix: The supplement will guide you step-by-step through the process of manually deploying Windows Agents, Linux/Unix Agents, configuring the plug-in for Citrix XenCenter & VMware vCenter, and how to connect to a remote database. A. Manual Windows Agent Install Note: This section will provide information on how to manually deploy agents. This process is done one of two ways: through the ‘Command Line’ or by the ‘Agent Installer’. Manual Agent Installer 1. Enter the URL: ‘http://GPMServerIPAddress/InstallAgent.exe’ (replacing ‘GPMServerIP Address’ with the IP address for the Goliath Performance Monitor Server) 2. The download wizard will appear, once the download wizard is complete, the installation wizard will appear 27 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 3. 28 Click ‘Next’ and proceed through the wizard If prompted, Click ‘Continue’ on the UAC to continue with install Enter the Goliath Performance Monitor Server IP Address, leave Goliath Performance Monitor server Port as 82 if using defaults. You can also specify a name the Agent should use for this server (This is Optional) Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 29 Confirm Install directory and Click ‘Next’ to continue with the installation Review the install information and Click ‘Next’ to Continue with Install Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 This screen will appear while it is installing Click ‘Finish’ to complete Installation There is no need to reboot the server. The GPM Agent will automatically attempt connection to the GPM Server after about a 30 second delay. Once the GPM Agent connects, it will automatically register. 30 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 B. Command Line 1. Open command prompt (use RunAsAdmin on Windows 2008), and perform the following commands: cd ‘C:\Program Files\MonitorIT’ : Then AgentService.exe –i arg1 82 ‘C:\Program Files\MonitorIT\RpmAgent.exe’ arg2 Arg1: Goliath Performance Monitor Server IP address (e.g. 192.168.1.100) so the Agent knows where to connect; 82: This is the default port on which Goliath Performance Monitor listens for Agents. Note: If you have changed the port Goliath Performance Monitor uses by default, then make sure that is reflected here. Arg2, OPTIONAL: The name that the Agent uses for this server/workstation when it connects and registers with the GPM Server. For example, AgentService.exe –i 192.168.1.100 82 C:\Program Files\MonitorIT\RpmAgent.exe 2. Start the Goliath Performance Monitor Agent Service. From the command prompt: AgentService.exe –s There is no need to reboot the server. The GPM Agent will automatically attempt connection to the GPM Server after about a 30 second delay. Once the GPM Agent connects, it will automatically register. Note: If you have multiple farms, you will need to deploy an agent to each collector 31 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 C. GPM Linux/Unix Agent Install The Linux/Unix Agent is platform agnostic across all Linux/Unix variations including Solaris, HP-UX, IBM and AIX. For Fedora Core, run the following command: yum install java For Debian Core, run the following command: sudo apt-get install openjdk-6-jre Install Steps 1. In the ‘GPM Server Install Path > GPM\Bin’ folder, find and copy the two files, 'MITAgent.jar' and ‘MonitorITAgentStart.jar’ to a folder of your choice on the Linux/Unix Server, for example ‘/opt/GPM 2. Open the command prompt from the directory where you copied the files: nohup /FullyQualifiedPathToTheInstalledJava/bin/java -cp MonitorITAgentStart.jar AgentStart -s GPMIPAddress -p 82 & For example, to connect back to GPM server at 192.168.1.100 when the java program is located at ‘/usr/bin’ the installation command would be: nohup /usr/bin/java -cp MonitorITAgentStart.jar AgentStart -s 192.168.1.100 -p 82 & 3. Put the command in your ‘rc.local’ file or equivalent so the Agent will run on start-up. 4. If your ‘rc.local’ file is located in ‘/etc’ you would perform the following commands from the console command prompt: 5. Open the ‘rc.local’ file to edit: vi /etc/rc.local 6. Find the last line in the file and append the install command used earlier by using the ‘vi’ insert command: i 7. Using the example from earlier, where the agent files are located at ‘/opt/GPM’ and the GPM server is located at 192.168.1.100, you would enter: nohup /usr/bin/java -cp /opt/GPM/MonitorITAgentStart.jar AgentStart -s 192.168.1.100 -p 82 & 32 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 8. Click the Esc key to exit insert mode, and enter the command to save and close: wq! 9. Once the Agent is installed, you will be able to subsequently update it remotely from the central GPM Server display called 'Manage Agents' available in ‘Configure > Servers/Agents & Devices’ D. Installing the Goliath Performance Monitor Plug-in for XenCenter The Goliath Performance Monitor Plug-in for XenCenter allows you to access Goliath Performance Monitor from a tab within the Citrix XenCenter client application. 1. Go to the ‘Setup’ page under the ‘Configure’ Tab. 2. Launch the ‘VMware, XenServer, or Hyper-V Environment’ wizard by clicking on the icon 3. Select ‘Citrix XenServer’ under Step 1 4. Select ‘Launch Wizard’ 5. Select ‘Next’ past the ‘Add Inventory Page’ and the ‘Licensing Page’ to the last page. 6. Select ‘Install Plug-In to XenCenter’ 7. Click ‘save’ to download the ‘xencenter_plugin.zip’ file prompt 8. You will need to extract the ‘Installer Package’ and run to launch the Setup Wizard 9. Click ‘Next’ and the End User License agreement opens 33 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 10. Review the agreement and accept the terms to continue. Then click ‘Next’ and the Goliath Performance Monitor Server page opens. 11. Before entering the URL and continuing, open Internet Explorer and load the Goliath Performance Monitor client web page. 12. Copy the URL from the address bar in IE into the edit field in the Goliath Performance Monitor Plug-in install screen. We recommend you select the URL with the ‘top.html’ in IE, copy it, and then paste the URL into the install screen. Make sure the two URLs match. 34 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 13. When the two URLs are a correct match, click ‘Next’ and the ‘Ready to Install Goliath Performance Monitor Plug-in’ page opens. 14. Click ‘Install’ to install the XenCenter Plug-in. 15. When the installation completes, click ‘Finish’ to close the wizard. Launch XenCenter and you will see a new tab labeled ‘MonitorIT’ which displays the full Goliath Performance Monitor client within XenCenter. E. Installing the Goliath Performance Monitor Plug-in for vCenter The Goliath Performance Monitor Plug-in for VMware vCenter allows you to access Goliath Performance Monitor from a tab within the VMware vCenter interface. The plug-in is located within the configuration wizard for VMware monitoring, but can be performed at any time. 1. Go to the ‘Setup’ page under the ‘Configure’ Tab. 2. Launch the ‘VMware, XenServer, or Hyper-V Environment’ wizard by clicking on the icon 3. Select ‘VMware vSphere’ under Step 1 4. Select ‘Launch Wizard’ 5. Select ‘Next’ past the ‘Add Inventory Page’ and the ‘Licensing Page’ to the last page. 6. Select ‘Install Plug-In to vCenter’ 35 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 7. Confirm the credentials Goliath Performance Monitor will use to install the plug-in to vCenter and then select ‘Install’ Note: A pop-up box will display any success or failure messages. You can only install the plug-in once to a particular vCenter and trying to install subsequent times will cause vCenter to return an error. 8. Once the install is completed, a Success dialog will be presented and you can exit the wizard. Now launch the vSphere Client and connect to vCenter to see the new tab labeled ‘MonitorIT’ which displays the full Goliath Performance Monitor Client. You can optionally go back to the Home screen and launch Goliath Performance Monitor in full screen from the Administration section. 36 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 F. Connecting to a Remote SQL Server In this section, we will review the procedure for connecting to a Remote SQL Server Instance from the Installer. See below a link to download the Goliath Performance Monitor database file; https://s3.amazonaws.com/goliathpm/Consulting/Database.zip A. Attach the database 1. Move the MonitorIT.mdf file to the SQL Server Data repository. 2. Run SQL Server Management Studio as ‘Administrator’ 3. Right click on Databases and choose ‘Attach’ 37 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 4. Choose ‘Add’ on the Attach Database window 5. Locate MonitorIT.mdf in the file tree and select ‘OK’ 38 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 6. In the Bottom Box labeled ‘”MonitorIT Database Details’, just below where the MonitorIT.mdf file has just been listed, select the log file ‘MonitorIT_log.LDF’, and click the ‘Remove’ button at the bottom right. Note: We are removing this log file because we want SQL to create a new one. 7. Select OK to complete attaching the database. 39 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 B. Connect Goliath Performance Monitor to your SQL Database In this section we will cover the steps necessary to complete the final steps in the migration process by creating the necessary DSNs and appropriately modifying the windows service. NOTE: If Goliath Performance Monitor will be located on a different server, check the security properties for this database. There should be a Windows User with DBO rights to the database. This information will be needed for this section if applicable. Create the Database DSNs This section will cover the process for creating a connection to the database you have just attached to SQL. 1. Log into your Goliath Performance Monitor Server 2. Go to ‘Control Panel\System and Security\Administrative Tools’ and double click ‘Data Sources (ODBC)(32-bit)’ 3. Once open, go to the System DSN tab Note: If you have an existing DSN for ‘BreakoutRPM’ name, select ‘configure’ and rename it to ‘BreakoutRPM.Old’ 40 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 4. Next click ‘Add’ and scroll through the list to select the driver type: a. For local SQL Server instances: choose ‘SQL Server Native Client’ b. For remote SQL Server instances: choose ‘SQL Server’ 5. Name the connection with the information listed below, when finished click ‘Next’ a. Define the Name as ‘BreakoutRPM’ b. Define Description as ‘Primary GPM Database’ c. For ‘Server’ use the dropdown menu to pick the appropriate server name Note: For the SQL Server, be sure to pick the choice with the name in the correct format of the server name/instance name of the new database from the dropdown menu. 41 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 6. Keep the default settings to use the Integrated Windows authentication to connect to the database and select ‘Next’ 7. Check the box next to ‘Change the default database to’ and select ‘MonitorIT’ from the dropdown menu. Click ‘Next’ 8. Keep the defaults for the additional options and click ‘Finish 9. Select the ‘Test Data Source’ button to validate the connection. Click ‘OK’ to close all windows a. If your SQL Server is local, go to Windows Services and restart the MonitorIT Server Service (Steps to do this are in Section III) and then once it is finished, restart MonitorIT server. b. If your SQL Server is remote go on to the next section for one last step 42 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015 C. Configure the Goliath Performance Monitor Windows Service for Remote SQL Databases When connecting to a remote SQL Server, it is necessary to modify the MonitorIT Server Windows Service with the appropriate logon rights to access the database. 1. Open Windows Services: ‘Control Panel > System and Security > Administrative Tools > Services’ 2. Find the ‘MonitorIT Server Service’ in the list, right mouse click, and choose ‘Properties’ 3. Go to the ‘Log on’ tab 4. Specify a Windows account that has DBO rights to the MonitorIT database you attached on the SQL Server (we recommend using the ‘Browse’ function to ensure the account gets validated). 5. Click ‘Apply’ and then ‘OK’ to close the window 6. Select ‘Start Service’ and then ‘Restart the Service’. 7. Once that is done, restart the Monitor IT server 8. When the server is back up and running you have completed the configuration! 43 Goliath Performance Monitor v11.5 Installation Guide Copyright © 2015 Goliath Technologies Version 11.5 – May 2015
© Copyright 2024