Installation Chapter from the NDSR 2015 User Manual
Contents
1. Feature Description Administration tools such as Synchronization Mobil ink 64 bit eee Bene MobiLink Client 32 bit SOL E3 SOL Remote 64 bit X SOL Remote 32 bit i Administration Tools 64 bit This feature requires 182MB on Administration Tools 32 bit your hard drive Calm a E innne ee ee Lew tS SQL Anywhere Monitor 64 bit gt Install to C Program Files SQL Anywhere 16 InstallShield tp Space Complete the installation by restarting Windows on the server Optionally install patches to SQL Anywhere This step is not required The version that is tested by NCC is 16 0 0 1324 the version downloaded from the Sybase Product Download Center You may need to apply the latest patches for security or performance reasons a Navigate to the download website at https sybase subscribenet com control sybs login and login with a registered email address and password b Follow the link to SQL Anywhere c If necessary to find an older patch display all platforms for all months Chapter 2 Installation Page 2 17 d Scroll down to the section of the desired server operating system Windows downloads are under Platform Windows x86 Windows x64 e Scroll down to the desired SQL Anywhere Express Bug Fix or SQL Anywhere Maintenance Release f Follow the link to the license agreement g Accept the license agreements and con2. i ODBC Configuration for SQL Anywhere 9 Select the ODBC tab and select the TEST CONNECTION button Verify that the connection is successful NDSR_2015A_Net NDSR 2015 database A on Network database service m m m m Select the OK button to finish Page 2 26 NDSR Manual Installing Additional Setups An NDSR Typical ora Client installation provides one NDSR setup that is one instance of NDSR connected to one NDSR database But sometimes that s not enough additional setups may be desired to partition data to register two different NDSR registration types e g Research and Academic on the same computer or for other reasons The easiest way to install additional NDSR setups is to run an NDSR Custom installation or a modification as described below and add one or two setups with local or network databases An alternative method is summarized at the end of this section To add setups to a Typ1Cal installation follow the instructions below that pertain to typical setups ignoring those that pertain to other types of setups To add setups to a C117 ent installation first follow the instructions in Installing NDSR Networked License and Database to add databases to the network database service Then follow the instructions below that pertain to client setups ignoring those that pertain to other types of setups 1 Install and register NDSR Typical or Client and then modif
3. 5 On the teceiving computer complete the Transfer In process described in part C on the Transfer In window Transfer Folder As Browse Help i i Cancel From the sending computer remove the USB flash drive 1f that is the location of your license transfer folder Into the receiving computer insert the USB flash drive or otherwise open your license transfer folder On the receiving computer go to the Transfer In window If you did not leave this window open in the earlier step you may open it again by starting the NDSR program When the Unregistered NDSR window opens select the TRANSFER button When the Transfer In window opens specify your license transfer folder in the Transfer Folder field Select the TRANSFER IN button This transfers the NDSR registration from your license transfer folder to the receiving computer NDSR is now registered on the receiving computer and the transfer is complete You may delete your license transfer folder or save it for transferring another license Chapter 2 Installation Page 2 11 Unregistering NDSR You may unregister NDSR in order to change from one license configuration to another e g to consolidate a number of non networked licenses into a single networked license see Installing NDSR Networked License For each license that is unregistered a confirmation code must be sent to NCC so that NCC can provide a replacement license NOTE Do not u
4. Database ndsrdb db n ndsrdb2015a C ProgramData NCC NDSR 20 15b Database ndsrdb db n ndsrdb2015b C ProgramData NCC NDSR 20 14 Database ndsrdb db n ndsrdb2014 C ProgramData NCC NDSR 2013 Database ndsrdb db n ndsrdb2013 C ProgramData NCC NDSR 2012 Database ndsrdb db n ndsrdb2012 12 On the next Create Service Wizard window accept the default or select the account under which the service will run On the next Create Service Wizard window accept the default Automatic startup type or select the service s startup type On the final Create Service Wizard window specify whether to start the service now and then select the FINISH button to complete the Wizard If you will run only NDSR 2008 or later databases on this service you may start the service now and skip the next step If you will run NDSR 2007 or earlier databases on this service do not attempt to start the service now Uncheck the option to start the service now and select the FINISH BUTTON to complete the Wizard The databases must first be updated for SQL Anywhere version 10 12 SA10 SA12 before they will run on this SA12 service see the next step Chapter 2 Installation Page 2 21 13 Update NDSR 2007 or earlier databases for SQL Anywhere version 10 12 SA10 SA12 and later You may skip this step if you will run only NDSR 2008 or later databases on this service Update each database and each client NDSR installatio
5. e myServerName myShare myL1censeFolder e myMappedDriveLetter myL1censeFolder e On one client machine start NDSR and register the license as described in Registering NDSR This will register NDSR on all of the client computers NOTE Unregistering NDSR on any client computer will unregister NDSR on all of the client computers Installing NDSR Networked License and Database Installing NDSR with a networked database and license is done in three parts e Part 1 NDSR Server installation e Part 2 Sap Sybase SQL Anywhere installation e Part 3 NDSR Client installations Part 1 NDSR Server Installation To network the NDSR license run the Server installation of NDSR or the Custom installation of the License Service as described in Installing NDSR Networked License To network the NDSR database run the Server installation of NDSR or otherwise copy an installed NDSR database file to the database server Do not grant any user access to the database folder Part 2 SQL Anywhere Installation The following steps describe how to install Sap Sybase SQL Anywhere and configure it to run a network database service 1 NDSR databases are networked by the Sap Sybase SQL Anywhere software which is provided and licensed by Sybase Inc not by NCC A license for one network seat is required for each concurrent NDSR user Obtain the necessary number of licenses and download Sap Sybase SQL Anywhere 160 from the Sybase Product Downl
6. size 7484864K 06 09 15 16 59 Using a maximum page size of 4096 bytes 06 09 15 16 59 Multiprogramming level minimum 4 current 20 maximum 80 06 09 15 16 59 Automatic tuning of multiprogramming level is enabled 06 09 15 16 59 TCP using Winsock version 2 2 06 09 15 16 59 IPv6 support enabled I 06 09 15 16 59 Starting database ndsrdb2012 C ProgramData NCC NDSR 2012 Database ndsrdb db at Tue Jun 09 2015 15 16 I 06 09 15 16 59 Starting database ndsrdb2013 C ProgramData NCC NDSR 2013 Database ndsrdb db at Tue Jun 09 2015 15 16 I 06 09 15 16 59 Starting database ndsrdb2014 C ProgramData NCC NDSR Bed bed bed et bed et bet bet bet et et ett ed et bt et bet bh bd et ed bt et et bt ed Pt td et tt et et tt et tt ot tf et St St et TT n w i its m wi mn wi Page 2 24 NDSR Manual Part 3 NDSR Client Installations The following steps describe how to install NDSR on each client computer and connect it to the networked license and database 1 Run the NDSR Client installation see Installing NDSR non networked 2 Edit the license path in the NDSR configuration file ndSr 1n1 see the client portion of Installing NDSR Networked License 3 Complete the following steps to connect NDSR to the network database service 4 Open the Administrative Tools window and select Data Sources ODBC from the list 5 On the ODBC Data Source Administrator window select the System DSN tab 6 Either create
7. the program setup process Please wait Preparing to Install 4 When the Welcome window opens select the NEXT gt button NDSR 2015 Welcome to the InstallShield Wizard for NDSR 2015 The InstallShield Wizard will install NDSR 2015 on your computer To continue dick Next Chapter 2 Installation Page 2 5 5 When the License Agreement window opens select the radio button I ACCEPT THE TERMS OF THE LICENSE AGREEMENT and select the NEXT gt button NDSR 2015 License Agreement Please read the following license agreement carefully IMPORTANT READ CAREFULLY PRIOR TO INSTALLATION OF THE NDSR SOFTWARE By installing this software Licensee agrees to all terms and conditions of all Licensing and Support Agreements Agreements between Licensee and the Regents of the University of Minnesota through its Epidemiology and Community Health Division University LICENSEE AGREES TO BE BOUND BY THE TERMS OF THE AGREEMENTS BY INSTALLING COPYING OR OTHERWISE USING THE SOFTWARE IF LICENSEE DOES NOT AGREE 1I accept the terms of the license agreement Print Ido not accept the terms of the license agreement InstallShield 6 When the Choose Destination Location window opens accept or change the destination folder and select the NEXT gt button The default destination folder is C Program Files NCC or C Program Files x86 NCC for 64 bit systems NDSR 2015 Choo
8. two computers 2 On the receiving computer install and start NDSR see Installing NDSR non networked and Starting NDSR 3 When the Unregistered NDSR window opens select the TRANSFER button 4 When the Transfer In window opens specify the license transfer folder you created in Step 1 inthe Transfer Folder field Select the REGISTER TRANSFER button This creates a request for registration in your license transfer folder You may leave this window open until you return to it in a later step I ij x The following instructions describe half of the process of transferring NDSA registration from a sending computer or location to this receiving computer or location The other half of the process is described on the Transfer Out window of the sending computer The entire process is described in the NDSA user manual Please familiarize yourself with it before beginning Part Register Transfer 1 On this receiving computer create or open your license transfer folder on a removeable drive e g USB flash drive or network drive e g D ndsrLicenseTransfer Note a writeable CD or DYD drive will not work for this transfer 2 On this receiving computer s Transfer In window select the Browse button to locate your license transfer folder 3 Select the Register Transfer button This creates a request for registration in your license transfer folder 4 You may leave this
9. 09 15 16 58 12 C ProgramData NCC NDSR 2015b Database ndsrdb db 58 n 06 09 15 16 58 14 ndsrdb2015b 06 09 15 16 58 15 C ProgramData NCC NDSR 2014 Database ndsrdb db 58 n 06 09 15 16 58 17 ndsrdb2014 06 09 15 16 58 18 C ProgramData NCC NDSR 2013 Database ndsrdb db 258 n 06 09 15 16 58 20 ndsrdb2013 06 09 15 16 58 21 C ProgramData NCC NDSR 2012 Database ndsrdb db 58 n 06 09 15 16 58 23 ndsrdb2012 EENT UREDNE 06 09 15 16 58 SQL Anywhere Network Server Version 16 0 0 1324 06 09 15 16 58 Evaluation edition licensed only for evaluation purposes 06 09 15 16 58 06 09 15 16 58 copyr tahr 2013 SAP AG or an SAP affiliate company 06 09 15 16 58 All rights reserved 06 09 15 16 58 use of this software is governed by the Sybase License Agreement 06 09 15 16 58 Refer to http www sybase com softwarelicenses 06 09 15 16 58 06 09 15 16 58 Connection limit licensed seats 3 06 09 15 16 58 Processors detected 1 containing 4 logical processors 06 09 15 16 58 Maximum number of processors the server will use 1 physical rocessor s 4 core s 06 09 15 16 58 This server is licensed to 06 09 15 16 58 Evaluation Edition 06 09 15 16 58 Restricted Use 06 09 15 16 58 Running windows 7 Build 7601 Service Pack 1 on X86_64 06 09 15 16 58 Server built for X86_64 processor architecture 06 09 15 16 59 801404K of memory used for caching 06 09 15 16 59 Minimum cache size 5944K maximum cache
10. Chapter 2 Installation This chapter describes System requirements Installation requirements How to install NDSR non networked How to register NDSR How to start NDSR How to transfer NDSR registration How to unregister NDSR How to uninstall NDSR How to install NDSR networked How to install additional setups System Requirements NDSR 2015 is supported on Microsoft Windows 7 and Windows 8 NDSR adds the following to the system requirements that are published by Microsoft for these Windows operating systems e Disk space for Program Files 70 MB e Disk space for database Up to GB for the database e Disk space for user data per typical project o Backup 0 5MB o Output 2MB o Report 0 3MB e Physical Memory to process a typical project o Idle 7OMB o Restore 50MB o Output 300MB e CPU o Quick generation of output files 2 66 GHz o Multitasking during output multi core processor e Software to examine output files o Extract zip unzip e g Windows compressed folders o Browse spreadsheet o Analyze statistical analysis Installation Requirements Permissions Depending on your organization s security policy NDSR 2015 is normally installed and uninstalled only by a member of the Administrators group Every NDSR user must be a member of the Users group or another group that has the following permissions for NDSR User Data e Modify e Read amp Execute e List Folder Contents Chapter 2 Install
11. EXT gt button to continue This wizard helps you create a new SQL Anywhere service 9 On the next Create Service Wizard window select Network Database Server and select the NEXT gt button to continue Create Service Wizard Select a Type Choose the type of service that you wish to create from the list Personal Database Server SOL Remote Message Agent Agent for Replication Server Sample Application obiLink Server SQL Anywhere MobiLink Client ink Listener Utility Broadcast Repeater Utility SQL Anywhere Volume Shadow Copy Service m Chapter 2 Installation Page 2 19 10 On the next Create Service Wizard window confirm that the executable file is C Program Files SQL Anywhere 16 bin32 dbsrv12 exe on a 32 bit system or C Program Files SQL Anywhere 16 bin64 dbsrvl12 exe ona 64 bit system and select the NEXT gt button to continue Create Service Wizard a Specify an Executable Specify the full path and file name of the executable for this service The default selection is usually suitable but you may specify another executable What executable do you want to use for this service C Program Files SQL Anywhere 16 Bin64 dbsrv 16 exe Browse Get System Default Save this executable as the custom default 11 On the next Create Service Wizard window enter parameters like the following to name the service and each database it will run For example to ne
12. Transfer In window open or open it again in Part C below 5 If pour license transfer folder is on a removable drive remove it from this receiving computer and insert it in the sending computer Pence ween nnn renee eee n weer ence nen eenn ee nn essen eeeee eee nn nese e ene ne enna nessa ne neee seen ee eee enna essen en eee seen nn eeee sane eeeen nee eesenene seen nenee senna naneasnnaasseeneeenssennneeeenaannee Part B Transfer Out 6 On the sending computer start NDSA select File gt Transfer Out on the menu and complete the Transfer Out procedure described on the Transfer Out window Part C Transfer In 7 On this receiving computer s Transfer In window select the Browse button to locate your license transfer folder 8 Select the Transfer In button This transfers the NDSA registration from your license transfer folder to this receiving computer NDSA is now registered on this receiving computer 9 You may delete your license transfer folder or reuse it for other NDSA license transfers If pou reuse it you may skip the Register Transfer process described in Part A above Transfer Folder BN Help Register Transfer Transfer In Page 2 10 NDSR Manual 5 7 8 9 NOTE From the receiving computer remove the USB flash drive if that is the location of your license transfer folder Into the sending computer insert the USB flash drive o
13. anew DSN or find the existing DSN named NDSR_2015 in the list highlight it and select the CONFIGURE gt button 7 When the ODBC Configuration for SQL Anywhere window opens verify or update the Data source name and Description fields ODBC Configuration for SQL Anywhere 2 x ODBC Login Network Advanced Data source name NDSR_201 5A_Net Description NDSR 2015 database A on Network database service isolation level a y y y l Microsoft applications Keys in SQLStatistics Delphi applications Suppress fetch wamings Prevent driver not capable errors Delay AutoCommit until statement close Describe Cursor Behavior Never if required Always 8 Select the Login tab On the Action field select Connect to a running database on another computer Complete the Server name and Database name fields to match the server name and database name you set in Part 2 for the network database service e g ndsrdbserv and ndsrdb2015 In some cases the client computer can t find the network database service e g ndsrdbserv unless the server computer is named in the Host field In some cases an alternative to naming the HOSt machine here in the ODBC Configuration is to update the client machine s network connection e g by specifying or correcting the primary and Chapter 2 Installation Page 2 25 secondary WINS servers so that it can find the network database service by name ndsrdbserv
14. are required on all computers to ensure optimal functionality To check the settings navigate to the Control Panel Clock Language and Region Under Region and Language click Change the date time or number format Then select English United States from the Format drop down menu Click Apply then OK Region and Language j x Formats Location Keyboards and Languages Administrative Format English United States Date and time formats Short date MM da yyyy S Long date dddd MMMM dd yyy H Short time himm o Long time h mm sstt o O E What does the notation mean Examples Short date 03 11 2015 Long date Wednesday March 11 2015 Short time 11 41 AM Long time 11 41 11 AM Additional settings Go online to learn about changing lanquages and regional formats Chapter 2 Installation Page 2 3 Installing NDSR non networked Stand alone The NDSR installation has been programmed so that on Windows 7 and Windows 8 you need to follow these prompts and then complete several steps manually see Windows 7and Windows 8 Public Documents Folder NCC User Support ndsrhelp umn edu will send an email containing a link to download the NDSR 2015 installation Selecting the link will direct you to Google Drive No login is required to access this download Hover the mouse at the top of the page and an options toolbar will drop down Select the DOWNLOAD ICON Google Dr
15. are often interchanged so let s define them briefly a server is anything that provides a service hardware software or human directly or indirectly and a service 1s something that 1s requested by a client and delivered to the client by the server For example a server machine for NDSR runs server software including the Crypkey license server and or the Sap Sybase SQL Anywhere personal or network database server Another server machine will commonly be a file server Each of these software servers operates with a number of components and processes including 1 a server that provides a service and 2 a service that 1s requested and received by a client The focus of a system oriented person might be the server and the only thing a user oriented person might think about is the service but both are correct This NDSR User Manual needs to describe documentation from both viewpoints and so will use the term server where the vendor uses it and the term service where the NDSR installer works with it on the list of Windows services Installing NDSR Networked License A networked license 1s installed on a server s shared network folder and referred to by each client computer through that client s NDSR configuration file To change the NDSR registration status from a non networked license to a networked license see Unregistering NDSR The following steps describe how to network the NDSR license using the file based servic
16. ation Page 2 1 e Read e Write An NDSR user must not be a member of any group including Everybody that lacks any of these permissions Default locations of NDSR User Data e Windows 7 and Windows 8 NDSR Public Documents folder The files of a network database service are not NDSR User Data and should not be accessible to Users only to Administrators and the SYSTEM Previous NDSR Registrations Because NDSR is a password protected program every copy and version must be registered although one registration process can cover several versions see Registering NDSR Because a license registration is shared by several versions of NDSR it is usually simplest to keep all of your license registrations in the same place For a networked license this means an additional network share or subfolder on the server For a non networked license it means installing NDSR 2015 on the same computer where you have installed previous versions of NDSR Windows 7 and Windows 8 Public Documents Folder For simplicity this NDSR User Manual refers to Windows 7 and Windows 8 NDSR User Data include backup files output files output file headers configuration files header export files and reports NDSR User Data in Windows 7 and Windows 8 are no longer kept in the Program Files folder but have been moved to the Public Documents folder by default C Users Public Public Documents NCC Of course their location can be customized e g to the Wind
17. e 1 On the server machine install NDSR as described in Installing NDSR non networked On the Setup Type window choose one of the following options a To install the NDSR application along with the license folder and license service run the Typical installation OR b To install only the license folder and license service run the Custom installation On the Select Features window under the category License Service select only the option Fi le based service Page 2 14 NDSR Manual NDSR 2015 Select Features Select the features setup will install Select the features you want to install and deselect the features you do not want to install E V License Service a Description File based service Oi option iranan koan NDSR System Files cense_4 folder and Crypkey M PostScript Drivers aaa hasanabi lai 7 Z Ghostscript e g Windows 8 Server M Rich Text Support 2008 ee sis can oi f JSQL Anywhere networked by enabling the C Client SQL Anywhere eae folder as a network M Microsoft DAC x 4 gt 155 43 MB of space required on the C drive 326086 50 MB of space available on the C drive Tactic Pru ati 2 On the server machine after installing the license folder but before registering the license optionally move the license folder out of NCC ProgramData to a location that is specialized for shared network folders The license folder s default locati
18. e will be started automatically every time Windows is restarted on the server If you make a connection to one of the databases using the Connections menu you can see and manage the other databases that are running on the service Page 2 22 NDSR Manual RAF File Edit View Tools Connections Mode Help 90 09GM B8 8 P Y hex oolp Context 5 Sybase Central SQL Anywhere 16 v La Toos be se J Folders X amp SQL Anywhere 16 Sybase Central gt Servi E SQL Anywhere 16 cs Mobilink 16 i Startup gm UltraLite 16 A indsrdbserv Network Database Server Running Automatic a Relay Server 16 Ka diagnostics Network Database Server Stopped Automatic gt Refreshing service states 16 If necessary allow a firewall exception for the SQL Anywhere network database service C Program Files SQL Anywhere 16 b1n32 dbsrv16 exe on 32 bit system or C Program Files SQL Anywhere 16 bi1n64 dbsrv16 exe on a 64 bit system The service must be able to listen for unsolicited incoming traffic from NDSR client database connections by default on TCP port 2638 If another service is using TCP port 2638 on your server the SQL Anywhere network database service can be switched to another port by inserting a parameter like x tcpip port 2639 as the first parameter on the Configuration tab of the Service Properties window Each client ODBC data source will then need a TCP IP parameter like
19. host myServerNameOrAddress 2639 to find the network database service on the new port 17 Close the Sybase Central window by selecting File gt Exit If you need to troubleshoot your network service you can log startup and shutdown diagnostics to a file by inserting a parameter like Z O C temp mySgqlAnywhereStartStopLog txt as the first parameter on the Configuration tab of the Service Properties window Chapter 2 Installation Page 2 23 Diagnostics SQLANYs_ Diagnostics Service Properties General Configuration Account Dependencies This service will run the following executable z 0 C ProgramData NCC NDSR 2015 Database NetDbSrvStartuplog txt n diagnostics C ProgramData NCC NDSR 20 15 Database ndsrdb db n ndsrdb2015 C ProgramData NCC NDSR 20 15a Database ndsrdb db n ndsrdb2015a C ProgramData NCC NDSR 20 15b Database ndsrdb db n ndsrdb2015b C ProgramData NCC NDSR 20 14 Database ndsrdb db n ndsrdb2014 C ProgramData NCC NDSR 20 13 Database ndsrdb db n ndsrdb2013 C ProgramData NCC NDSR 2012 Database ndsrdb db n ndsrdb2012 B NetDbSrvStartuplog bct Notepad O x File Edit Format View Help Z 0 C ProgramData NCC NDSR 2015 Database NnetDbSrvStartuplog txt n diagnostics C ProgramData NCC NDSR 2015 Database ndsrdb db n ndsrdb2015 C ProgramData NCC NDSR 2015a Database ndsrdb db 7 16 58 n 06 09 15 16 58 11 ndsrdb2015a 06
20. ive will warn that it cannot scan for viruses due to file size select the DOWNLOAD ANYWAY button to continue Open the NDSR 2015 zip folder Select EXTRACT ALL FILES BROWSE to a location to store the files and select EXTRACT 1 Login as a member of the Administrator group Close any open applications 2 BROWSE to the file location open the setup exe file to start the installation process 3 Continue to Step 4 on the next page NOTE It is recommended that the NDSR 2015 download be stored to a location that can be accessed for future installations if necessary Files can be stored in multiple locations e g C drive network drive USB flash drive or CD The following steps describe how to install NDSR using a CD or DVD drive 1 Login as a member of the Administrators group Close any open applications 2 put the CD into the CD or DVD drive 3 If the installation process does not begin automatically start it as follows a Select Start gt Run type D Setup where D is the CD or DVD drive and select OK OR b In My Computer go to the CD or DVD drive and open the file setup exe NOTE To find your CD or DVD drive letter select Start Run and select the BROWSE button or go to My Computer or Windows Explorer Page 2 4 NDSR Manual The InstallShield Wizard window will open INDSR 2015 InstallShield Wizard Preparing to Install NDSR 2015 Setup is preparing the InstallShield Wizard which will guide you through
21. l not be reinstalled its Crypkey License service may be uninstalled by opening a Windows command line window changing directories to the NDSR license folder and executing the command Setupex u Chapter 2 Installation Page 2 13 Installing NDSR Networked NDSR can be networked so that users can share databases and or a license Potential advantages include centralized system administration and information sharing Networking requires an Amendment to your End User Software License Agreement with NCC plus additional software installations as described below NCC supports NDSR networking on Windows Server operating systems in consultation with your local system administrators Note on required technical skills networking the NDSR license and or database requires technical knowledge beyond what is required for a typical NDSR installation To network the license it is necessary to set up a shared network folder or service on the server install and register the license there grant security permissions to NDSR users and on each client computer map a drive or refer to the service and edit the NDSR configuration file To network the database it 1s necessary to configure and run a network database service make firewall exceptions modify environment variables and on each client configure network connections edit ODBC data sources and edit the NDSR configuration file Note on terminology the terms server and service
22. n by running the NDSR update for SA10 SA12 and later a Run the NDSR Custom installation to install the NDSR update for SA10 SA12 and later b Start the NDSR update for SA10 SA12 by running the executable file ndsrupdatesal0 exe c When the NDSR update for SA10 SA12 window opens select Help Help Topics from the menu and follow the instructions to complete the following updates of all client and server installations of NDSR 2007 or earlier e Update each database on the server e Update the INI file of each client NDSR installation 14 Start the new network database service with the updated databases lolx File Edit View Tools Connections Mode Help US A 8 P Y Aexo oap Context 5 Sybase Central SQL Anywhere 16 v RTs kE 5 Folders x a4 SQL Anywhere 16 W Sybase Central Services SF SQL Anywhere 16 E Mobilink 16 Startup g UltraLite 16 AM ndsrdbserv Network Database Server Stopped Automatic El Relay Server 16 z Delete Properties Starts the selected services 15 Confirm that the new service has been started If the traffic light icon is showing the green light the service has been started and is running If the icon is showing the red light the service has not yet been started To start the service select the icon with the right mouse button and choose the Start command If the startup type is automatic the servic
23. ninstall NDSR until you have unregistered it Without a confirmation code you will not be able to re register NDSR Do not uninstall NDSR until you have backed up your projects see backup and restore in Chapter 9 NDSR Utilities The following steps describe how to unregister NDSR l 4 5 Start NDSR When the Folder Project and Record Selection window opens press CTRL ALT SHIFT K on the keyboard all at the same time When the Confirm Unregister window opens select OK Confirm Unregister x o Unregister this program If you select OK you cannot run this S67 program without a password from NCC When the Program Unregistered window opens carefully record the confirmation code Select OK to unregister NDSR on this computer x WS Program Unregistered Provide the following confirmation code to NCC You will not be re authornzed unless you have provided this code ta MCE E343 oBFr F204 B308 5067 SDAB BO usb Send this confirmation code to NCC by email at ndsrhelp umn edu or by phone at 612 626 9450 NCC will then give you a password to re register NDSR on another computer Uninstall NDSR see Uninstalling NDSR Page 2 12 NDSR Manual Uninstalling NDSR You may uninstall NDSR one version at a time This allows you to move NDSR to a new computer switch to a newer version or end a study NDSR may be uninstalled only by a member of the Administrators gro
24. nts for the Folder Project and Record Selection window to open File Folder Project Record Reports Window Help Folder Project and Record Selection Folder selection Project selection Record selection id Abbreviation Record Type DSAM Name Participant ID Date of Intake Date of Entry version oa Recycle Bin New Folder New Project 3 Create a new project according to Appendix 4 NDSR Tutorials or Chapter 3 Managing NDSR Projects NOTE Projects and records created in one registration type e g Demonstration cannot be moved to a different registration type e g Research Chapter 2 Installation Page 2 9 Transferring NDSR Registration You may move a registered copy of NDSR from one computer to another or move the license folder from one drive or folder to another on the same computer by transferring the NDSR registration The following steps describe how to transfer NDSR registration from the sending computer e g the computer from which NDSR will be removed to the receiving computer e g the computer to which NDSR will be moved 1 On the receiving computer insert a removable drive e g a USB flash drive or open a network drive and create your temporary empty license transfer folder on it The NDSR registration will be transferred through this folder in a later step NOTE A CD or DVD drive will not work for this transfer even if the recording software is compatible on the
25. oad Center at https sybase subscribenet com control sybs login 2 Install SQL Anywhere When choosing installation options keep in mind that the UltraLite MobiLink and SQLRemote components are not used by NDSR If you do not require them for other applications do not install them The following two screenshots show the recommended installation options the first showing the top and the second the bottom of the option list Page 2 16 NDSR Manual 3 NOTE hg SQL Anywhere 16 InstallShield Wizard Custom Setup Select the program features you want installed Click on an icon in the list below to change how a feature is installed Feature Description Full featured relational database for Windows 64 bit editions f Databases Ee SQL Anywhere 64 bit os E v SOL Anywhere Client es E v SOL Anywhere Server a X SQL Anywhere 32 bit E v SQL Anywhere for Windows Mobil hoon Ultralite S nate Synchronization a l pant il 7 A lna This feature requires 10MB on your hard drive It has 2 of 2 subfeatures selected The subfeatures require 106MB on your hard drive Install to C Program Files SQL Anywhere 16 InstallShield ie SQL Anywhere 16 InstallShield Wizard Custom Setup Select the program features you want installed Click on an icon in the list below to change how a feature is installed
26. on is C ProgramData NCC L1cense_4 on Windows 7 and Windows 8 On the server machine share the license folder with NDSR users Every NDSR user must have the following permissions for both the share and the folder and of course the folder s contents Modify Read amp Execute List Folder Contents Read and Write This involves two sets of permissions one for the share and the other for the folder 3 On each client machine complete the following steps a Chapter 2 Installation On each client machine run the Typ1cal NDSR installation as described in Installing NDSR non networked On each client machine map a network drive to the shared license folder or determine how to address the server machine and its shared license folder using the Windows Universal Naming Convention UNC e g myServerName myShareName On each client machine open the NDSR configuration file ndSr 1n1 and find the license path on the line with the default path of License C ProgramData NCC L1cense_4 on Windows 7 and Windows 8 The default location of the NDSR configuration file ndsr ini is C ProgramData NCC NDSR 2015 on Windows 7 and Windows 8 In the NDSR configuration file that was opened in the previous step change the license path so that it addresses the shared license folder The license path may be specified in any of the following ways UNC or mapped network drive Page 2 15 e myServerlrPAddress myShare myLicenseFolder
27. ows 7 and Windows 8 Public Documents folder The required ownership of and permissions to NDSR User Data are the same on Windows 7 and Windows 8 On Windows 7 and Windows 8 it is even more important to get them right before running NDSR especially after installing earlier versions of NDSR otherwise there might be problems with Windows File Virtualization After NDSR has been installed the NCC Public Documents folder may be revealed and its required permissions verified or set as described below Verify permissions 1 Open Windows Explorer and locate the NCC Public documents folder C Users Public Publ1ic Documents NCC 2 Right click on this folder 3 Select Properties from the popup menu 4 On the Security tab and its advanced windows if necessary verify that the Administrators group has ownership and Full Control of this folder and all of its child objects 5 Verify that the SYSTEM account has full control of this folder and all of its child objects Page 2 2 NDSR Manual 6 Verify that the Users group has the following permissions in this folder and all of its child objects Modify Read amp Execute List Folder Contents Read and Write 7 Verify that no user or group in which an NDSR user or administrator is a member including Everyone lacks any of the required permissions Use of NDSR Outside of the United States When using NDSR outside of the United States the English United States computer settings
28. r otherwise open your license transfer folder On the sending computer Start NDSR When the Folder Project and Record Selection window opens select File gt Transfer Out on the menu When the Transfer Out window opens specify your license transfer folder in the Transfer Folder field Select the TRANSFER OUT button This transfers the NDSR registration from the sending computer to your license transfer folder NDSR is no longer registered on the sending computer x The following instructions describe half of the process of transferring NDSA registration from this sending computer or location to a receiving computer or location The other half of the process is described on the Transfer In window of the receiving computer The entire process is described in the NDSR user manual Please familiarize yourself with it before beginning 1 On the teceiving computer complete the Register Transfer process described in part A on the Transfer In window 2 On this sending computer s Transfer Qut window select the Browse button to locate your license transfer folder 3 Select the Transfer Out button This transfers the NDSA registration to your license transfer folder NDSA is no longer registered on this sending computer 4 If your license transter folder is on a removable drive remove it from this sending computer and insert it in the receiving computer
29. s a single networked license this process is done only once The following steps describe how to register NDSR 1 Select Start gt Programs NDSR 2015 NDSR When the Unregistered NDSR window opens select the REGISTER button x To register NDSA select the Register button below To transfer registration to this machine from a registered copy of NDSA on another machine select the Transfer button below Transfer Cancel NOTE If any message windows open before the Unregistered NDSR window report them to NCC 2 When the Unauthorized Program NDSR 2015 window opens call NCC at 612 626 9450 and provide the Site Code NCC will provide you with the Password Page 2 8 NDSR Manual Wd Unauthorized Program NDSR 2015 This program has not been authorized Provide the following Site Code and necessary agreements to NCC for a password that will authorize this program Contact NCC at 612 626 9450 for further information When NCC has provided your computer specific password enter it below When contacting NCC provide the following Site Code F042 FOCF ASDE D84C 71 Enter NCC supplied password for NDSA 2015 et Help Cancel 3 Enter the NCC supplied password and select OK NDSR will open Starting NDSR The following steps describe how to start NDSR 1 Select Start gt Programs NDSR 2015 gt NDSR 2 When the Nutrition Data System for Research logo window opens wait a few mome
30. se Destination Location Select folder where setup will install files Setup will install NDSR 2015 in the following folder To install to this folder click Next To install to a different folder dick Browse and select another folder Destination Folder C Program Files x86 NCC oxic InstallShield Page 2 6 NDSR Manual 7 When the Setup Type window opens select Typical setup and select the NEXT gt button NDSR 2015 E Setup Type Select the setup type that best suits your needs 8 When the Start Copying Files window opens select the NEXT gt button ie 2015 Start Copying Files Review settings before copying files The Setup Status window is displayed while the NDSR program files are copied from the installation CD to your computer s hard drive 9 When the InstallShield Wizard Complete window opens select FINISH This completes the installation process Chapter 2 Installation Page 2 7 NDSR 2015 InstallShield Wizard Complete Setup has finished installing NDSR 2015 on your computer lt Back j Cancel After NDSR is installed it must be registered please read Previous NDSR Registrations and Registering NDSR before installing Registering NDSR After NDSR is installed each license must be registered by obtaining a computer specific password from NCC If there is more than one non networked license this process is repeated for each one If there i
31. then customize the license path in the same way for each additional setup 8 Torun an NDSR additional setup select either Start gt Programs NDSR 2015 A NDSR OR Start Programs NDSR 2015 B gt NDSR If more customization or automation is desired an unlimited number of NDSR setups can be created manually without running the NDSR installation For each setup create an ODBC DSN and an NDSR user folder that contains only an NDSR configuration file ndsr ini an empty set of subfolders additional files backup export output and reports and a shortcut that tells the NDSR application to use this NDSR configuration file ndsr 1n1 Customize this NDSR configuration file for this DSN and these NDSR user folders or if desired shared network folders Enter the path of the NDSR configuration file at the end of the shortcut target so that it looks like the following all on one line quoting only the path of the executable C Program Files NCC NDSR 2015 ndsr exe C ProgramData NCC NDSR 2015 ndsr ini Reference Information e For information about errors in NDSR refer to Appendix 19 Troubleshooting Page 2 28 NDSR Manual
32. tinue to the download page h Download and read the documentation readMe file i Download the patch installation file j Install the patch in the same way as the SQL Anywhere version in the previous step 4 To improve server efficiency optionally remove the paths of earlier SQL Anywhere or Adaptive Server Anywhere as it was formerly known installations from the environment variable PATH 5 To further improve server performance optionally create the environment variable SATMP to identify the folder in which the SQL Anywhere network database service will write its temporary files This folder is best located on a hard drive with good capacity and speed 6 Open Sybase Central by selecting Start gt Programs SQL Anywhere 12 Administration Tools gt Sybase Central When the Sybase Central window opens select View Folders and select the item SQL Anywhere 16 in the left pane 7 Select the Services tab on the right pane right click in the empty area of the pane and select File gt New Service from the pop up menu iix File Edit View Tools Connections Mode Help e0 MGM S 8 B S YRR lool Context F Sybase Central SQL Anywhere 16 J Tools J S E Folders 1 Sybase Central I SQL Anywhere 16 H Mobilink 16 f Ultralite 16 H Relay Server 16 Page 2 18 NDSR Manual 8 When the first Create Service Wizard window opens name the new service ndsrdbserv and select the N
33. twork one NDSR 2015 database enter parameters like the following where path stands for the network database folder on your server n ndsrdbserv path ndsr 2015 database ndsrdb db n ndsrdb2015 The default parameters on Windows 7 and Windows 8 are as follows n ndsrdbserv c ProgramData ncc ndsr 2015 database ndsrdb db n ndsrdb2015 To network more than one NDSR database enter a separate line for each database In the following example the service named ndsrdbserv runs two NDSR 2015 databases one NDSR 2014 database one NDSR 2013 database and one NDSR 2012 database Page 2 20 NDSR Manual n ndsrdbserv path ndsr2015 ndsrdb db n ndsrdb2015 path ndsr2015A ndsrdb db n ndsrdb2015a path ndsr2015B ndsrdb db n ndsrdb2015b path ndsr2014 ndsrdb db n ndsrdb2014 path ndsr2013 ndsrdb db n ndsrdb2013 path ndsr2012 ndsrdb db n ndsrdb2012 Select the NEXT gt button to continue These parameters continue to be editable on the Configuration tab of the Service Properties window after the service has been created ndsrdbserv SQLANYs_ndsrdbserv Service Properties 2 x General Configuration Account Dependencies This service will run the following executable File name lc Program Files SQL Anywhere 16 Bin64 dbsrv 16 exe Browse Parameters n ndsrdbserv C ProgramData NCC NDSR 20 15 Database ndsrdb db n ndsrdb2015 C ProgramData NCCWNDSR 20 15a
34. up The following steps describe how to uninstall NDSR and optionally delete the NDSR folders l NOTE 2 Backup your projects see backup and restore in Chapter 9 NDSR Utilities When uninstalling protect your data by copying the backed up files to a secondary location e g C drive network drive USB flash drive or CD If you are continuing with NDSR unregister or transfer the license see Unregistering NDSR or Transferring NDSR Registration Select Start Settings gt Control Panel When the Control Panel window opens select ADD OR REMOVE PROGRAMS Look for NDSR 2015 in the list of programs and highlight it Select the CHANGE REMOVE button When the Welcome window opens select REMOVE and then the NEXT gt button When the Confirm Uninstall window opens select OK NDSR is uninstalled When the Maintenance Complete window opens select FINISH After backing up your data and uninstalling NDSR you may want to delete the NDSR folders including any database backup export output or report files that remain in them For your protection these user files are not deleted when NDSR is uninstalled they may only be deleted manually On Windows 7 and Windows 8 the default locations of the user files and program files are C USers Public Public Documents NCC NDSR 2015 C ProgramData NCC NDSR 2015 and C Program Files NCC NDSR 2015 or C Program Files x86 NCC NDSR 2015 on 64 bit systems If NDSR wil
35. y that installation as follows 2 Select Start gt Settings Control Panel gt ADD OR REMOVE PROGRAMS or Programs Uninstall a Program 3 In the list of installed programs select NDSR 2015 and then select the CHANGE REMOVE or Change button 4 On the InstallShield Welcome window select MODIFY then select the NEXT gt button 5 On the Select Features window expand the category Additional Setups and the subcategories A and B a To add one database select only one option under Additional Setup A e Typical installation LOCAL DATABASE e Client installation NETWORK DATABASE b To add two databases select only one option under Additional Setup A and only one option under Additional Setup B local or network database as above NOTE Do not deselect any of the currently selected options or you will uninstall them Select the NEXT gt button 6 On the Maintenance Complete window select FINISH to complete the modified installation Chapter 2 Installation Page 2 27 7 Fora Client installation create ODBC DSNs for NDSR_2015_A and or NDSR_2015_B as described in Installing NDSR Networked License and Database Part 3 NDSR Client Installations beginning on page 2 25 For a Typ1Cal installation examine the ODBC DSNs NDSR_2015_A and or NDSR_2015_B that were created above by the NDSR modified installation For any installation if the license path of the initial NDSR configuration file has been customized
Download Pdf Manuals
Related Search