Database Server. Customer is responsible for installing and maintaining the operating system on the database server. Customer may review ServiceNow’s standard installation instructions and configuration details for the database found in the Planning Guide (here).
Database Server. The MySQL server. It can also include a port number. e.g.: hostname:port or a path to a local socket e.g.: :/path/to/socket for the localhost. If the PHP directive mysql.default_host is undefined (default)‚ then the default value is localhost:3306. Database username: Default value is the name of the user that owns the server process. Database password: Default value is an empty password. For more information refer the screenshot. Common error messages Application is already installed; please remove 'config.ini' file and run this script to reinstall the application You get this error when TrackThough is already installed. To reinstall the application‚ access the installation URL after removing the config.ini file. Missing config file in the distribution source The file config.ini.original is missing from your source. Please check installation_directory/script folder for the config.ini.original file. Can't create ini file The installation directory may not have write/create permission for web user. Could not connect to MySQL Server The error indicates incorrect database particulars. Could not create database. Database already exists The database you are trying to create already exists. Select YES option for Have you already created a database? and resubmit the values. You may also want to input table prefix if you are sharing the database with other applications.
Database Server. The MySQL server. It can also include a port number. e.g.: "hostname:port" or a path to a local socket e.g.: ":/path/to/socket" for the localhost. If the PHP directive mysql.default_host is undefined (default), then the default value is localhost:3306. Database username: Default value is the name of the user that owns the server process. Database password: Default value is an empty password. For more information refer the screenshot. Common error messages "Application is already installed; please remove 'config.ini' file and run this script to reinstall the application" You get this error when TrackThough is already installed. To reinstall the application, access the installation URL after removing the 'config.ini' file. "Missing config file in the distribution source" The file 'config.ini.original' is missing from your source. Please check installation_directory/script folder for the 'config.ini.original' file. "Can't create ini file" The installation directory may not have write/create permission for web user. "Could not connect to MySQL Server" The error indicates incorrect database particulars. "Could not create database. Database already exists" The database you are trying to create already exists. Select YES option for "Have you already created a database?" and resubmit the values. You may also want to input "table prefix" if you are sharing the database with other applications. "There is no database by name " The database is not yet created; you can create the database manually and resubmit the page. Alternatively select NO option for "Have you already created a database?" and resubmit the values. "Missing sql file in the distribution source" You may have not copied the correct installation source. "Invalid config file" You may have not copied the correct installation source. Getting started Postinstall procedures Administer settings
Database Server. The CGA shall provide a recent version of Microsoft SQL Server Express or SQL Server edition. The database table used by MORe requires less than 200 megabytes.
Database Server. Server Requirements Minimum Recommended Hardware CPU Dual Xeon 2.3 GHz Dual Xeon Quad Core 3.0 GHz RAM 8 GB 16 GB Hard Drive Size 100 GB – Usable 200 GB - Usable Hard Drive RPM 10,000 15,000 Software Operating System Windows Server 2012 Windows Server 2012 Database SQL Server 2012 SQL Server 2012 DB Server Best Practices
Database Server. The MySQL server. It can also include a port number. If the PHP directive mysql.default_host is undefined (default)‚ then the default value is localhost:3306. Database username: Default value is the name of the user that owns the server process. Database password: Default value is an empty password.
Database Server. SQL Server Operating System Requirements SQL Server 2014 running on Windows Server 2012 R2 SQL Server Reporting Services Corresponds to the version and edition of SQL Server installed. Component Recommended Processor and CPU (Core) AMD or Intel, 6 Core Processor, 2.4GHz 10MB Cache Memory 24 GB Storage 2x100 GB 15k SAS RAID RAID 1
Database Server. The requirements for a database server depend primarily on the size of the EAM database and the maximum number of concurrent users. Memory on the database server is a major factor affecting EAM performance; Trapeze recommends always allowing for future expandability. For a database server dedicated to EAM, Trapeze recommends: Processors: 4 Processor Speed: 2.0+ GHz Hard Drives: 4 (RAID-5) Size: 36.2 GB each RAM: 4 GB
Database Server. SQL Server 2019 or later: • RAM (GB) -32GB recommended • # of CPU Cores – 8 recommended • Data Storage (GB) C:\ should be minimum 80 GB (Windows and Applications) D:\ - Data and Backups. Should be minimum of 500 GB– 2TB. E drive – for logs – minimum 100GB T drive for Temp Databases- Minimal 100GB, recommended 300GB. • Load balancing Optional • Always Encrypted – Optional • Annual Data Growth – 50-100GB Reporting Server Linux (preferred) or Windows 2019 or later • RAM (GB) -8 minimal, 16 recommended • # of CPU Cores - 2 minimal, 4 recommended • Data Storage primary drive - should be minimum (10GB root on Linux / 50GB C: on Windows) secondary drive (optional) - should be 100 GB (websites and report templates) WorkStation ADMIN rights to ATIMS users • RAM (GB) -32GB RAM (mainly for code deployment purpose) • Data Storage – Can be one big c drive of 200GB or 2 drives. • C drive - should be minimum 80 GB (Windows and Applications) D drive - should be 100 GB (host websites and files) • Software to be installed – Notepad++, SSMS, Edge, Postman, AWS CLI, WINSCP, .NET Core ATIMS JMS supports splitting different components (JMS / ServerAPI / Admin / Interface Engine) across infrastructure components, including load balancing for failover and high availability. Specific architecture is a joint decision between ATIMS and Agency infrastructure team. EXHIBIT J COUNTY ENTERPRISE NETWORK AND STANDARDS
Database Server. Pentium IIX/000 XXx, 0 XX XAM for up to 100 users and 2 GB for 101-500 users, RAID 5 with Online Spare (minimum of 4 matching drives), 4 18.2 GB Pluggable Universal Ultr2 SCSI 10 K RPM Hard Drive, 32x CD-ROM, SVGA monitor (800 x 600), mouse keyboard, and tape backup unit.
