WatchManager SQL Installation Guide

1 Copyright G. Smith & Associates 1989 - 2010. All rights SQLI nstallation GuideAll rights reserved. No parts of this work may be reproduced in any form or by any means - graphic, electronic, ormechanical, including photocopying, recording, taping, or information storage and retrieval systems - without thewritten permission of the that are referred to in this document may be either trademarks and/or registered trademarks of therespective owners. The publisher and the author make no claim to these every precaution has been taken in the preparation of this document, the publisher and the author assume noresponsibility for errors or omissions, or for damages resulting from the use of information contained in this documentor from the use of programs and source code that may accompany it. In no event shall the publisher and the author beliable for any loss of profit or any other commercial damage caused or alleged to have been caused directly orindirectly by this : October 2010 WatchManager SQL Installation GuideCopyright G.

2 Smith & Associates 1989 - 2010. All rights G. Smith & Associates 1989 - 2010. All rights of ContentsSection IIntroduction1 Section IIBefore you begin1 Section IIIC onfigure your 31 Fixed IP Address .. 52 Indexing Services .. 63 System Restore .. 94 User Access Control (UAC) .. 125 Password Protected Sharing .. 146 Windows Firewall Section IVWindows 2008 Server15 Section VIMPORTANT: Anti Virus Software18 Section VINew Installation19 Section VIIU pgrade Installation22 Section VIIII nstall Network 291 Manually specify SQL Server Section IXImport earlier History30 WatchManager SQL Installation Guide1 Copyright G. Smith & Associates 1989 - 2010. All rights SQL is the latest version in a line of Control Room Software that has evolvedalongside the industry for some 20 release embodies improvements that are Industry driven, but the biggest change from earlierversions is influenced by developments in IT Technology in recent years, viz.

3 The incorporation of aSQL enjoy a smooth and trouble free experience with WatchManager SQL, please read each section ofthis Guide carefully before rushing into the Installation you for your time and your you beginBefore you start installing WatchManager SQL, please read the following important information:Upgrading from a prior version (Licensing)If you are planning to upgrade from an earlier version of WatchManager , your system will have to bere-licensed to operate : Do not simply install the SQL Version on your live monitoring computerwithout coordinating the re-licensing of your system with your supplier eligibilityIf you are running an earlier version of WatchManager , the table below details your upgrade status subscribing to our RMS Support Service receive this upgrade free of charge as part of theirpaid-up RMS you are not an RMS Subscriber BUT you purchased a new WatchManager or purchased an"Upgrade to the Latest Version" after 1st January 2010, you are entitled to a free upgrade to theSQL you are not an RMS Subscriber BUT you purchased a new WatchManager or purchased an"Upgrade to the Latest Version for version " before 1st January 2010.

4 You can get an upgradeto the SQL Version by re-purchasing an "Upgrade to Latest Version" or by subscribing to theWatchManager RMS still running on the DOS Version (Version and before) will have to purchase a newlicense to use the WatchManager SQL HardwarePlease ensure that your computer hardware is adequate. Please read our "PC Recommendations" formore informationBefore you begin2 Copyright G. Smith & Associates 1989 - 2010. All rights Operating SystemsWatchManager SQL is supported on the following versions of Windows:- Windows 2000 Service Pack 2- Windows XP Service Pack 3- Windows 7 Professional (x32/x64)- Windows Server 2003- Windows Server 2008 (x32/x64)Logged in as AdministratorTo install WatchManager , you must be logged on to your computer as an Windows before InstallingPlease read and follow the instructions in the next 2008 ServerWhen installing under Windows 2008 Server, please read the section that describes manual Securitysettings further down in this Virus SoftwareIf you have Anti Virus software installed (which is a good idea), ensure that you configure this softwareso that it does not impact on WatchManager SQL Installation Guide3 Copyright G.

5 Smith & Associates 1989 - 2010. All rights your ComputerIf this is the first time that you are installing WatchManager SQL, there are a few adjustments tomade to the settings on your Computer. Please ensure that these settings are done before attemptingto install WatchManager the end of each section of the settings, there is an "Applies to:" item which lists the version ofWindows the particular setting will apply. Please check this for your Windows version and apply thesetting as IP AddressIf you plan to run WatchManager SQL in a networked setup, your Server Computer (Main PC) must beconfigured with a fixed IP Address under Network Settings in workstations access the SQL Database Server using this IP Address and if you restartyour Server for any reason, the IP Address may change and then your Workstations will no longeroperate Address recommendations: with subnet mask your Computer4 Copyright G.

