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.

2 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. 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.

3 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.

4 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.

5 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, 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.

6 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.

7 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.

8 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.

9 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. 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.

10 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. On the next screen,click Turn off System Protection then click OKWatchManager SQL Installation Guide7 Copyright G.