6 Smith & Associates 1989 - 2010. All rights an alternative, you can set the IP Address to: with subnet mask to:All versions of Window Operating SystemWatchManager SQL Installation Guide5 Copyright G. Smith & Associates 1989 - 2010. All rights ServicesTurning off Indexing Services Turning off Indexing Services will offer a small improvement to overall system on START and then choose My Computer. Locate the Local Disk C: and RIGHT CLICK onthis. From the menu, choose the Properties Screen, at the bottom, there is a CHECKBOX with a reference to "ALLOW FILESTO BE INDEXED" The wording varies between different version of Windows. UNCHECK this optionand click OKIf you see an error message popup, simply click on IGNORE ALLA pplies to:All versions of Window Operating SystemConfigure your Computer6 Copyright G.

7 Smith & Associates 1989 - 2010. All rights RestoreWindows XP/Windows 7 is equipped with a function called System Restore or System Protection asit's called in Windows 7 What System Restore does is it keeps track of important information on your system and if for anyreason your system seems unstable, you can select the System Restore and set your PC'sconfiguration back to a known point in time where everything was theory, and in most cases this is not a bad thing. In reality, what happens is that your system runs alot slower than it could, and some programs (including WatchManager ) respond a lot solution is turn off System Restore/System off System Restore Click on START and then RIGHT CLICK on My Computer. Choose XPOn the Properties Screen, choose System Restore and then click Turn off System Restore thenclick OKWindows 7On the Properties Screen, choose System Protection and then click Configure.

8 On the next screen,click Turn off System Protection then click OKWatchManager SQL Installation Guide7 Copyright G. Smith & Associates 1989 - 2010. All rights your Computer8 Copyright G. Smith & Associates 1989 - 2010. All rights to:Windows XPWindows 7 WatchManager SQL Installation Guide9 Copyright G. Smith & Associates 1989 - 2010. All rights Access Control (UAC)User Access Control (UAC) is a security measure in certain versions of Windows which pops upmessages whenever programs are installed or changes are made to the it sounds good in theory, in reality, you spend a large portion of your time clicking on the "Allow"button when trying to do some actual off UACC lick on START then choose CONTROL PANEL. On the Control Panel screen, top right hand side,change the "View By" option and make sure that you view by Large or Small the Control Panel Screen is in ICONS View, click on USER ACCOUNTS.

9 On the User Accountsscreen, click on "Change User Account Control Settings"Configure your Computer10 Copyright G. Smith & Associates 1989 - 2010. All rights SQL Installation Guide11 Copyright G. Smith & Associates 1989 - 2010. All rights the User Account Control Settings screen, move the slider all the way to the bottom and then clickOK. You will be prompted to accept the changes. Accept the changes. You will have to restart youcomputer for the changes to take to:Windows 7 Windows 2008 ServerConfigure your Computer12 Copyright G. Smith & Associates 1989 - 2010. All rights Protected SharingWhen running WatchManager in a network setup, the workstations need to have access to the sharedWatchManager folder on your workstations need this access so that automatic software updates can be installing WatchManager on your Server, this folder is automatically shared on the network butunder certain versions of Windows, the workstations cannot access this folder event though it isshared.

10 The reason for this is because PASSWORD PROTECTED SHARING is turned turn off password protected sharing, click START, then choose CONTROL PANEL. Once in theControl Panel, access the Network and Sharing CentreUnder advanced settings, scroll down to the item PASSWORD PROTECTED SHARING and click "Turn off password protected sharing" WatchManager SQL Installation Guide13 Copyright G. Smith & Associates 1989 - 2010. All rights on SAVE CHANGESA pplies to:Windows 7 Windows 2003 ServerWindows 2008 ServerConfigure your Computer14 Copyright G. Smith & Associates 1989 - 2010. All rights FirewallWatchManager consists of a number of different program components, each designed to performspecific functions in the monitoring these programs startup for the first time and the Windows Firewall is enabled, you will see aFirewall Security warning screen:Make sure you check ALL network options and then click ALLOW ACCESSA pplies to:Windows XPWindows 7 Windows 2003 ServerWindows 2008 ServerWatchManager SQL Installation Guide15 Copyright G.